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

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com