I also saw today related error messages in syslog (below) running quite recent kamailio
master. I have these related params set:
modparam("usrloc", "db_mode", 3)
modparam("usrloc", "db_ops_ruid", 1)
modparam("usrloc", "db_check_update", 1)
Based on the above discussion, it was not clear to me if this issue has been resolved or
if I have some module parameters missing in config.
-- Juha
May 3 11:04:55 lohi /usr/bin/sip-proxy[2366]: ERROR: db_mysql [km_dbase.c:121]:
db_mysql_submit_query(): driver error on query: Duplicate entry
'uloc-5545c4ea-94a-1' for key 'ruid_idx'
May 3 11:04:55 lohi /usr/bin/sip-proxy[2366]: ERROR: <core> [db_query.c:233]:
db_do_insert_cmd(): error while submitting query
May 3 11:04:55 lohi /usr/bin/sip-proxy[2366]: ERROR: usrloc [ucontact.c:668]:
db_insert_ucontact(): inserting contact in db failed
May 3 11:04:55 lohi /usr/bin/sip-proxy[2366]: ERROR: usrloc [ucontact.c:1665]:
update_ucontact(): failed to update database
May 3 11:04:55 lohi /usr/bin/sip-proxy[2366]: ERROR: registrar [save.c:761]:
update_contacts(): failed to update contact
---
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/30#issuecomment-98454109