<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 just found that I have got the key constraint wrong. Will that be the issue ?</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="">| location | CREATE TABLE `location` (<br style="" class=""> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br style="" class=""> `username` char(64) NOT NULL DEFAULT '',<br style="" class=""> `domain` char(64) DEFAULT NULL,<br style="" class=""> `contact` char(255) NOT NULL DEFAULT '',<br style="" class=""> `received` char(128) DEFAULT NULL,<br style="" class=""> `path` char(128) DEFAULT NULL,<br style="" class=""> `expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',<br style="" class=""> `q` float(10,2) NOT NULL DEFAULT '1.00',<br style="" class=""> `callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',<br style="" class=""> `cseq` int(11) NOT NULL DEFAULT '13',<br style="" class=""> `last_modified` datetime NOT NULL DEFAULT
'1900-01-01 00:00:01',<br style="" class=""> `flags` int(11) NOT NULL DEFAULT '0',<br style="" class=""> `cflags` int(11) NOT NULL DEFAULT '0',<br style="" class=""> `user_agent` char(255) NOT NULL DEFAULT '',<br style="" class=""> `socket` char(64) DEFAULT NULL,<br style="" class=""> `methods` int(11) DEFAULT NULL,<br style="" class=""> `sip_instance` char(255) DEFAULT NULL,<br style="" class=""> `attr` char(255) DEFAULT NULL,<br style="" class=""> PRIMARY KEY (`id`),<br style="" class=""> KEY `account_contact_idx` (`username`,`domain`,`contact`)<br style="" class="">) ENGINE=MyISAM AUTO_INCREMENT=25375081 DEFAULT CHARSET=latin1 |<br 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><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="">account_contact_idx is missing callid column. Will this has any relation to crash ?<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 Friday, 6 June 2014, 8:48, Pasan Meemaduma <pasandev@ymail.com> wrote:<br style="" class=""> </font> </div> <br style="" class=""><br style="" class=""> <div style="" class=""><div style="" class="" id="yiv2460888817"><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="">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 class="" style="" clear="none"></span></div> <div class="" style=""><br class="" style="" clear="none">this is the url missing attr in location table<br class="" style="" clear="none"><tt class="" style=""><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>
<br class="" style="" clear="none"><br class="" style="" clear="none"><br class="" style="" clear="none">below is my table schema,<br class="" style="" clear="none"><br class="" style="" clear="none">mysql> desc location;<br class="" style="" clear="none">+---------------+------------------+------+-----+---------------------+----------------+<br class="" style="" clear="none">| Field | Type | Null | Key | Default | Extra |<br class="" style="" clear="none">+---------------+------------------+------+-----+---------------------+----------------+<br class="" style="" clear="none">| id | int(10) unsigned | NO | PRI |
NULL | auto_increment |<br class="" style="" clear="none">|
username | char(64) | NO | MUL | | |<br class="" style="" clear="none">| domain | char(64) | YES | | NULL | |<br class="" style="" clear="none">| contact | char(255) | NO |
| | |<br class="" style="" clear="none">| received | char(128) | YES | | NULL | |<br class="" style="" clear="none">| path | char(128) | YES | | NULL | |<br class=""
style="" clear="none">|
expires | datetime | NO | | 2020-05-28 21:32:15 | |<br class="" style="" clear="none">| q | float(10,2) | NO | | 1.00 | |<br class="" style="" clear="none">| callid | char(255) | NO | | Default-Call-ID |
|<br class="" style="" clear="none">|
cseq | int(11) | NO | | 13 | |<br class="" style="" clear="none">| last_modified | datetime | NO | | 1900-01-01 00:00:01 | |<br class="" style="" clear="none">| flags | int(11) | NO | | 0
| |<br class="" style="" clear="none">| cflags | int(11) | NO | | 0 | |<br class="" style="" clear="none">| user_agent | char(255) | NO | | | |<br class="" style="" clear="none">| socket |
char(64) | YES | | NULL | |<br class="" style="" clear="none">| methods | int(11) | YES | | NULL | |<br class="" style="" clear="none">| sip_instance | char(255) | YES | | NULL
| |<br class="" style="" clear="none">| attr | char(255) | YES | | NULL | |<br class="" style="" clear="none">+---------------+------------------+------+-----+---------------------+----------------+<br class="" style="" clear="none"><br class="" style="" clear="none"><br class="" style="" clear="none">attr holds NULL values for all entries.<br class="" style="" clear="none"><br class="" style="" clear="none">do I have to run below in gdb after running bt full right ?<br class="" style="" clear="none"><br class="" style="" clear="none">this is what i got<br class=""
style="" clear="none"><br class="" style="" clear="none">(gdb) f 1<br class="" style="" clear="none">#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260) at udomain.c:306<br class="" style="" clear="none">306 in udomain.c<br class="" style="" clear="none">(gdb) p (vals+6)->val.string_val<br class="" style="" clear="none">$2 = 0x0<br class="" style="" clear="none">(gdb) <br class="" style="" clear="none"><br class="" style="" clear="none"><br class="" style="" clear="none">-----------------without running bt full ------------- just in case :)<br class="" style="" clear="none">(gdb) f 1<br class="" style="" clear="none">#1 0x00007f64823a60a2 in dbrow2info (contact=0x7fffe0246180, vals=0x7f648287a260) at udomain.c:306<br class="" style="" clear="none">306 udomain.c: No such file or directory.<br class="" style="" clear="none">(gdb) p (vals+6)->val.string_val<br class="" style="" clear="none">$1 = 0x0<br class="" style="" clear="none"><br class="" style="" clear="none"></tt></div><div style="" class=""><br style=""
class="" clear="none"><br style="" class="" clear="none"></div><div style="" class="" id="yiv2460888817yqt85628"><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, 17:07, 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="yiv2460888817" style=""><div class="" style="">
<div class="" style="">Thanks for the backtrace. In DB, what
do you have for the "attr" value ? NULL or an empty string ?<br class="" style="" clear="none">
<br class="" style="" clear="none">
In gdb, could you do:<br class="" style="" clear="none">
f 1<br class="" style="" clear="none">
p (vals+6)->val.string_val<br class="" style="" clear="none">
<br class="" style="" clear="none">
Thanks,<br class="" style="" clear="none">
<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 05.06.2014 06:15, Pasan Meemaduma wrote:<div class="" id="yiv2460888817yqtfd39564" style=""><br class="" style="" clear="none">
</div></div><div class="" id="yiv2460888817yqtfd99965" style="">
<blockquote class="" style="" 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 rel="nofollow" shape="rect" class="" style="" 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 class="" style=""><br class="" style="" clear="none">
<br class="" style="" 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 rel="nofollow" shape="rect" class="" style="" 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="yiv2460888817" 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 class="" style="" clear="none">
</div></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="yqt03407">_______________________________________________<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>