[OpenSIPS-Users] db_mysql segfault

Mark Carbonaro mark at iovox.com
Tue Mar 29 11:53:02 CEST 2011


Hi Vlad,

Thanks for the reply, below is the output of "bt full".

Mark

#0  0x00007fb9cd8cde57 in db_mysql_get_columns (_h=<value optimized out>,
     _r=0x796490) at res.c:71
         col = 1
         fields = <value optimized out>
         __FUNCTION__ = "db_mysql_get_columns"
#1  0x00007fb9cd8c7e36 in db_mysql_fetch_result (_h=0x7962c8,
     _r=0x7fff2a4a3e68, nrows=128) at dbase.c:849
         rows = <value optimized out>
         i = <value optimized out>
         __FUNCTION__ = "db_mysql_fetch_result"
#2  0x00007fb9cbf94889 in select_entire_dialog_table (
     dlg_hash_size=<value optimized out>) at dlg_db_handler.c:232
         __FUNCTION__ = "select_entire_dialog_table"
#3  load_dialog_info_from_db (dlg_hash_size=<value optimized out>)
     at dlg_db_handler.c:385
         res = 0x796490
         values = <value optimized out>
         rows = <value optimized out>
         i = <value optimized out>
         nr_rows = <value optimized out>
         dlg = <value optimized out>
         callid = {s = 0x3c <Address 0x3c out of bounds>, len = -870573728}
         from_uri = {s = 0xb <Address 0xb out of bounds>, len = 5153101}
---Type <return> to continue, or q <return> to quit---
         to_uri = {s = 0x1000 <Address 0x1000 out of bounds>, len = 1}
         from_tag = {s = 0x4 <Address 0x4 out of bounds>, len = -870574432}
         to_tag = {s = 0x7fb9cc1c1960 "\264S\005\315\271\177", len = 
-870574432}
         cseq1 = {s = 0x7fff2a4a3dc0 "\270*S", len = -846407113}
         cseq2 = {s = 0x7fff2a4a3db0 "\303*S", len = -870577568}
         contact1 = {s = 0x7962c8 "\240\026\034??\177", len = 7955600}
         contact2 = {s = 0x532ac9 "version", len = 7}
         rroute1 = {s = 0x532ab8 "table_name", len = 10}
         rroute2 = {s = 0x532ac3 "table_version", len = 13}
         next_id = <value optimized out>
         __FUNCTION__ = "load_dialog_info_from_db"
#4  0x00007fb9cbf961a8 in init_dlg_db (db_url=<value optimized out>,
     dlg_hash_size=4096, db_update_period=60) at dlg_db_handler.c:182
         __FUNCTION__ = "init_dlg_db"
#5  0x00007fb9cbf9046e in mod_init () at dialog.c:696
         __FUNCTION__ = "mod_init"
#6  0x000000000047b242 in init_mod (m=0x797788) at sr_module.c:457
         __FUNCTION__ = "init_mod"
#7  0x000000000047b1bf in init_mod (m=0x797ac8) at sr_module.c:452
         __FUNCTION__ = "init_mod"
#8  0x000000000047b1bf in init_mod (m=0x797b98) at sr_module.c:452
         __FUNCTION__ = "init_mod"
#9  0x000000000042b0c1 in main (argc=<value optimized out>,
---Type <return> to continue, or q <return> to quit---
     argv=0x7fff2a4a4168) at main.c:1356
         cfg_log_stderr = 0
         cfg_stream = 0x1a09010
         c = <value optimized out>
         r = <value optimized out>
         tmp = 0x50bd87 "H\215\005.\365#"
         tmp_len = <value optimized out>
         port = <value optimized out>
         proto = <value optimized out>
         ret = <value optimized out>
         seed = 4201309582
         rfd = <value optimized out>
         __FUNCTION__ = "main"


