<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="">Thanks for the reply. I created the table using normal schema it looks fine to me. I was refering to the old url you gave me. There in that table attr was missing :)<br style="" class=""></span></div> <div style="" class=""><br style="" class="">this is the url missing attr in location table<br style="" class=""><tt style="" class=""><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>
<br style="" class=""><br style="" class=""><br style="" class="">below is my table schema,<br style="" class=""><br style="" class="">mysql> desc location;<br style="" class="">+---------------+------------------+------+-----+---------------------+----------------+<br style="" class="">| Field | Type | Null | Key | Default | Extra |<br style="" class="">+---------------+------------------+------+-----+---------------------+----------------+<br style="" class="">| id | int(10) unsigned | NO | PRI | NULL | auto_increment |<br style="" class="">|
username | char(64) | NO | MUL | | |<br style="" class="">| domain | char(64) | YES | | NULL | |<br style="" class="">| contact | char(255) | NO |
| | |<br style="" class="">| received | char(128) | YES | | NULL | |<br style="" class="">| path | char(128) | YES | | NULL | |<br style="" class="">|
expires | datetime | NO | | 2020-05-28 21:32:15 | |<br style="" class="">| q | float(10,2) | NO | | 1.00 | |<br style="" class="">| callid | char(255) | NO | | Default-Call-ID | |<br style="" class="">|
cseq | int(11) | NO | | 13 | |<br style="" class="">| last_modified | datetime | NO | | 1900-01-01 00:00:01 | |<br style="" class="">| flags | int(11) | NO | | 0
| |<br style="" class="">| cflags | int(11) | NO | | 0 | |<br style="" class="">| user_agent | char(255) | NO | | | |<br style="" class="">| socket |
char(64) | YES | | NULL | |<br style="" class="">| methods | int(11) | YES | | NULL | |<br style="" class="">| sip_instance | char(255) | YES | | NULL
| |<br style="" class="">| attr | char(255) | YES | | NULL | |<br style="" class="">+---------------+------------------+------+-----+---------------------+----------------+<br style="" class=""><br style="" class=""><br style="" class="">attr holds NULL values for all entries.<br style="" class=""><br style="" class="">do I have to run below in gdb after running bt full right ?<br style="" class=""><br style="" class="">this is what i got<br style="" class=""><br style="" class="">(gdb) f 1<br style="" class="">#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260) at udomain.c:306<br style="" class="">306 in udomain.c<br style="" class="">(gdb) p (vals+6)->val.string_val<br style="" class="">$2 = 0x0<br style="" class="">(gdb) <br style="" class=""><br style="" class=""><br style="" class="">-----------------without running bt full ------------- just in case :)<br style="" class="">(gdb) f 1<br style="" class="">#1 0x00007f64823a60a2 in dbrow2info (contact=0x7fffe0246180, vals=0x7f648287a260) at udomain.c:306<br style="" class="">306 udomain.c: No such file or directory.<br style="" class="">(gdb) p (vals+6)->val.string_val<br style="" class="">$1 = 0x0<br style="" class=""><br style="" class=""></tt></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, 17:07, 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="yiv7871063619"><div style="" class="">
<div style="" class="">Thanks for the backtrace. In DB, what
do you have for the "attr" value ? NULL or an empty string ?<br style="" class="" clear="none">
<br style="" class="" clear="none">
In gdb, could you do:<br style="" class="" clear="none">
f 1<br style="" class="" clear="none">
p (vals+6)->val.string_val<br style="" class="" clear="none">
<br style="" class="" clear="none">
Thanks,<br style="" class="" clear="none">
<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 05.06.2014 06:15, Pasan Meemaduma wrote:<div style="" class="" id="yiv7871063619yqtfd39564"><br style="" class="" clear="none">
</div></div><div style="" class="" id="yiv7871063619yqtfd99965">
<blockquote style="" class="" type="cite">
<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="">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 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 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 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=""> contact = {s = 0xf91eab
<a style="" rel="nofollow" shape="rect" class="" ymailto="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx" target="_blank" href="mailto:sip:xxxxxxxxxx@xxx.xxx.xxx.xx">"sip:xxxxxxxxxx@xxx.xxx.xxx.xx"</a>, len = 29}<br class="" style="" clear="none">
</span></div>
<div style="" class=""><br style="" class="" clear="none">
<br style="" class="" clear="none">
</div>
<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 Thursday, 5 June 2014, 8:34,
Pasan Meemaduma <a style="" rel="nofollow" shape="rect" class="" ymailto="mailto:pasandev@ymail.com" target="_blank" href="mailto:pasandev@ymail.com"><pasandev@ymail.com></a> wrote:<br class="" style="" clear="none">
</font> </div>
<br class="" style="" clear="none">
<br class="" style="" clear="none">
<div class="" style="">
<div class="" id="yiv7871063619" style="">
<div class="" style="">
<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>
<br class="" style="" clear="none">
</div>
</div>
</div>
<br class="" style="" clear="none">
</div>
</div>
</div>
</div>
</div>
</blockquote>
<br style="" class="" clear="none">
</div></div></div><br style="" class=""><br style="" class=""></div> </div> </div> </div> </div></body></html>