Im getting this error using USERLOCDB
Apr 7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
db_mysql [km_dbase.c:128]: db_mysql_submit_query(): driver error on query:
Duplicate entry '0--1' for key 'connection_idx' (1062)
Apr 7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR: <core>
[db_query.c:235]: db_do_insert_cmd(): error while submitting query
Apr 7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR: usrloc
[ucontact.c:684]: db_insert_ucontact(): inserting contact in db failed xxxx
(uloc-5706bebd-7415-3)
Apr 7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR: usrloc
[urecord.c:591]: insert_ucontact(): failed to insert in database
Apr 7 22:11:56 kamailio-int /usr/local/sbin/kamailio[29717]: ERROR:
registrar [save.c:522]: insert_contacts(): failed to insert contact
My config
# ----- usrloc params -----
/* enable DB persistency for location entries */
#!ifdef WITH_USRLOCDB
modparam("usrloc", "db_url", DBURL)
modparam("usrloc", "timer_interval", 60)
modparam("usrloc", "db_mode", 1)
modparam("usrloc", "db_timer_clean", 1)
modparam("usrloc", "use_domain", MULTIDOMAIN)
modparam("usrloc", "db_ops_ruid", 1)
modparam("usrloc", "db_check_update", 1)
#!endif
I have been using it without any problems in other installations but in a
new one with 4. KAMAILIO im getting this error. I can see registrations on
kamctl ul show but seems that option 1 is not working . Option 2 does not
update registrations from that device.
Thanks