On 03/29/11 20:39, Vlad Paiu wrote:
> Hello Mark,
>
> If you still have the core dump, could you please do
>     gdb /path_to_opensips_binary path_to_core_file
>
> /and reply with the output of
>     bt full
>
> Thanks.
>
>
> Regards,
> -- 
> Vlad Paiu
> OpenSIPS Developer
>
>
> On 03/29/2011 02:44 AM, Mark Carbonaro wrote:
>> Hi,
>>
>> I have an issue when when starting opensips where it immediately 
>> segfaults in db_mysql.so.  This happens with in Centos 5.5 (plus all 
>> patches) when running VirtualBox and on a Rackspace cloud server, but 
>> works fine on an Amazon EC2 server setup in the same way (same config 
>> file, patches, package versions etc), which I find a little odd.
>>
>> I was originally running off the opensips-1.6.4-2-tls_src.tar.gz tar 
>> ball, but due to this issue I thought I would change to the latest 
>> revision of the 1.6 branch in subversion, but the problem remained.
>>
>> I build using the following command "make include_modules="db_mysql" 
>> all".
>>
>> This config is setup just as a load balancer and does work on one 
>> server, just segfaults on others.
>>
>> Please let me know if you need any more information.
>>
>> Any help would be greatly appreciated
>>
>> Regards,
>> Mark
>>
>> Here is the output from syslog when opensips starts with debug=3:
>> Mar 28 23:33:18 server opensips: INFO:core:init_tcp: using epoll_lt 
>> as the TCP io watch method (auto detected)
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> NOTICE:core:main: version: opensips 1.6.4-2-notls (x86_64/linux)
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:core:main: using 32 Mb shared memory
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:core:main: using 1 Mb private memory per process
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> NOTICE:signaling:mod_init: initializing module ...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:sl:mod_init: Initializing StateLess engine
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:tm:mod_init: TM - initializing...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:rr:mod_init: rr - initializing
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:maxfwd:mod_init: initializing...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:usrloc:ul_init_locks: locks array size 512
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:registrar:mod_init: initializing...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:textops:mod_init: initializing...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:acc:mod_init: initializing...
>> Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: 
>> INFO:dialog:mod_init: Dialog module - initializing
>> Mar 28 23:33:18 server kernel: [38083.726989] opensips[27923]: 
>> segfault at 0 ip 00007f0c1167ee57 sp 00007fffd03f7050 error 4 in 
>> db_mysql.so[7f0c11676000+e000]
>>
>> And just in case it helps with debug=6 (just the last part):
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: opening 
>> connection: mysql://xxxx:xxxx@localhost/opensips
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: connection 
>> type is Localhost via UNIX socket
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: protocol 
>> version is 10
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: server version 
>> is 5.1.56
>> Mar 28 23:35:39 [27944] DBG:core:db_do_init: connection 0x796340 
>> inserted in pool as 0x796430
>> Mar 28 23:35:39 [27944] DBG:core:db_new_result: allocate 48 bytes for 
>> result set at 0x796490
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 1 columns 
>> returned from the query
>> Mar 28 23:35:39 [27944] DBG:core:db_allocate_columns: allocate 28 
>> bytes for result columns at 0x7964d8
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 
>> RES_NAMES(0x7964e0)[0]=[table_version]
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: use DB_INT 
>> result type
>> Mar 28 23:35:39 [27944] DBG:core:db_allocate_rows: allocate 48 bytes 
>> for result rows and values at 0x796510
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_str2val: converting INT 
>> [4]
>> Mar 28 23:35:39 [27944] DBG:core:db_free_columns: freeing result 
>> columns at 0x7964d8
>> Mar 28 23:35:39 [27944] DBG:core:db_free_rows: freeing 1 rows
>> Mar 28 23:35:39 [27944] DBG:core:db_free_row: freeing row values at 
>> 0x796520
>> Mar 28 23:35:39 [27944] DBG:core:db_free_rows: freeing rows at 0x796510
>> Mar 28 23:35:39 [27944] DBG:core:db_free_result: freeing result set 
>> at 0x796490
>> Mar 28 23:35:39 [27944] DBG:core:db_new_result: allocate 48 bytes for 
>> result set at 0x796490
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 21 columns 
>> returned from the query
>> Mar 28 23:35:39 [27944] DBG:core:db_allocate_columns: allocate 588 
>> bytes for result columns at 0x79e448
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 
>> RES_NAMES(0x79e4f0)[0]=[hash_entry]
>> Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: use DB_INT 
>> result type
>> Segmentation fault (core dumped)
>>
>>
>> Finally here is my config down to the route section, this is the same 
>> config that works on the EC2 server.
>> debug=3
>> log_stderror=no
>> log_facility=LOG_LOCAL0
>> fork=yes
>> children=4
>> port=5060
>> mpath="/usr/local/lib64/opensips/modules/"
>> loadmodule "db_mysql.so"
>> loadmodule "signaling.so"
>> loadmodule "sl.so"
>> loadmodule "tm.so"
>> loadmodule "rr.so"
>> loadmodule "maxfwd.so"
>> loadmodule "usrloc.so"
>> loadmodule "registrar.so"
>> loadmodule "textops.so"
>> loadmodule "mi_fifo.so"
>> loadmodule "uri.so"
>> loadmodule "acc.so"
>> loadmodule "dialog.so"
>> loadmodule "load_balancer.so"
>> loadmodule "avpops.so"
>> modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")
>> modparam("rr", "enable_full_lr", 1)
>> modparam("rr", "append_fromtag", 0)
>> modparam("usrloc", "db_mode",   0)
>> modparam("uri", "use_uri_table", 0)
>> modparam("acc", "early_media", 1)
>> modparam("acc", "report_ack", 1)
>> modparam("acc", "report_cancels", 1)
>> modparam("acc", "detect_direction", 0)
>> modparam("acc", "failed_transaction_flag", 3)
>> modparam("acc", "log_flag", 1)
>> modparam("acc", "log_missed_flag", 2)
>> modparam("acc", "db_flag", 1)
>> modparam("acc", "db_missed_flag", 2)
>> modparam("dialog", "dlg_flag", 13)
>> modparam("dialog", "db_mode", 1)
>> modparam("dialog", "db_url", "mysql://opensips:xxx@localhost/opensips")
>> modparam("load_balancer", 
>> "db_url","mysql://opensips:xxx@127.0.0.1/opensips")
>> modparam("avpops","db_url","mysql://opensips:xxx@127.0.0.1/opensips")
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110329/a49d1fff/attachment-0001.htm>


More information about the Users mailing list