[OpenSIPS-Users] opensips crash with location data

Pasan Meemaduma pasandev at ymail.com
Thu Jun 5 05:03:56 CEST 2014


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 <bogdan at 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 at 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 at 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 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/20140604/64af656e/attachment-0001.htm>


More information about the Users mailing list