[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