<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix"><tt>Hi Pasan,<br>
<br>
Please be sure you are using the DB schema for 1.11 (see
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254">http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254</a>
) - check the DB types and the content.<br>
<br>
Also, follow this tutorial
<a class="moz-txt-link-freetext" href="http://www.opensips.org/Documentation/TroubleShooting-Crash">http://www.opensips.org/Documentation/TroubleShooting-Crash</a> in
order to extract and post here the backtrace of your crash.<br>
<br>
Regards,<br>
</tt>
<pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
On 03.06.2014 06:34, Pasan Meemaduma wrote:<br>
</div>
<blockquote
cite="mid:1401766493.91849.YahooMailNeo@web163403.mail.gq1.yahoo.com"
type="cite">
<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] <a class="moz-txt-link-freetext" href="INFO:core:daemonize">INFO:core:daemonize</a>: 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] <a class="moz-txt-link-freetext" href="INFO:core:handle_sigs">INFO:core:handle_sigs</a>: child process
6982 exited by a signal 11<br style="" class="">
Jun 3 12:25:32 [6979] <a class="moz-txt-link-freetext" href="INFO:core:handle_sigs">INFO:core:handle_sigs</a>: core was not
generated<br style="" class="">
Jun 3 12:25:32 [6979] <a class="moz-txt-link-freetext" href="INFO:core:handle_sigs">INFO:core:handle_sigs</a>: terminating due
to SIGCHLD<br style="" class="">
Jun 3 12:25:32 [6995] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: signal 15 received<br
style="" class="">
Jun 3 12:25:32 [6991] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: signal 15 received<br
style="" class="">
Jun 3 12:25:32 [6996] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: signal 15 received<br
style="" class="">
Jun 3 12:25:32 [6988] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: signal 15 received<br
style="" class="">
Jun 3 12:25:32 [6994] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: signal 15 received<br
style="" class="">
Jun 3 12:25:32 [6984] <a class="moz-txt-link-freetext" href="INFO:core:sig_usr">INFO:core:sig_usr</a>: 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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>