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@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@127.126.0.1:50602','2013-08-14 10:06:56',-1.00 ,'1-7590@127.126.0.1',2,0,0,'n/a',NULL,'sip:lb@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@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