[SR-Users] usrloc error "Duplicate entry 'uloc-XXXXXXXX-XXXX-XXX' for key 'ruid_idx'"

[Daniel-Constantin Mierla]

Provided that you haven't restarted (or if you did it, reproduce it 
again), can you send:

- output of kamctl ps
- the record from the database that matches the same ruid
- if you restarted, send the error logs, too

Cheers,
Daniel

On 8/14/13 11:51 AM, Victor Seva wrote:
> More info with an error example:
>
> db_mode=1
>
> kamailio error:
> --------------------
> Aug 14 09:57:01 spce proxy[4256]: ERROR: db_mysql [km_dbase.c:122]:
> db_mysql_submit_query(): driver error on query: Duplicate entry
>   'uloc-520a328b-10a0-f51' for key 'ruid_idx'
> Aug 14 09:57:01 spce proxy[4256]: ERROR: <core> [db_query.c:235]:
> db_do_insert_cmd(): error while submitting query
> Aug 14 09:57:01 spce proxy[4256]: ERROR: usrloc [ucontact.c:615]:
> db_insert_ucontact(): inserting contact in db failed
> Aug 14 09:57:01 spce proxy[4256]: ERROR: usrloc [urecord.c:479]:
> insert_ucontact(): failed to insert in database
> Aug 14 09:57:01 spce proxy[4256]: ERROR: registrar [save.c:498]:
> insert_contacts(): failed to insert contact
>
> /var/log/mysql/slow-queries.log:
> --------------------------------------------
> # Time: 130814  9:57:01
> # User at Host: kamailio[kamailio] @ localhost []
> # Query_time: 5.205785  Lock_time: 0.000071 Rows_sent: 0  Rows_examined: 0
> SET timestamp=1376467021;
> insert into location
> (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,received,path,socket,methods,last_modified,ruid,instance,reg_id,domain
> ) values ('testuser1003','sip:testuser1003 at 127.126.0.1:50602','2013-08-14
> 10:06:56',-1.00
> ,'1-7590 at 127.126.0.1',2,0,0,'n/a',NULL,'<sip:lb at 127.0.0.1;lr;socket=sip:127.0.0.1:5060>','udp:127.0.0.1:5062',NULL,'2013-08-14
> 09:56:56','uloc-520a328b-10a0-f51',NULL,0,'spce.test');
>
> 2013/8/14 Victor Seva <linuxmaniac at torreviejawireless.org>:
>> Hello,
>>
>> I'm getting this kind of error running my unit test scenarios from
>> time to time with no obvious reason, same tests usually runs without
>> problems.
>>
>> Any pointers to figure out what is the problem?
>>
>> Cheers,
>> Victor
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda