[OpenSIPS-Users] Opensips crashes with db_virtual

[Bogdan-Andrei Iancu]

Hi Erik,

I will investigate the db_virtual failure detection with the mysql 
statements re-init. To see if I can reproduce the crash.

Regards,
Bogdan

Erik Versaevel wrote:
> I'm guessing this has somthing to do with db_virtual crashing:
>
> May 12 08:01:06 INFO:db_mysql:re_init_statement:  query  is <insert into dialog
> (hash_entry,hash_id,callid,from_uri,from_tag,to_uri,to_tag,caller_sock,callee_sock,start_time,state,timeout,caller_cseq,callee_cseq,caller_route_set,callee_route_set,caller_contact,callee_contact
> ) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)>, ptr=(nil)
>
>
>
> Op 10-5-2010 10:45, Erik Versaevel - InfoPact Netwerkdiensten schreef:
>   
>> Hi Bogdan,
>>
>> I'm currently not using db_virtual as i don't want the server to crash :)
>> I do have the core file from the 2nd crash, but if i understand you we can't
>> use that because of the destroy_modules() ?
>>
>> If opensips crashes on me again (without using db_virtual) i'll recomple it without the
>> destroy_modules.
>>
>> Kind regards,
>>
>> Erik Versaevel
>>
>>
>>
>> Op 7-5-2010 18:10, Bogdan-Andrei Iancu schreef:
>>     
>>> Hi Erik,
>>>
>>> To avoid the core file to be overwritten, try to go in main.c file, 
>>> function  "void cleanup(int show_status)"  (around line 329) and comment 
>>> the "destroy_modules();" line  (336) .
>>>
>>> If you have the real backtrace, please post it here.
>>>
>>> Regards,
>>> bogdan
>>>
>>> Erik Versaevel wrote:
>>>       
>>>> Hi all,
>>>>
>>>> I've had some sort of migration yesterday but i ran into a couple of problems, first of which,
>>>> opensips crashed at random, i've made the following backtraces (core file of the 1st has been
>>>> overwritten by the 2nd so i won't be able to do anything with the 1st).
>>>> Switching back to the regular mysql module instead of db_virtual seemed to solve the issue.
>>>> I've had about 1800 accounts registrered on the server and calling around when it went down.
>>>>
>>>> (gdb) bt
>>>> #0 0xb77b4430 in __kernel_vsyscall ()
>>>> #1 0xb7661651 in raise () from /lib/tls/i686/cmov/libc.so.6
>>>> #2 0xb7664a82 in abort () from /lib/tls/i686/cmov/libc.so.6
>>>> #3 0xb769849d in ?? () from /lib/tls/i686/cmov/libc.so.6
>>>> #4 0xb76a2591 in ?? () from /lib/tls/i686/cmov/libc.so.6
>>>> #5 0xb76a5395 in ?? () from /lib/tls/i686/cmov/libc.so.6
>>>> #6 0xb76a6f9c in malloc () from /lib/tls/i686/cmov/libc.so.6
>>>> #7 0xb7696bf6 in open_memstream () from /lib/tls/i686/cmov/libc.so.6
>>>> #8 0xb77006f5 in __vsyslog_chk () from /lib/tls/i686/cmov/libc.so.6
>>>> #9 0xb7700c46 in __syslog_chk () from /lib/tls/i686/cmov/libc.so.6
>>>> #10 0xb760d93d in syslog (_h=0x81be420, _s=0x8189660) at /usr/include/bits/syslog.h:32
>>>> #11 db_mysql_submit_query (_h=0x81be420, _s=0x8189660) at dbase.c:136
>>>> #12 0x0811acfd in db_do_insert (_h=0x81be420, _k=0xbf85fc98, _v=0xbf85faf4, _n=21, val2str=0xb76108b5 <db_mysql_val2str>, submit_query=0xb760d60c
>>>> <db_mysql_submit_query>) at db/db_query.c:177
>>>> #13 0xb760d4c5 in db_mysql_insert (_h=0x81be420, _k=0xbf85fc98, _v=0xbf85faf4, _n=21) at dbase.c:868
>>>> #14 0xb762b894 in db_virtual_insert (_h=0x81be3e0, _k=0xbf85fc98, _v=0xbf85faf4, _n=21) at dbase.c:482
>>>> #15 0xb7255036 in dialog_update_db (ticks=0, param=0x0) at dlg_db_handler.c:960 #16 0xb724c809 in mod_destroy () at dialog.c:694
>>>> #17 0x080bdce0 in destroy_modules () at sr_module.c:370 #18 0x0806ad7a in cleanup (show_status=1) at main.c:336
>>>> #19 0x0806b8c7 in handle_sigs () at main.c:533
>>>> #20 0x0806efb3 in main_loop (argc=5, argv=0xbf85ff24) at main.c:913
>>>> #21 main (argc=5, argv=0xbf85ff24) at main.c:1388
>>>>
>>>>
>>>>
>>>>
>>>> Core was generated by `/usr/local/opensips/sbin/opensips -m 2048 -P /var/run/opensips.pid'.
>>>> Program terminated with signal 11, Segmentation fault.
>>>> #0  0xb726b522 in unref_dlg (dlg=0x373e6b38, cnt=1) at dlg_hash.c:587
>>>> 587             d_entry = &(d_table->entries[dlg->h_entry]);
>>>> (gdb) bt
>>>> #0  0xb726b522 in unref_dlg (dlg=0x373e6b38, cnt=1) at dlg_hash.c:587
>>>> #1  0xb725e724 in tmcb_unreference_dialog (t=0x373bed94, type=8192, param=0xb73642d4) at dlg_handlers.c:518
>>>> #2  0xb733dd32 in run_trans_callbacks (type=8192, trans=0x373bed94, req=0x0, rpl=0x0, code=0) at t_hooks.c:208
>>>> #3  0xb732c91b in free_cell (dead_cell=0x373bed94) at h_table.c:124
>>>> #4  0xb732c9c2 in free_hash_table () at h_table.c:342
>>>> #5  0xb7339797 in tm_shutdown () at t_funcs.c:99
>>>> #6  0x080bdce0 in destroy_modules () at sr_module.c:370
>>>> #7  0x0806ad7a in cleanup (show_status=1) at main.c:336
>>>> #8  0x0806b8c7 in handle_sigs () at main.c:533
>>>> #9  0x0806efb3 in main_loop (argc=5, argv=0xbfc71174) at main.c:913
>>>> #10 main (argc=5, argv=0xbfc71174) at main.c:1388
>>>> (gdb)
>>>>
>>>>
>>>>
>>>> Kind Regards,
>>>>
>>>> Erik
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>   
>>>>         
>>>       
>>
>> Erik Versaevel
>>
>>     
>
>
>
> Erik Versaevel
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro