oops sorry I forgot opensips-dbg :) bt reattached. I have change some sensitive values with 'x' as below, hope it wont affect u r investigations
contact = {s = 0xf91eab "sip:xxxxxxx...@xxx.xxx.xxx.xx", len = 29}
On Thursday, 5 June 2014, 8:34, Pasan Meemaduma <pasan...@ymail.com> 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
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
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
bt_full.gz
Description: GNU Zip compressed data
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
