[OpenSIPS-Users] db_mysql core dump

[Bogdan-Andrei Iancu]

Hi Duane,

yes, that is...but fortunately does not provide the information I was 
hoping for....

Is it ok if I will send you a patch that will enable kind of hunting for 
this bug ?

Regards,
Bogdan

Duane Larson wrote:
> I believe this is what you wanted
>  
> (gdb) frame 2
> #2  0x00007f176faf8f22 in db_mysql_delete (_h=0x812f20, 
> _k=0x7fff61728980, _o=0x7fff61728960, _v=0x7fff61728900, _n=2) at 
> dbase.c:893
> 893                     ret = db_mysql_do_prepared_query(_h, 
> &query_holder, _v, _n, NULL, 0);
>
> (gdb) print _h
> $2 = (const db_con_t *) 0x812f20
>
> (gdb) print _h->curr_ps
> $3 = (db_ps_t *) 0x7f176c46d2b0
>
> (gdb) print (struct prep_stmt*)(*(_h)->curr_ps)
> $4 = (struct prep_stmt *) 0x813650
>
> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts
> $5 = (struct my_stmt_ctx *) 0x814d10
>
> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s
> $6 = 0x814d48 "watchersdelete from watchers where inserted_time<? AND 
> status=?.26705.61.7"
>
> (gdb) print ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s
> $7 = 0x814d50 "delete from watchers where inserted_time<? AND 
> status=?.26705.61.7"
>
> On Wed, Nov 24, 2010 at 5:29 AM, Bogdan-Andrei Iancu 
> <bogdan at voice-system.ro <mailto:bogdan at voice-system.ro>> wrote:
>
>     Hi Duane,
>
>     in frame 2 print the followings:
>       _h
>       _h->curr_ps
>       (struct prep_stmt*)(*(_h)->curr_ps)
>       ((struct prep_stmt*)(*(_h)->curr_ps))->stmts
>       ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->table.s
>       ((struct prep_stmt*)(*(_h)->curr_ps))->stmts->query.s
>
>
>     Thanks and regards,
>     Bogdan
>
>
>
>     duane.larson at gmail.com <mailto:duane.larson at gmail.com> wrote:
>
>         I searched the mailing list and couldn't find anything related
>         to this.
>
>         For the last couple of nights OpenSIPS has died on me. Each
>         time in Syslog I see
>
>         Nov 13 02:54:25 Proxy01 kernel: [1750051.944109]
>         opensips[6645]: segfault at 0 ip 00007f7fd431bafd sp
>         00007fff67048fc0 error 6 in db_mysql.so[7f7fd4311000+d
>         000]
>         Nov 13 02:54:25 Proxy01 ./opensips[6654]:
>         CRITICAL:core:receive_fd: EOF on 24
>         Nov 13 02:54:25 Proxy01 ./opensips[6631]:
>         INFO:core:handle_sigs: child process 6645 exited by a signal 11
>         Nov 13 02:54:25 Proxy01 ./opensips[6631]:
>         INFO:core:handle_sigs: core was generated
>         Nov 13 02:54:25 Proxy01 ./opensips[6631]:
>         INFO:core:handle_sigs: terminating due to SIGCHLD
>
>
>         The backtrace has the following
>
>         Core was generated by `./opensips -f
>         /usr/local/etc/opensips/opensips.cfg'.
>         Program terminated with signal 11, Segmentation fault.
>         #0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120,
>         binds=0x7ffd68, i=112) at val.c:274
>         274 *(binds[i].is_null) = 0;
>         (gdb) backtrace
>         #0 0x00007f7fd431bafd in db_mysql_val2bind (v=0x7fff67049120,
>         binds=0x7ffd68, i=112) at val.c:274
>         #1 0x00007f7fd431607a in db_mysql_do_prepared_query
>         (conn=0x7ff5f8, query=0x7f7fd452e6d0, v=0x7fff67049100, n=2,
>         uv=0x0, un=0) at dbase.c:443
>         #2 0x00007f7fd4318305 in db_mysql_delete (_h=0x7ff5f8,
>         _k=0x7fff67049180, _o=0x7fff67049160, _v=0x7fff67049100, _n=2)
>         at dbase.c:893
>         #3 0x00007f7fd0a96b10 in msg_watchers_clean (ticks=<value
>         optimized out>, param=<value optimized out>) at subscribe.c:484
>         #4 0x000000000049e3da in timer_ticker () at timer.c:325
>         #5 run_timer_process () at timer.c:395
>         #6 start_timer_processes () at timer.c:475
>         #7 0x000000000042be57 in main_loop (argc=<value optimized
>         out>, argv=0x7fff67049378) at main.c:867
>         #8 main (argc=<value optimized out>, argv=0x7fff67049378) at
>         main.c:1388
>
>
>         If need be I could also look in the MySQL logs and see what
>         the last execution was. Any ideas?
>         ------------------------------------------------------------------------
>
>
>
>         _______________________________________________
>         Users mailing list
>         Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>         http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>          
>
>
>
>     -- 
>     Bogdan-Andrei Iancu
>     OpenSIPS Bootcamp
>     15 - 19 November 2010, Edison, New Jersey, USA
>     www.voice-system.ro <http://www.voice-system.ro/>
>
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
>
> -- 
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>   


-- 
Bogdan-Andrei Iancu
OpenSIPS Bootcamp
15 - 19 November 2010, Edison, New Jersey, USA
www.voice-system.ro