I see.... Let me try to reproduce this....Thanks for the update!
Regards, bogdan Om Bikram Thapa wrote: > 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 > <[email protected]> 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 >>> <[email protected]> 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 >>>>> [email protected] >>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>> >>>>> >>>>> >>>>> >>>> >>> >> > > _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
