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

[Victor Seva]

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