<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="">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 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 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
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;">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 style="" class="">Jun 5 12:57:26 x /usr/sbin/opensips[30177]: DBG:core:db_do_init: connection 0x7f4dc04c1c28 inserted in pool as 0x7f4dc04c1d30<br style="" class="">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 style="" class="">Jun 5 12:57:26 anacardium3backup /usr/sbin/opensips[30176]: ERROR:usrloc:preload_udomain: db_query (1) failed<br style=""
class=""><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;">:)<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;"><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 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 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;"><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="">gdb opensips core.opensips.sig11.29154<br style="" class="">GNU gdb (GDB) 7.4.1-debian<br style="" class="">Copyright (C) 2012 Free Software Foundation, Inc.<br style="" class="">License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html><br style="" class="">This is free software: you are free to change and redistribute it.<br style="" class="">There is NO WARRANTY, to the extent permitted by
law. Type "show copying"<br style="" class="">and "show warranty" for details.<br style="" class="">This GDB was configured as "x86_64-linux-gnu".<br style="" class="">For bug reporting instructions, please see:<br style="" class=""><http://www.gnu.org/software/gdb/bugs/>...<br style="" class="">Reading symbols from /usr/sbin/opensips...(no debugging symbols found)...done.<br style="" class="">[New LWP 29154]<br style="" class=""><br style="" class="">warning: Can't read pathname for load map: Input/output error.<br style="" class="">[Thread debugging using libthread_db enabled]<br style="" class="">Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".<br style="" class=""><br style="" class="">warning: no loadable sections found in added symbol-file system-supplied DSO at 0x7ffff79fe000<br style="" class="">Core was generated by `/usr/sbin/opensips -P /var/run/opensips/opensips.pid -m 512 -M 16 -u opensips -'.<br
style="" class="">Program terminated with signal 11, Segmentation fault.<br style="" class="">#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6<br style="" class="">(gdb) bt full<br style="" class="">#0 0x00007f3a71ab4f21 in ?? () from /lib/x86_64-linux-gnu/libc.so.6<br style="" class="">No symbol table info available.<br style="" class="">#1 0x00007f3a703b50a2 in preload_udomain () from /usr/lib/opensips/modules/usrloc.so<br style="" class="">No symbol table info available.<br style="" class="">#2 0x00007f3a703b8fb6 in ?? () from /usr/lib/opensips/modules/usrloc.so<br style="" class="">No symbol table info available.<br style="" class="">#3 0x000000000047c617 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#4 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#5 0x000000000047c4e7 in ?? ()<br style=""
class="">No symbol table info available.<br style="" class="">#6 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#7 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#8 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#9 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#10 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#11 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#12 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#13 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#14 0x000000000047c4e7 in ?? ()<br
style="" class="">No symbol table info available.<br style="" class="">#15 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#16 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#17 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#18 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#19 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#20 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#21 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#22 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">---Type <return> to continue, or q
<return> to quit---<br style="" class="">#23 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#24 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#25 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#26 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#27 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#28 0x000000000047c4e7 in ?? ()<br style="" class="">No symbol table info available.<br style="" class="">#29 0x00000000004186be in main ()<br style="" class="">No symbol table info available.<br style="" class=""><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 Wednesday, 4 June 2014, 17:49, Bogdan-Andrei Iancu <bogdan@opensips.org> wrote:<br style="" class=""> </font> </div> <br style="" class=""><br style="" class=""> <div style="" class=""><div style="" class="" id="yiv0892089778"><div style="" class="">
<div style="" class=""><tt style="" class="">Hi Pasan,<br style="" class="" clear="none">
<br style="" class="" clear="none">
Please be sure you are using the DB schema for 1.11 (see
<a style="" rel="nofollow" shape="rect" class="" 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 style="" class="" clear="none">
<br style="" class="" clear="none">
Also, follow this tutorial
<a style="" rel="nofollow" shape="rect" class="" 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 style="" class="" clear="none">
<br style="" class="" clear="none">
Regards,<br style="" class="" clear="none">
</tt>
<pre style="" class="">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a style="" rel="nofollow" shape="rect" class="" 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 style="" class="" clear="none">
</div>
<blockquote style="" class="" type="cite">
<div style="" class="" id="yiv0892089778yqt44517"><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 style="" class="" 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="" style="" rel="nofollow" shape="rect" class="">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="" style="" rel="nofollow" shape="rect" class="">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="" style="" rel="nofollow" shape="rect" class="">INFO:core:handle_sigs</a>: core was not
generated<br class="" style="" clear="none">
Jun 3 12:25:32 [6979] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:handle_sigs</a>: terminating due
to SIGCHLD<br class="" style="" clear="none">
Jun 3 12:25:32 [6995] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6991] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6996] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6988] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6994] <a href="" style="" rel="nofollow" shape="rect" class="">INFO:core:sig_usr</a>: signal 15 received<br class="" style="" clear="none">
Jun 3 12:25:32 [6984] <a href="" style="" rel="nofollow" shape="rect" class="">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 style="" class="" 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 style="" class="" 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 style="" class="" 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 style="" class="" 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 style="" class="" 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 style="" class="" clear="none">
<fieldset style="" class=""></fieldset>
<br style="" class="" clear="none">
<pre style="" class="">_______________________________________________
Users mailing list
<a style="" rel="nofollow" shape="rect" class="" ymailto="mailto:Users@lists.opensips.org" target="_blank" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a style="" rel="nofollow" shape="rect" class="" 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 style="" class="" clear="none">
</div></div><br style="" class=""><br style="" class=""></div> </div> </div> </div> </div></body></html>