<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span></span></div><div class="qtdSeparateBR"><br><br></div> <div style="display: block;" class="yahoo_quoted"> <div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> On Tuesday, 3 June 2014, 9:04, Pasan Meemaduma <pasandev@ymail.com> wrote:<br> </font> </div> <br><br> <div class="y_msg_container"><div id="yiv9473364515"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;"><div style="" class="yiv9473364515">Hi Guys,</div><div style="" class="yiv9473364515"><br style="" class="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515">OS x64 bit debian 7.5<br style="" class="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515">ii opensips-carrierroute-module 1.10.1-1~1 amd64 Carrierroute module for OpenSIPS<br style="" class="yiv9473364515">ii opensips-memcached-module 1.10.1-1~1 amd64 Interface module to interact with a memcached server<br style="" class="yiv9473364515">ii
opensips-mysql-module 1.10.1-1~1 amd64 MySQL database connectivity module for OpenSIPS<br style="" class="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515"></div><div class="yiv9473364515" 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="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [udp:xxx:5060]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:14:14]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982]
DBG:db_mysql:db_mysql_str2val: converting STRING [xxxx]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [sip:xxx@xxx:5060]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:16:40]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DOUBLE [-1.00]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [77baea9e4abc04810fc1992d56c7a2f4@xxx]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [88543]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting INT [0]<br style=""
class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [FPBX-2.11.0(11.5.1)]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting STRING [udp:xxxx:5060]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val: converting DATETIME [2014-06-01 01:14:40]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6982] DBG:usrloc:preload_udomain: loading records - cycle [1]<br style="" class="yiv9473364515">Jun 3 12:25:32 [6977] DBG:core:wait_status_code: read code 0 ? rc = 0, errno=Success<br style="" class="yiv9473364515">Jun 3 12:25:32 [6977] INFO:core:daemonize: pre-daemon process exiting with -1<br style="" class="yiv9473364515"> already running.<br style="" class="yiv9473364515">Jun 3 12:25:32 [6979] DBG:core:handle_sigs: status = 11<br style="" class="yiv9473364515">Jun 3 12:25:32 [6979]
INFO:core:handle_sigs: child process 6982 exited by a signal 11<br style="" class="yiv9473364515">Jun 3 12:25:32 [6979] INFO:core:handle_sigs: core was not generated<br style="" class="yiv9473364515">Jun 3 12:25:32 [6979] INFO:core:handle_sigs:
terminating due to SIGCHLD<br style="" class="yiv9473364515">Jun 3 12:25:32 [6995] INFO:core:sig_usr: signal 15 received<br style="" class="yiv9473364515">Jun 3 12:25:32 [6991] INFO:core:sig_usr: signal 15 received<br style="" class="yiv9473364515">Jun 3 12:25:32 [6996] INFO:core:sig_usr: signal 15 received<br style="" class="yiv9473364515">Jun 3 12:25:32 [6988] INFO:core:sig_usr: signal 15 received<br style="" class="yiv9473364515">Jun 3 12:25:32 [6994] INFO:core:sig_usr: signal 15 received<br style="" class="yiv9473364515">Jun 3 12:25:32 [6984] INFO:core:sig_usr: signal 15 received</div><div class="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515" 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="yiv9473364515"></div></div></div></div><br><br></div> </div> </div> </div> </div></body></html>