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@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
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
_______________________________________________
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
