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 <linuxman...@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@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
