<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div style="" class="">Hi Guys,</div><div style="" class=""><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">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.</div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size:
13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">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.</div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">According to the debug log it gets a segfault while parsing location data.<br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0);
font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">CPU 2.3 GHz x 2<br style="" class="">OS x64 bit debian 7.5<br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">ii opensips 1.10.1-1~1 amd64 very fast and configurable SIP server<br style=""
class="">ii opensips-carrierroute-module 1.10.1-1~1 amd64 Carrierroute module for OpenSIPS<br style="" class="">ii opensips-memcached-module 1.10.1-1~1 amd64 Interface module to interact with a memcached server<br style="" class="">ii opensips-mysql-module 1.10.1-1~1 amd64 MySQL database connectivity module for OpenSIPS<br style=""
class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br style="" class=""></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [xx)]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [udp:xxx:5060]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:14:14]<br style="" class="">Jun 3 12:25:32 [6982]
DBG:db_mysql:db_mysql_str2val: converting STRING [xxxx]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [sip:xxx@xxx:5060]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:16:40]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DOUBLE [-1.00]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [77baea9e4abc04810fc1992d56c7a2f4@xxx]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [88543]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [FPBX-2.11.0(11.5.1)]<br
style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [udp:xxxx:5060]<br style="" class="">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:14:40]<br style="" class="">Jun 3 12:25:32 [6982] DBG:usrloc:preload_udomain: loading records - cycle [1]<br style="" class="">Jun 3 12:25:32 [6977] DBG:core:wait_status_code: read code 0 ? rc = 0, errno=Success<br style="" class="">Jun 3 12:25:32 [6977] INFO:core:daemonize: pre-daemon process exiting with -1<br style="" class=""> already running.<br style="" class="">Jun 3 12:25:32 [6979] DBG:core:handle_sigs: status = 11<br style="" class="">Jun 3 12:25:32 [6979] INFO:core:handle_sigs: child process 6982 exited by a signal 11<br style="" class="">Jun 3 12:25:32 [6979] INFO:core:handle_sigs: core was not generated<br style="" class="">Jun 3 12:25:32 [6979] INFO:core:handle_sigs:
terminating due to SIGCHLD<br style="" class="">Jun 3 12:25:32 [6995] INFO:core:sig_usr: signal 15 received<br style="" class="">Jun 3 12:25:32 [6991] INFO:core:sig_usr: signal 15 received<br style="" class="">Jun 3 12:25:32 [6996] INFO:core:sig_usr: signal 15 received<br style="" class="">Jun 3 12:25:32 [6988] INFO:core:sig_usr: signal 15 received<br style="" class="">Jun 3 12:25:32 [6994] INFO:core:sig_usr: signal 15 received<br style="" class="">Jun 3 12:25:32 [6984] INFO:core:sig_usr: signal 15 received</div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Expecting an advice on this.<br></div><div class="" style="color:
rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Thanks. <br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="" style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Pasan.<br style="" class=""></div></div></body></html>