[OpenSIPS-Users] opensips crash with location data

Bogdan-Andrei Iancu bogdan at opensips.org
Thu Jun 5 13:32:28 CEST 2014


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 
> <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  <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  <mailto: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/20140605/219a1c21/attachment-0001.htm>


More information about the Users mailing list