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