Hi Henning
> 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
I
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
Hi Fred
> Did you upgrade the database (assuming an upgrade from pre-5.6):
>
> https://www.kamailio.org/wikidocs/install/upgrade/5.5.x-to-5.6.0/
Yes I did. I even remember reading this article.
That is the only change, right?
-- add index on connection_id for usrloc module location table
CREAT
Did you upgrade the database (assuming an upgrade from pre-5.6):
https://www.kamailio.org/wikidocs/install/upgrade/5.5.x-to-5.6.0/
Regards,
Fred Posner
p: +1 (352) 664-3733
> On Jan 26, 2024, at 8:06 AM, Benoît Panizzon via sr-users
> wrote:
>
> Hi Henning
>
> Missed the first line with
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 ka
Hello,
are there more specific errors e.g. from the db_mysql module? Otherwise enable
query logging or checkout the DB error log might help you here.
If you run Kamailio in debug mode you will also see all the queries on that
side.
Cheers,
Henning
--
Henning Westerholt – https://skalatan.d
