[Spce-user] Duplicate entry for key 'ruid_idx'

[Tóth Csaba]

Hi,

i have an asterisk server, what registers with a lot subscriber to
sipwise ce mr3.8.3 platform. Sometimes it gets back an Internal server
error, and in the kamailio-proxy log i see this:

Oct 23 11:47:06 sip proxy[4709]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-126b-4' for key 'ruid_idx'
Oct 23 11:47:08 sip proxy[4720]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-1269-a' for key 'ruid_idx'
Oct 23 11:47:20 sip proxy[4722]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915d-1273-d' for key 'ruid_idx'
Oct 23 11:47:20 sip proxy[4724]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915d-1273-d' for key 'ruid_idx'
Oct 23 11:47:20 sip proxy[4724]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-126b-4' for key 'ruid_idx'
Oct 23 11:47:20 sip proxy[4724]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-1269-a' for key 'ruid_idx'
Oct 23 11:47:25 sip proxy[4718]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-126b-4' for key 'ruid_idx'
Oct 23 11:47:29 sip proxy[4708]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-1269-a' for key 'ruid_idx'
Oct 23 11:47:40 sip proxy[4715]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915d-1273-d' for key 'ruid_idx'
Oct 23 11:47:45 sip proxy[4721]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-126b-4' for key 'ruid_idx'
Oct 23 11:48:00 sip proxy[4716]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915d-1273-d' for key 'ruid_idx'
Oct 23 11:48:05 sip proxy[4712]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-126b-4' for key 'ruid_idx'
Oct 23 11:48:13 sip proxy[4710]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915c-1269-a' for key 'ruid_idx'


As you see it happens very often.
What can be the problem, can i fix it somehow?

Here is a full log for one error:

Oct 23 14:09:31 sip proxy[4712]: NOTICE: <script>: New request on proxy
- M=REGISTER R=sip:1.1.1.1 F=sip:3611111111 at 1.1.1.1
T=sip:3611111111 at 1.1.1.1 IP=2.2.2.2:5060 (127.0.0.1:5060)
ID=1565175d707cd5490e878fa20c731a27 at 2.2.2.2 UA='Telco PBX'
Oct 23 14:09:31 sip proxy[4712]: ERROR: db_mysql [km_dbase.c:122]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5629915d-1273-d' for key 'ruid_idx'
Oct 23 14:09:31 sip proxy[4712]: ERROR: <core> [db_query.c:337]:
db_do_update(): error while submitting query
Oct 23 14:09:31 sip proxy[4712]: ERROR: usrloc [ucontact.c:869]:
db_update_ucontact_addr(): updating database failed
Oct 23 14:09:31 sip proxy[4712]: ERROR: usrloc [ucontact.c:1553]:
update_contact_db(): failed to update database
Oct 23 14:09:31 sip proxy[4712]: ERROR: registrar [save.c:775]:
update_contacts(): failed to update contact


This bug report looks like the same error
https://github.com/kamailio/kamailio/issues/30

Thanks in advance!
Csaba