[OpenSIPS-Users] db_mysql core dump

[Duane Larson]

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
> 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 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
>> 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
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>



-- 
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20101125/6f15f37b/attachment.htm>