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
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
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 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
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
2013/8/14 Daniel-Constantin Mierla miconda@gmail.com:
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
It seems it's a problem with the VM. No errors with my tests at a real machine.
Sorry for the noise.
-
Daniel-Constantin Mierla -
Victor Seva