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

Reply via email to