[OpenSIPS-Devel] segmenfault in db_mysql_do_prepared_query

Bogdan-Andrei Iancu bogdan at voice-system.ro
Sun Nov 15 18:58:09 CET 2009


Hi Inaki,

Sorry for late reply. Before the crash, is there any indication in the 
log about  a DB re-connect event (or other DB related events)?

Do you still have the core file and the corresponding binaries ? I will 
be very helpful in tracing the issue.

Thanks and regards,
Bogdan


Iñaki Baz Castillo wrote:
> Hi, opensips trunk rev 5738 working as presence server. It was running
> properly (note that there is no traffic yet, just some times). But 8
> days ago there was a segmenfault:
>
>
> (gdb) bt full
> #0  0x00007fc95c7f7197 in memcpy () from /lib/libc.so.6
> No symbol table info available.
> #1  0x00007fc95bfa14d1 in mysql_stmt_bind_param () from
> /usr/lib/libmysqlclient.so.15
> No symbol table info available.
> #2  0x00007fc95c3564fb in db_mysql_do_prepared_query (conn=0x734fe8,
> query=0x7fc95c56d6f0, v=0x7fff650ff1c0, n=9, uv=0x0, un=0) at
> dbase.c:497
>         i = 0
>         code = 9
>         cols = 7571504
>         pq_ptr = (struct prep_stmt *) 0x73c2e8
>         ctx = (struct my_stmt_ctx *) 0x73b950
>         mysql_bind = (MYSQL_BIND *) 0x73c328
>         id = <value optimized out>
>         __FUNCTION__ = "db_mysql_do_prepared_query"
> #3  0x00007fc95c357c86 in db_mysql_query (_h=0x734fe8,
> _k=0x7fff650ff300, _op=0x0, _v=0x7fff650ff1c0, _c=0x7fff650ff350,
> _n=9, _nc=7, _o=0x0, _r=0x7fff650ff3a8) at dbase.c:763
>         ret = 0
>         __FUNCTION__ = "db_mysql_query"
> #4  0x00007fc95a5cbd53 in get_database_info (msg=<value optimized
> out>, subs=0x7fff650ff5f0, reply_code=0x7fff650ff724,
> reply_str=0x7fff650ff700) at subscribe.c:1222
>         query_cols = {0x7fc95a7d5b90, 0x7fc95a7d5bd0, 0x7fc95a7d5be0,
> 0x7fc95a7d5bf0, 0x7fc95a7d5c10, 0x7fc95a7d5c00, 0x7fc95a7d5c50,
> 0x7fc95a7d5c40, 0x7fc95a7d5c30, 0x40}
>         query_vals = {{type = DB_STR, nul = 0, free = 1554811360, val
> = {int_val = 7352181, double_val = 3.6324600541067419e-317, time_val =
> 7352181,
>       string_val = 0x702f75
> "500 at sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nU"..., str_val = {
>         s = 0x702f75
> "500 at sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nU"..., len = 3}, blob_val = {
>         s = 0x702f75
> "500 at sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nU"..., len = 3}, bitmap_val = 7352181}}, {type = DB_STR,
> nul = 0, free = 1695544080, val = {int_val = 7352185,
>       double_val = 3.6324620303693252e-317, time_val = 7352185,
>       string_val = 0x702f79
> "sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nUser-"..., str_val = {
>         s = 0x702f79
> "sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nUser-"..., len = 16}, blob_val = {
>         s = 0x702f79
> "sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253.254:52189>\r\nMax-Forwards: 68\r\nEvent:
> presence\r\nUser-"..., len = 16}, bitmap_val = 7352185}}, {type =
> DB_STR, nul = 0, free = 1552178514, val = {int_val = 7352132,
>       double_val = 3.6324358448900956e-317, time_val = 7352132,
>       string_val = 0x702f44
> "30001 at sip.mydomain.net>;tag=2341707388\r\nTo:
> <sip:500 at sip.mydomain.net>;tag=13b52bc3e9f25b251a1546eb57a3a45c-28f3\r\nCall-ID:
> 3743611798 at 10.134.16.230\r\nCSeq: 30 SUBSCRIBE\r\nContact:
> <sip:30001 at 222.111.253"..., str_val = {
>
>
> Is it known bug?
>
>   




More information about the Devel mailing list