<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div style="" class=""><span style="" class="">oops sorry I forgot opensips-dbg :) bt reattached.</span></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=""><span style="" class=""></span></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;"><span style="" class="">I have change some sensitive values with 'x' as below, hope it wont affect u r investigations</span></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=""><span style=""
class=""></span></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;"><span style="" class=""> contact = {s = 0xf91eab "sip:xxxxxxxxxx@xxx.xxx.xxx.xx", len = 29}<br style="" class=""></span></div> <div class="qtdSeparateBR"><br><br></div><div style="display: block;" class="yahoo_quoted"> <div class="" style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div class="" style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="" class="" dir="ltr"> <font style="" class="" face="Arial" size="2"> On Thursday, 5 June 2014, 8:34, Pasan Meemaduma <pasandev@ymail.com> wrote:<br style="" class=""> </font> </div> <br style="" class=""><br style="" class=""> <div style="" class=""><div style="" class="" id="yiv8338424817"><div style=""
class=""><div class="" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;"><div class="" style=""><span class="" style="">Hi Bogdan,</span></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 class="" style="" clear="none"><span class="" style=""></span></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;"><span class="" style="">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.</span></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
class="" style="" clear="none"><span class="" style=""></span></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 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'<br class="" style="" clear="none">Jun 5 12:57:26 x /usr/sbin/opensips[30177]: DBG:core:db_do_init: connection 0x7f4dc04c1c28 inserted in pool as 0x7f4dc04c1d30<br class="" style="" clear="none">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 ]<br class="" style="" clear="none">Jun 5 12:57:26 anacardium3backup /usr/sbin/opensips[30176]:
ERROR:usrloc:preload_udomain: db_query (1) failed<br class="" style="" clear="none"><br class="" style="" clear="none"><span class="" style=""></span></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 class="" style="" clear="none"><span class="" style=""></span></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 class="" style="" clear="none"><span class="" style=""></span></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;"><span class="" style="">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 ?</span></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 class="" style="" clear="none"><span class="" style=""></span></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 class="" style="" clear="none"><span class="" style=""></span></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;"><span class="" style="">gdb opensips core.opensips.sig11.29154<br class="" style="" clear="none">GNU gdb (GDB) 7.4.1-debian<br class="" style="" clear="none">Copyright (C) 2012 Free Software Foundation, Inc.<br class="" style="" clear="none">License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html><br class=""
style="" clear="none">This is free software: you are free to change and redistribute it.<br class="" style="" clear="none">There is NO WARRANTY, to the extent permitted by
law. Type "show copying"<br class="" style="" clear="none">and "show warranty" for details.<br class="" style="" clear="none">This GDB was configured as "x86_64-linux-gnu".<br class="" style="" clear="none">For bug reporting instructions, please see:<br class="" style="" clear="none"><http://www.gnu.org/software/gdb/bugs/>...<br class="" style="" clear="none">Reading symbols from /usr/sbin/opensips...(no debugging symbols found)...done.<br class="" style="" clear="none">[New LWP 29154]<br class="" style="" clear="none"><br class="" style="" clear="none">warning: Can't read pathname for load map: Input/output error.<br class="" style="" clear="none">[Thread debugging using libthread_db enabled]<br class="" style="" clear="none">Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".<br class="" style="" clear="none"><br class="" style="" clear="none">warning: no loadable sections found in added symbol-file system-supplied
DSO at 0x7ffff79fe000<br class="" style="" clear="none">Core was generated by `/usr/sbin/opensips -P /var/run/opensips/opensips.pid -m 512 -M 16 -u opensips -'.<br class="" style="" clear="none">Program terminated with signal 11, Segmentation fault.<br class="" style="" clear="none">#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6<br class="" style="" clear="none">(gdb) bt full<br class="" style="" clear="none">#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#1 0x00007f3a703b50a2 in preload_udomain () from /usr/lib/opensips/modules/usrloc.so<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#2 0x00007f3a703b8fb6 in ?? () from /usr/lib/opensips/modules/usrloc.so<br class="" style="" clear="none">No symbol table info available.<br class=""
style="" clear="none">#3 0x000000000047c617 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#4 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#5 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#6 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#7 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#8 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#9 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style=""
clear="none">#10 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#11 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#12 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#13 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#14 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#15 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#16 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#17 0x000000000047c4e7 in ??
()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#18 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#19 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#20 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#21 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#22 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">---Type <return> to continue, or q
<return> to quit---<br class="" style="" clear="none">#23 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#24 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#25 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#26 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#27 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#28 0x000000000047c4e7 in ?? ()<br class="" style="" clear="none">No symbol table info available.<br class="" style="" clear="none">#29 0x00000000004186be in main ()<br class="" style="" clear="none">No symbol table info available.<br class=""
style="" clear="none"><br class="" style="" clear="none"></span></div> <div style="" class=""><br style="" class="" clear="none"><br style="" class="" clear="none"></div><div style="" class="" id="yiv8338424817yqt26386"><div class="" style="display:block;"> <div class="" style="font-family:times new roman, new york, times, serif;font-size:10pt;"> <div class="" style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div class="" dir="ltr" style=""> <font class="" style="" face="Arial" size="2"> On Wednesday, 4 June 2014, 17:49, Bogdan-Andrei Iancu <bogdan@opensips.org> wrote:<br class="" style="" clear="none"> </font> </div> <br class="" style="" clear="none"><br class="" style="" clear="none"> <div class="" style=""><div class="" id="yiv8338424817" style=""><div class="" style="">
<div class="" style=""><tt class="" style="">Hi Pasan,<br class="" style="" clear="none">
<br class="" style="" clear="none">
Please be sure you are using the DB schema for 1.11 (see
<a rel="nofollow" shape="rect" class="" style="" target="_blank" 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 class="" style="" clear="none">
<br class="" style="" clear="none">
Also, follow this tutorial
<a rel="nofollow" shape="rect" class="" style="" target="_blank" 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 class="" style="" clear="none">
<br class="" style="" clear="none">
Regards,<br class="" style="" clear="none">
</tt>
<pre class="" style="">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a rel="nofollow" shape="rect" class="" style="" target="_blank" href="http://www.opensips-solutions.com/">http://www.opensips-solutions.com</a></pre>
On 03.06.2014 06:34, Pasan Meemaduma wrote:<br class="" style="" clear="none">
</div>
<blockquote class="" style="" type="cite">
<div class="" id="yiv8338424817yqt44517" style=""><div class="" style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;">
<div class="" style="">Hi Guys,</div>
<div class="" style=""><br class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
OS x64 bit debian 7.5<br class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
ii opensips-carrierroute-module
1.10.1-1~1 amd64 Carrierroute module for
OpenSIPS<br class="" style="" clear="none">
ii opensips-memcached-module
1.10.1-1~1 amd64 Interface module to
interact with a memcached server<br class="" style="" clear="none">
ii opensips-mysql-module
1.10.1-1~1 amd64 MySQL database
connectivity module for OpenSIPS<br class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [udp:xxx:5060]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting DATETIME [2014-06-01 01:14:14]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [xxxx]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [sip:xxx@xxx:5060]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting DATETIME [2014-06-01 01:16:40]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting DOUBLE [-1.00]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [77baea9e4abc04810fc1992d56c7a2f4@xxx]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting INT [88543]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting INT [0]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting INT [0]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [FPBX-2.11.0(11.5.1)]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting STRING [udp:xxxx:5060]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:db_mysql:db_mysql_str2val:
converting DATETIME [2014-06-01 01:14:40]<br class="" style="" clear="none">
Jun 3 12:25:32 [6982] DBG:usrloc:preload_udomain: loading
records - cycle [1]<br class="" style="" clear="none">
Jun 3 12:25:32 [6977] DBG:core:wait_status_code: read code 0
? rc = 0, errno=Success<br class="" style="" clear="none">
Jun 3 12:25:32 [6977] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:daemonize</a>: pre-daemon process
exiting with -1<br class="" style="" clear="none">
already running.<br class="" style="" clear="none">
Jun 3 12:25:32 [6979] DBG:core:handle_sigs: status = 11<br class="" style="" clear="none">
Jun 3 12:25:32 [6979] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:handle_sigs</a>: child process
6982 exited by a signal 11<br class="" style="" clear="none">
Jun 3 12:25:32 [6979] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:handle_sigs</a>: core was not
generated<br class="" style="" clear="none">
Jun 3 12:25:32 [6979] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:handle_sigs</a>: terminating due
to SIGCHLD<br class="" style="" clear="none">
Jun 3 12:25:32 [6995] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6991] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6996] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6988] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6994] <a href="" rel="nofollow" shape="rect" class="" style="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6984] <a href="" rel="nofollow" shape="rect" class="" style="">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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</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 class="" style="" clear="none">
</div>
</div></div>
<br class="" style="" clear="none">
<fieldset class="" style=""></fieldset>
<br class="" style="" clear="none">
<pre class="" style="">_______________________________________________
Users mailing list
<a rel="nofollow" shape="rect" class="" style="" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a rel="nofollow" shape="rect" class="" style="" target="_blank" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br class="" style="" clear="none">
</div></div><br class="" style="" clear="none"><br class="" style="" clear="none"></div> </div> </div> </div></div> </div></div></div><br style="" class=""><div style="" class="" id="yqt09145">_______________________________________________<br style="" class="" clear="none">Users mailing list<br style="" class="" clear="none"><a style="" class="" shape="rect" ymailto="mailto:Users@lists.opensips.org" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br style="" class="" clear="none"><a style="" class="" shape="rect" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br style="" class="" clear="none"></div><br style="" class=""><br style="" class=""></div> </div> </div> </div> </div></body></html>