[OpenSIPS-Users] OpenSIPS libmysqlclient.so segfault after MySQL restart

Om Bikram Thapa om.thapa at gmail.com
Wed Feb 18 05:30:06 CET 2009


Hi Bogdan,

Just to follow up on this issue, the crash is happening even without
restarting MySQL server. It seems to show up every morning when
registration (or maybe any db operation) is performed. I think the
issue has to do with some kind of timeout related to OpenSIPS and
libmysqlclient after a long duration of inactivity.

Thanks,
Om.

On Tue, Feb 17, 2009 at 6:24 PM, Bogdan-Andrei Iancu
<bogdan at voice-system.ro> wrote:
> Hi Om,
>
> Ok - got it (2608188) - thank you again for your report.
>
> Regards,
> Bogdan
>
>
> Om Bikram Thapa wrote:
>>
>> Hi Bogdan,
>>
>> I have submitted the bug on the tracker.
>>
>> Thanks,
>> Om.
>>
>> On Tue, Feb 17, 2009 at 3:50 AM, Bogdan-Andrei Iancu
>> <bogdan at voice-system.ro> wrote:
>>
>>>
>>> Hi Om,
>>>
>>> Thanks for the report - I may have an idea what is the problem; I will
>>> try
>>> to reproduce the crash in the following days.
>>>
>>> Could you please open a bug report on the tracker - just not to forget
>>> about
>>> it :D (see http://www.opensips.org/index.php?n=Development.Tracker)
>>>
>>> Regards,
>>> Bogdan
>>>
>>> Om Bikram Thapa wrote:
>>>
>>>>
>>>> Hi,
>>>>
>>>> OpenSIPS is dying with "libmysqlclient.so Segmentation Fault" after
>>>> MySQL server restart. The log shows
>>>> "opensips[16769]: segfault at 4c8 ip 7f36728bf283 sp 7fff7ba11a90
>>>> error 4 in libmysqlclient.so.15.0.0[7f3672862000+1bf000]"
>>>>
>>>> and gdb bt shows:
>>>>
>>>> -------------
>>>> #0  0x00007f36728bf283 in mysql_stmt_result_metadata () from
>>>> /usr/lib/libmysqlclient.so.15
>>>> #1  0x00007f3672c707b7 in db_mysql_do_prepared_query (conn=0x78b278,
>>>> query=<value optimized out>, v=0x7fff7ba11d20, n=1, uv=0x0, un=0) at
>>>> dbase.c:363
>>>> #2  0x00007f3672c72e1f in db_mysql_query (_h=0x78b278, _k=<value
>>>> optimized out>, _op=<value optimized out>, _v=0x7fff7ba11d20,
>>>> _c=<value optimized out>,
>>>>   _n=1, _nc=2, _o=0x0, _r=0x7fff7ba11dc0) at dbase.c:591
>>>> #3  0x00007f366f3f0398 in authorize (_m=0x78fe98, _realm=<value
>>>> optimized out>, _table=<value optimized out>, _hftype=<value optimized
>>>> out>)
>>>>   at authorize.c:107
>>>> #4  0x000000000040f869 in do_action (a=0x780a48, msg=0x78fe98) at
>>>> action.c:961
>>>> #5  0x000000000040e7e5 in run_action_list (a=<value optimized out>,
>>>> msg=0x78fe98) at action.c:139
>>>> #6  0x000000000046f194 in eval_elem (e=0x780b18, msg=0x78fe98,
>>>> val=0x0) at route.c:1189
>>>> #7  0x00000000004708ed in eval_expr (e=0x120b1e0, msg=0x78fe98,
>>>> val=0x0) at route.c:1486
>>>> #8  0x000000000047089c in eval_expr (e=0x780b60, msg=0x78fe98,
>>>> val=0x0) at route.c:1502
>>>> #9  0x00000000004708c5 in eval_expr (e=0x780ba8, msg=0x78fe98,
>>>> val=0x0) at route.c:1507
>>>> #10 0x000000000040f91c in do_action (a=0x780f40, msg=0x78fe98) at
>>>> action.c:688
>>>> #11 0x000000000040e7e5 in run_action_list (a=<value optimized out>,
>>>> msg=0x78fe98) at action.c:139
>>>> #12 0x00000000004114d3 in do_action (a=0x781eb0, msg=0x78fe98) at
>>>> action.c:705
>>>> #13 0x000000000040e7e5 in run_action_list (a=<value optimized out>,
>>>> msg=0x78fe98) at action.c:139
>>>> #14 0x0000000000410e07 in do_action (a=0x77ee88, msg=0x78fe98) at
>>>> action.c:119
>>>> #15 0x000000000040e7e5 in run_action_list (a=<value optimized out>,
>>>> msg=0x78fe98) at action.c:139
>>>> #16 0x00000000004114d3 in do_action (a=0x77f028, msg=0x78fe98) at
>>>> action.c:705
>>>> #17 0x000000000040e7e5 in run_action_list (a=<value optimized out>,
>>>> msg=0x78fe98) at action.c:139
>>>> #18 0x00000000004125fe in run_top_route (a=0x777e78, msg=0x78fe98) at
>>>> action.c:119
>>>> #19 0x000000000045e898 in receive_msg (
>>>>   buf=0x749180 "REGISTER sip:xxxxx SIP/2.0\r\nCSeq: 2
>>>> REGISTER\r\nVia: SIP/2.0/UDP
>>>>
>>>>
>>>> x.x.x.x:5061;branch=z9hG4bK60f1b2dd-57fa-dd11-9401-0015c5404858;rport\r\nUser-Agent:
>>>> Ekiga/2.0.12\r\nAuthorization: Dige"..., len=749,
>>>> rcv_info=0x7fff7ba13530) at receive.c:165
>>>> #20 0x000000000049d3a6 in udp_rcv_loop () at udp_server.c:449
>>>> #21 0x00000000004291fb in main (argc=<value optimized out>,
>>>> argv=0x7fff7ba13718) at main.c:778
>>>> ------------
>>>>
>>>> Server runs fine after restart until MySQL is restarted again. In my
>>>> lab setup, OpenSIPS is getting killed triggered by registration
>>>> request every morning (probably due to MySQL being restarted daily
>>>> with logrotate).
>>>>
>>>> The server is the latest trunk on Debian lenny/AMD64.
>>>>
>>>> Thanks,
>>>> Om.
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>



More information about the Users mailing list