14 Aug
2013
14 Aug
'13
11:29 a.m.
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
14 Aug
14 Aug
11:51 a.m.
New subject: usrloc error "Duplicate entry 'uloc-XXXXXXXX-XXXX-XXX' for key 'ruid_idx'"
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(a)torreviejawireless.org>rg>:
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
11:58 a.m.
New subject: usrloc error "Duplicate entry 'uloc-XXXXXXXX-XXXX-XXX' for key 'ruid_idx'"
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(a)torreviejawireless.org>rg>:
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
16 Aug
16 Aug
7:59 a.m.
New subject: usrloc error "Duplicate entry 'uloc-XXXXXXXX-XXXX-XXX' for key 'ruid_idx'"
2013/8/14 Daniel-Constantin Mierla <miconda(a)gmail.com>om>:
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.
4081
days inactive
4083
days old
3 comments
2 participants
participants (2)
-
Daniel-Constantin Mierla -
Victor Seva