<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>no, it is not related to that :) -
see my previous 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 06.06.2014 06:35, Pasan Meemaduma wrote:<br>
</div>
<blockquote
cite="mid:1402025748.71963.YahooMailNeo@web163406.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 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 <a class="moz-txt-link-rfc2396E" href="mailto:pasandev@ymail.com"><pasandev@ymail.com></a> 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 moz-do-not-send="true"
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
<a class="moz-txt-link-rfc2396E" href="mailto:bogdan@opensips.org"><bogdan@opensips.org></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="">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 moz-do-not-send="true" 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
moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true" 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>
</blockquote>
<br>
</body>
</html>