<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
Hello Mark,<br>
<br>
If you still have the core dump, could you please do <br>
gdb <i>path_to_opensips_binary path_to_core_file<br>
<br>
</i>and reply with the output of <br>
bt full<br>
<br>
Thanks. <br>
<br>
<br>
Regards,<br>
<pre class="moz-signature" cols="72">--
Vlad Paiu
OpenSIPS Developer</pre>
<br>
<br>
On 03/29/2011 02:44 AM, Mark Carbonaro wrote:
<blockquote cite="mid:4D911D72.7070507@iovox.com" type="cite">Hi,
<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
I build using the following command "make include_modules="db_mysql"
all".
<br>
<br>
This config is setup just as a load balancer and does work on one
server, just segfaults on others.
<br>
<br>
Please let me know if you need any more information.
<br>
<br>
Any help would be greatly appreciated
<br>
<br>
Regards,
<br>
Mark
<br>
<br>
Here is the output from syslog when opensips starts with debug=3:
<br>
Mar 28 23:33:18 server opensips: INFO:core:init_tcp: using epoll_lt as
the TCP io watch method (auto detected)
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
NOTICE:core:main: version: opensips 1.6.4-2-notls (x86_64/linux)
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: INFO:core:main:
using 32 Mb shared memory
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]: INFO:core:main:
using 1 Mb private memory per process
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
NOTICE:signaling:mod_init: initializing module ...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:sl:mod_init: Initializing StateLess engine
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:tm:mod_init: TM - initializing...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:rr:mod_init: rr - initializing
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:maxfwd:mod_init: initializing...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:usrloc:ul_init_locks: locks array size 512
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:registrar:mod_init: initializing...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:textops:mod_init: initializing...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:acc:mod_init: initializing...
<br>
Mar 28 23:33:18 server /usr/local/sbin/opensips[27923]:
INFO:dialog:mod_init: Dialog module - initializing
<br>
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]
<br>
<br>
And just in case it helps with debug=6 (just the last part):
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: opening
connection: mysql://xxxx:xxxx@localhost/opensips
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: connection type
is Localhost via UNIX socket
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: protocol version
is 10
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_connect: server version
is 5.1.56
<br>
Mar 28 23:35:39 [27944] DBG:core:db_do_init: connection 0x796340
inserted in pool as 0x796430
<br>
Mar 28 23:35:39 [27944] DBG:core:db_new_result: allocate 48 bytes for
result set at 0x796490
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 1 columns
returned from the query
<br>
Mar 28 23:35:39 [27944] DBG:core:db_allocate_columns: allocate 28 bytes
for result columns at 0x7964d8
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns:
RES_NAMES(0x7964e0)[0]=[table_version]
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: use DB_INT
result type
<br>
Mar 28 23:35:39 [27944] DBG:core:db_allocate_rows: allocate 48 bytes
for result rows and values at 0x796510
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_str2val: converting INT
[4]
<br>
Mar 28 23:35:39 [27944] DBG:core:db_free_columns: freeing result
columns at 0x7964d8
<br>
Mar 28 23:35:39 [27944] DBG:core:db_free_rows: freeing 1 rows
<br>
Mar 28 23:35:39 [27944] DBG:core:db_free_row: freeing row values at
0x796520
<br>
Mar 28 23:35:39 [27944] DBG:core:db_free_rows: freeing rows at 0x796510
<br>
Mar 28 23:35:39 [27944] DBG:core:db_free_result: freeing result set at
0x796490
<br>
Mar 28 23:35:39 [27944] DBG:core:db_new_result: allocate 48 bytes for
result set at 0x796490
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: 21 columns
returned from the query
<br>
Mar 28 23:35:39 [27944] DBG:core:db_allocate_columns: allocate 588
bytes for result columns at 0x79e448
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns:
RES_NAMES(0x79e4f0)[0]=[hash_entry]
<br>
Mar 28 23:35:39 [27944] DBG:db_mysql:db_mysql_get_columns: use DB_INT
result type
<br>
Segmentation fault (core dumped)
<br>
<br>
<br>
Finally here is my config down to the route section, this is the same
config that works on the EC2 server.
<br>
debug=3
<br>
log_stderror=no
<br>
log_facility=LOG_LOCAL0
<br>
fork=yes
<br>
children=4
<br>
port=5060
<br>
mpath="/usr/local/lib64/opensips/modules/"
<br>
loadmodule "db_mysql.so"
<br>
loadmodule "signaling.so"
<br>
loadmodule "sl.so"
<br>
loadmodule "tm.so"
<br>
loadmodule "rr.so"
<br>
loadmodule "maxfwd.so"
<br>
loadmodule "usrloc.so"
<br>
loadmodule "registrar.so"
<br>
loadmodule "textops.so"
<br>
loadmodule "mi_fifo.so"
<br>
loadmodule "uri.so"
<br>
loadmodule "acc.so"
<br>
loadmodule "dialog.so"
<br>
loadmodule "load_balancer.so"
<br>
loadmodule "avpops.so"
<br>
modparam("mi_fifo", "fifo_name", "/tmp/opensips_fifo")
<br>
modparam("rr", "enable_full_lr", 1)
<br>
modparam("rr", "append_fromtag", 0)
<br>
modparam("usrloc", "db_mode", 0)
<br>
modparam("uri", "use_uri_table", 0)
<br>
modparam("acc", "early_media", 1)
<br>
modparam("acc", "report_ack", 1)
<br>
modparam("acc", "report_cancels", 1)
<br>
modparam("acc", "detect_direction", 0)
<br>
modparam("acc", "failed_transaction_flag", 3)
<br>
modparam("acc", "log_flag", 1)
<br>
modparam("acc", "log_missed_flag", 2)
<br>
modparam("acc", "db_flag", 1)
<br>
modparam("acc", "db_missed_flag", 2)
<br>
modparam("dialog", "dlg_flag", 13)
<br>
modparam("dialog", "db_mode", 1)
<br>
modparam("dialog", "db_url", "mysql://opensips:xxx@localhost/opensips")
<br>
modparam("load_balancer",
"db_url",<a class="moz-txt-link-rfc2396E" href="mailto:mysql://opensips:xxx@127.0.0.1/opensips">"mysql://opensips:xxx@127.0.0.1/opensips"</a>)
<br>
modparam("avpops","db_url",<a class="moz-txt-link-rfc2396E" href="mailto:mysql://opensips:xxx@127.0.0.1/opensips">"mysql://opensips:xxx@127.0.0.1/opensips"</a>)
<br>
<br>
<br>
_______________________________________________
<br>
Users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
<br>
</blockquote>
<br>
</body>
</html>