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

[Bogdan-Andrei Iancu]

Hi Om,

There is a fix available on SVN - please update and see if it works now.

Thanks and 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
>>>
>>>
>>>       
>>     
>
>