There is one more scenario for this error. Config with

modparam("usrloc", "db_ops_ruid", 1)
modparam("usrloc", "db_mode", 2)

1. location table hasn't some user "sipuser"
2. "sipuser" try to register
3. kamailio try to insert record
4. insertion failed due to timeout problem, but record was inserted
5. Try to insert and getting "Duplicate entry" every usrloc:timer_interval period up to
   • kamailio reboot
   • register expires
   • "sipuser" revoke registration (Expires: 0)

So "Duplicate entry" error can last a very long time for one record

—
Reply to this email directly or view it on GitHub.