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: [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.