<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>
The schema is correct (see
<a class="moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips/blob/1.10/scripts/mysql/usrloc-create.sql">https://github.com/OpenSIPS/opensips/blob/1.10/scripts/mysql/usrloc-create.sql</a>)
- it contain the "attr" field. How did you created the location
table for 1.10 ??<br>
<br>
about the crash - looking into the bt in the next email.<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 05.06.2014 06:03, Pasan Meemaduma wrote:<br>
</div>
<blockquote
cite="mid:1401937436.41681.YahooMailNeo@web163402.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=""><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
<a class="moz-txt-link-rfc2396E" href="http://gnu.org/licenses/gpl.html"><http://gnu.org/licenses/gpl.html></a><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="">
<a class="moz-txt-link-rfc2396E" href="http://www.gnu.org/software/gdb/bugs/"><http://www.gnu.org/software/gdb/bugs/></a>...<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 <a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></a>
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 moz-do-not-send="true" 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
moz-do-not-send="true" 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 moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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
moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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>
</blockquote>
<br>
</body>
</html>