Hi Pasan,
The schema is correct (see
https://github.com/OpenSIPS/opensips/blob/1.10/scripts/mysql/usrloc-create.sql)
- it contain the "attr" field. How did you created the location table
for 1.10 ??
about the crash - looking into the bt in the next email.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com
On 05.06.2014 06:03, Pasan Meemaduma wrote:
Hi Bogdan,
I double checked the schema and it is correct. btw doc needs fixing
its missing attr column which is needed by 1.10 for location table
otherwise I'll get below error.
Jun 5 12:57:26 x/usr/sbin/opensips[30176]:
CRITICAL:db_mysql:wrapper_single_mysql_real_query: driver error
(1054): Unknown column 'attr' in 'field list'
Jun 5 12:57:26 x /usr/sbin/opensips[30177]: DBG:core:db_do_init:
connection 0x7f4dc04c1c28 inserted in pool as 0x7f4dc04c1d30
Jun 5 12:57:26 x /usr/sbin/opensips[30176]: ERROR:core:db_do_query:
error while submitting query - [select
username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,sip_instance,attr
from location ]
Jun 5 12:57:26 anacardium3backup /usr/sbin/opensips[30176]:
ERROR:usrloc:preload_udomain: db_query (1) failed
:)
I got the backtrace as you requested , It doesn't seems right to me.
does it make any sense ? or did I miss something getting it ?
gdb opensips core.opensips.sig11.29154
GNU gdb (GDB) 7.4.1-debian
Copyright (C) 2012 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later
<http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
Reading symbols from /usr/sbin/opensips...(no debugging symbols
found)...done.
[New LWP 29154]
warning: Can't read pathname for load map: Input/output error.
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
warning: no loadable sections found in added symbol-file
system-supplied DSO at 0x7ffff79fe000
Core was generated by `/usr/sbin/opensips -P
/var/run/opensips/opensips.pid -m 512 -M 16 -u opensips -'.
Program terminated with signal 11, Segmentation fault.
#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
(gdb) bt full
#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
No symbol table info available.
#1 0x00007f3a703b50a2 in preload_udomain () from
/usr/lib/opensips/modules/usrloc.so
No symbol table info available.
#2 0x00007f3a703b8fb6 in ?? () from /usr/lib/opensips/modules/usrloc.so
No symbol table info available.
#3 0x000000000047c617 in ?? ()
No symbol table info available.
#4 0x000000000047c4e7 in ?? ()
No symbol table info available.
#5 0x000000000047c4e7 in ?? ()
No symbol table info available.
#6 0x000000000047c4e7 in ?? ()
No symbol table info available.
#7 0x000000000047c4e7 in ?? ()
No symbol table info available.
#8 0x000000000047c4e7 in ?? ()
No symbol table info available.
#9 0x000000000047c4e7 in ?? ()
No symbol table info available.
#10 0x000000000047c4e7 in ?? ()
No symbol table info available.
#11 0x000000000047c4e7 in ?? ()
No symbol table info available.
#12 0x000000000047c4e7 in ?? ()
No symbol table info available.
#13 0x000000000047c4e7 in ?? ()
No symbol table info available.
#14 0x000000000047c4e7 in ?? ()
No symbol table info available.
#15 0x000000000047c4e7 in ?? ()
No symbol table info available.
#16 0x000000000047c4e7 in ?? ()
No symbol table info available.
#17 0x000000000047c4e7 in ?? ()
No symbol table info available.
#18 0x000000000047c4e7 in ?? ()
No symbol table info available.
#19 0x000000000047c4e7 in ?? ()
No symbol table info available.
#20 0x000000000047c4e7 in ?? ()
No symbol table info available.
#21 0x000000000047c4e7 in ?? ()
No symbol table info available.
#22 0x000000000047c4e7 in ?? ()
No symbol table info available.
---Type <return> to continue, or q <return> to quit---
#23 0x000000000047c4e7 in ?? ()
No symbol table info available.
#24 0x000000000047c4e7 in ?? ()
No symbol table info available.
#25 0x000000000047c4e7 in ?? ()
No symbol table info available.
#26 0x000000000047c4e7 in ?? ()
No symbol table info available.
#27 0x000000000047c4e7 in ?? ()
No symbol table info available.
#28 0x000000000047c4e7 in ?? ()
No symbol table info available.
#29 0x00000000004186be in main ()
No symbol table info available.
On Wednesday, 4 June 2014, 17:49, Bogdan-Andrei Iancu
<bog...@opensips.org> wrote:
Hi Pasan,
Please be sure you are using the DB schema for 1.11 (see
http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254 )
- check the DB types and the content.
Also, follow this tutorial
http://www.opensips.org/Documentation/TroubleShooting-Crash in order
to extract and post here the backtrace of your crash.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com <http://www.opensips-solutions.com/>
On 03.06.2014 06:34, Pasan Meemaduma wrote:
Hi Guys,
I recently migrate a opensips 1.5.3 server to a 1.10.1. Everything
went fine expect I couldn't bring up opensips with old location data
it crashes everytime there's data in location table, I have even fix
the column count before starting opensips. when I delete all records
from location table and then start opensips it works fine.
So now everytime I have to restart opensips I have to delete location
table entries. Could you please check if this a bug, I have attach
the debug trace here.
According to the debug log it gets a segfault while parsing location
data.
CPU 2.3 GHz x 2
OS x64 bit debian 7.5
ii opensips 1.10.1-1~1 amd64 very fast and
configurable SIP server
ii opensips-carrierroute-module 1.10.1-1~1 amd64
Carrierroute module for OpenSIPS
ii opensips-memcached-module 1.10.1-1~1 amd64
Interface module to interact with a memcached server
ii opensips-mysql-module 1.10.1-1~1 amd64
MySQL database connectivity module for OpenSIPS
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [xx)]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [udp:xxx:5060]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
DATETIME [2014-06-01 01:14:14]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [xxxx]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [sip:xxx@xxx:5060]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
DATETIME [2014-06-01 01:16:40]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
DOUBLE [-1.00]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [77baea9e4abc04810fc1992d56c7a2f4@xxx]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT
[88543]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [FPBX-2.11.0(11.5.1)]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
STRING [udp:xxxx:5060]
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting
DATETIME [2014-06-01 01:14:40]
Jun 3 12:25:32 [6982] DBG:usrloc:preload_udomain: loading records -
cycle [1]
Jun 3 12:25:32 [6977] DBG:core:wait_status_code: read code 0 ? rc =
0, errno=Success
Jun 3 12:25:32 [6977] INFO:core:daemonize: pre-daemon process
exiting with -1
already running.
Jun 3 12:25:32 [6979] DBG:core:handle_sigs: status = 11
Jun 3 12:25:32 [6979] INFO:core:handle_sigs: child process 6982
exited by a signal 11
Jun 3 12:25:32 [6979] INFO:core:handle_sigs: core was not generated
Jun 3 12:25:32 [6979] INFO:core:handle_sigs: terminating due to SIGCHLD
Jun 3 12:25:32 [6995] INFO:core:sig_usr: signal 15 received
Jun 3 12:25:32 [6991] INFO:core:sig_usr: signal 15 received
Jun 3 12:25:32 [6996] INFO:core:sig_usr: signal 15 received
Jun 3 12:25:32 [6988] INFO:core:sig_usr: signal 15 received
Jun 3 12:25:32 [6994] INFO:core:sig_usr: signal 15 received
Jun 3 12:25:32 [6984] INFO:core:sig_usr: signal 15 received
Expecting an advice on this.
Thanks.
Pasan.
_______________________________________________
Users mailing list
Users@lists.opensips.org <mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
