<!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 bgcolor="#ffffff" text="#000000">
Hi Vlad,<br>
<br>
Thanks for the reply, below is the output of "bt full".<br>
<br>
Mark<br>
<br>
#0 0x00007fb9cd8cde57 in db_mysql_get_columns (_h=<value
optimized out>, <br>
_r=0x796490) at res.c:71<br>
col = 1<br>
fields = <value optimized out><br>
__FUNCTION__ = "db_mysql_get_columns"<br>
#1 0x00007fb9cd8c7e36 in db_mysql_fetch_result (_h=0x7962c8, <br>
_r=0x7fff2a4a3e68, nrows=128) at dbase.c:849<br>
rows = <value optimized out><br>
i = <value optimized out><br>
__FUNCTION__ = "db_mysql_fetch_result"<br>
#2 0x00007fb9cbf94889 in select_entire_dialog_table (<br>
dlg_hash_size=<value optimized out>) at
dlg_db_handler.c:232<br>
__FUNCTION__ = "select_entire_dialog_table"<br>
#3 load_dialog_info_from_db (dlg_hash_size=<value optimized
out>)<br>
at dlg_db_handler.c:385<br>
res = 0x796490<br>
values = <value optimized out><br>
rows = <value optimized out><br>
i = <value optimized out><br>
nr_rows = <value optimized out><br>
dlg = <value optimized out><br>
callid = {s = 0x3c <Address 0x3c out of bounds>, len =
-870573728}<br>
from_uri = {s = 0xb <Address 0xb out of bounds>, len =
5153101}<br>
---Type <return> to continue, or q <return> to quit---<br>
to_uri = {s = 0x1000 <Address 0x1000 out of bounds>,
len = 1}<br>
from_tag = {s = 0x4 <Address 0x4 out of bounds>, len =
-870574432}<br>
to_tag = {s = 0x7fb9cc1c1960 "\264S\005\315\271\177", len =
-870574432}<br>
cseq1 = {s = 0x7fff2a4a3dc0 "\270*S", len = -846407113}<br>
cseq2 = {s = 0x7fff2a4a3db0 "\303*S", len = -870577568}<br>
contact1 = {s = 0x7962c8 "\240\026\034��\177", len =
7955600}<br>
contact2 = {s = 0x532ac9 "version", len = 7}<br>
rroute1 = {s = 0x532ab8 "table_name", len = 10}<br>
rroute2 = {s = 0x532ac3 "table_version", len = 13}<br>
next_id = <value optimized out><br>
__FUNCTION__ = "load_dialog_info_from_db"<br>
#4 0x00007fb9cbf961a8 in init_dlg_db (db_url=<value optimized
out>, <br>
dlg_hash_size=4096, db_update_period=60) at dlg_db_handler.c:182<br>
__FUNCTION__ = "init_dlg_db"<br>
#5 0x00007fb9cbf9046e in mod_init () at dialog.c:696<br>
__FUNCTION__ = "mod_init"<br>
#6 0x000000000047b242 in init_mod (m=0x797788) at sr_module.c:457<br>
__FUNCTION__ = "init_mod"<br>
#7 0x000000000047b1bf in init_mod (m=0x797ac8) at sr_module.c:452<br>
__FUNCTION__ = "init_mod"<br>
#8 0x000000000047b1bf in init_mod (m=0x797b98) at sr_module.c:452<br>
__FUNCTION__ = "init_mod"<br>
#9 0x000000000042b0c1 in main (argc=<value optimized out>, <br>
---Type <return> to continue, or q <return> to quit---<br>
argv=0x7fff2a4a4168) at main.c:1356<br>
cfg_log_stderr = 0<br>
cfg_stream = 0x1a09010<br>
c = <value optimized out><br>
r = <value optimized out><br>
tmp = 0x50bd87 "H\215\005.\365#"<br>
tmp_len = <value optimized out><br>
port = <value optimized out><br>
proto = <value optimized out><br>
ret = <value optimized out><br>
seed = 4201309582<br>
rfd = <value optimized out><br>
__FUNCTION__ = "main"<br>
<br>
<br>
On 03/29/11 20:39, Vlad Paiu wrote:
<blockquote cite="mid:4D91A8D4.4030201@opensips.org" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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 moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<br>
<a moz-do-not-send="true" 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>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<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>
</pre>
</blockquote>
</body>
</html>