Hello Benoit, somehow the usrloc internal record id got duplicated. Are you seeing this error frequently or just on some occasions, like the restart you mentioned? You can try to activate this parameter: https://kamailio.org/docs/modules/5.7.x/modules/usrloc.html#usrloc.p.db_insert_update
Cheers, Henning > -----Original Message----- > From: Benoît Panizzon <benoit.paniz...@imp.ch> > Sent: Freitag, 26. Januar 2024 14:07 > To: Henning Westerholt <h...@gilawa.com> > Cc: Kamailio (SER) - Users Mailing List <sr-users@lists.kamailio.org> > Subject: Re: [SR-Users] usrloc database duplicate keys issue > > Hi Henning > > Missed the first line with the specific issue: > > Jan 26 07:27:45 dev-cpereg01 kamailio[2708456]: ERROR: db_mysql > [km_dbase.c:122]: db_mysql_submit_query(): driver error on query: > Duplicate entry 'uloc-65b237f8-28983d-1' for key 'location.ruid_idx' (1062) > Jan 26 07:27:45 dev-cpereg01 kamailio[2708456]: ERROR: <core> > [db_query.c:244]: db_do_insert_cmd(): error while submitting query Jan 26 > 07:27:45 dev-cpereg01 kamailio[2708456]: ERROR: usrloc [ucontact.c:686]: > db_insert_ucontact(): inserting contact in db failed somedudetp0216 (uloc- > 65b237f8-28983d-1) Jan 26 07:27:45 dev-cpereg01 kamailio[2708456]: > ERROR: usrloc [urecord.c:419]: wb_timer(): inserting contact into database > failed (aor: somedudetp0216) > > -- > Mit freundlichen Grüssen > > -Benoît Panizzon- @ HomeOffice und normal erreichbar > -- > I m p r o W a r e A G - Leiter Commerce Kunden > ______________________________________________________ > > Zurlindenstrasse 29 Tel +41 61 826 93 00 > CH-4133 Pratteln Fax +41 61 826 93 01 > Schweiz Web http://www.imp.ch > ______________________________________________________ __________________________________________________________ Kamailio - Users Mailing List - Non Commercial Discussions To unsubscribe send an email to sr-users-le...@lists.kamailio.org Important: keep the mailing list in the recipients, do not reply only to the sender! Edit mailing list options or unsubscribe:
