[OpenSIPS-Users] opensips crash with location data

Bogdan-Andrei Iancu bogdan at opensips.org
Fri Jun 6 13:28:18 CEST 2014


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  <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" 
>> <mailto:sip:xxxxxxxxxx at xxx.xxx.xxx.xx>, len = 29}
>>
>>
>> On Thursday, 5 June 2014, 8:34, Pasan Meemaduma <pasandev at ymail.com> 
>> <mailto: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 <mailto: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/20140606/40e23738/attachment-0001.htm>


More information about the Users mailing list