[OpenSIPS-Users] opensips crash with location data
Pasan Meemaduma
pasandev at ymail.com
Wed Jun 11 03:39:33 CEST 2014
Hi Bogdan,
appologies for my late reply. I got problem with accessing my email account from home. :(
Thanks for the help in spotting the mistake I did :'(. I'll fix the location table and see how it goes. :)
On Friday, 6 June 2014, 16:58, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:
no, it is not related to that :) - see my previous email.
Regards,
Bogdan-Andrei Iancu
OpenSIPS Founder and Developer http://www.opensips-solutions.com
On 06.06.2014 06:35, Pasan Meemaduma wrote:
Hi Bogdan,
>
>
>I just found that I have got the key constraint wrong. Will that be the issue ?
>
>
>| location | CREATE TABLE `location` (
> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> `username` char(64) NOT NULL DEFAULT '',
> `domain` char(64) DEFAULT NULL,
> `contact` char(255) NOT NULL DEFAULT '',
> `received` char(128) DEFAULT NULL,
> `path` char(128) DEFAULT NULL,
> `expires` datetime NOT NULL DEFAULT '2020-05-28 21:32:15',
> `q` float(10,2) NOT NULL DEFAULT '1.00',
> `callid` char(255) NOT NULL DEFAULT 'Default-Call-ID',
> `cseq` int(11) NOT NULL DEFAULT '13',
> `last_modified` datetime NOT NULL DEFAULT '1900-01-01
00:00:01',
> `flags` int(11) NOT NULL DEFAULT '0',
> `cflags` int(11) NOT NULL DEFAULT '0',
> `user_agent` char(255) NOT NULL DEFAULT '',
> `socket` char(64) DEFAULT NULL,
> `methods` int(11) DEFAULT NULL,
> `sip_instance` char(255) DEFAULT NULL,
> `attr` char(255) DEFAULT NULL,
> PRIMARY KEY (`id`),
> KEY `account_contact_idx` (`username`,`domain`,`contact`)
>) ENGINE=MyISAM AUTO_INCREMENT=25375081 DEFAULT
CHARSET=latin1 |
>
>
>
>account_contact_idx is missing callid column. Will this has any relation to crash ?
>
>
>
>
>On Friday, 6 June 2014, 8:48, Pasan Meemaduma <pasandev at ymail.com> wrote:
>
>
>
>Hi Bogdan,
>
>
>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 :)
>
>
>this is the url missing attr in location table
>http://www.opensips.org/Documentation/Install-DBSchema-1-10#AEN7254
>
>
>below is my table schema,
>
>mysql> desc location;
>+---------------+------------------+------+-----+---------------------+----------------+
>| Field | Type | Null |
Key | Default | Extra |
>+---------------+------------------+------+-----+---------------------+----------------+
>| id | int(10) unsigned | NO |
PRI | NULL | auto_increment |
>| username | char(64) | NO |
MUL | | |
>| domain | char(64) | YES
| | NULL | |
>| contact | char(255) | NO
| | | |
>| received | char(128) | YES
| | NULL | |
>| path | char(128) | YES
| | NULL | |
>| expires | datetime | NO
| | 2020-05-28 21:32:15 | |
>| q | float(10,2) | NO
| | 1.00 | |
>| callid | char(255) | NO
| | Default-Call-ID | |
>| cseq | int(11) | NO
| | 13 | |
>| last_modified | datetime | NO
| | 1900-01-01 00:00:01 | |
>| flags | int(11) | NO
| | 0 | |
>| cflags | int(11) | NO
| | 0 | |
>| user_agent | char(255) | NO
| | | |
>| socket | char(64) | YES
| | NULL | |
>| methods | int(11) | YES
| | NULL | |
>| sip_instance | char(255) | YES
| | NULL | |
>| attr | char(255) | YES
| | NULL | |
>+---------------+------------------+------+-----+---------------------+----------------+
>
>
>attr holds NULL values for all entries.
>
>do I have to run below in gdb after running bt
full right ?
>
>this is what i got
>
>(gdb) f 1
>#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260)
at udomain.c:306
>306 in udomain.c
>(gdb) p (vals+6)->val.string_val
>$2 = 0x0
>(gdb)
>
>
>-----------------without running bt full
------------- just in case :)
>(gdb) f 1
>#1 0x00007f64823a60a2 in dbrow2info
(contact=0x7fffe0246180, vals=0x7f648287a260)
at udomain.c:306
>306 udomain.c: No such file or directory.
>(gdb) p (vals+6)->val.string_val
>$1 = 0x0
>
>
>
>
>
>On Thursday, 5 June 2014, 17:07, Bogdan-Andrei Iancu <bogdan at opensips.org> wrote:
>
>
>
>Thanks for the backtrace. In DB, what do you have for the "attr" value ? NULL or an empty string ?
>
>In gdb, could you do:
> f 1
> p (vals+6)->val.string_val
>
>Thanks,
>
>Bogdan-Andrei Iancu
OpenSIPS Founder and Developer http://www.opensips-solutions.com
On 05.06.2014 06:15, Pasan Meemaduma wrote:
>
>
>oops sorry I forgot opensips-dbg :) bt reattached.
>>
>>
>>I have change some sensitive values with 'x' as below, hope it wont affect u r investigations
>>
>>
>> contact = {s = 0xf91eab "sip:xxxxxxxxxx at xxx.xxx.xxx.xx", len = 29}
>>
>>
>>
>>
>>On Thursday, 5 June 2014, 8:34, Pasan Meemaduma <pasandev at ymail.com> wrote:
>>
>>
>>
>>Hi Bogdan,
>>
>>
>>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.
>>
>>
>>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'
>>Jun 5
12:57:26 x
/usr/sbin/opensips[30177]:
DBG:core:db_do_init:
connection
0x7f4dc04c1c28
inserted in
pool as
0x7f4dc04c1d30
>>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
]
>>Jun 5
12:57:26
anacardium3backup
/usr/sbin/opensips[30176]:
ERROR:usrloc:preload_udomain:
db_query (1)
failed
>>
>>
>>:)
>>
>>
>>
>>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 ?
>>
>>
>>
>>
>
>
>
>
>_______________________________________________
>Users mailing list
>Users at lists.opensips.org
>http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20140610/df0ff0ad/attachment-0001.htm>
More information about the Users
mailing list