27 Jan
2024
27 Jan
'24
2:46 p.m.
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_ins…
Cheers,
Henning
-----Original Message-----
From: Benoît Panizzon <benoit.panizzon(a)imp.ch>
Sent: Freitag, 26. Januar 2024 14:07
To: Henning Westerholt <hw(a)gilawa.com>
Cc: Kamailio (SER) - Users Mailing List <sr-users(a)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
______________________________________________________