[SR-Users] USRLOC module - Not all records are written to the db with db_mode 2

[Kaufman]

I encountered a similar problem and I believe that the issues wass with something causing an inconsistent state where kamailio was attempting to UPDATE a row that doesn't exist.. Try setting db_check_update to 1.

Kaufman


-----Original Message-----
From: sr-users <sr-users-bounces at lists.kamailio.org> On Behalf Of Markus Bönke
Sent: Wednesday, November 9, 2022 5:01 AM
To: Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
Subject: [SR-Users] USRLOC module - Not all records are written to the db with db_mode 2


Hello NG,

we are using Kamailio 5.4.2 with the USRLOC module configured with db_mode 2 (Write-Back scheme). The database is Postgres 11. Sometimes some records are not written to the database, however I can lookup them by "kamcmd ul.lookup ..." . There are no database errors (like constraint violations or value too large errors) to see in the postgres.log. Not even when I execute "kamcmd ul.flush" manually. There are also no related error messages to see in the Kamailio.log during "kamcmd ul.flush".

Has anyone else seen that issue or is this might already fixed in a newer version?

Thanks and regards

Markus


__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions sr-users at lists.kamailio.org
Important: keep the mailing list in the recipients, do not reply only to the sender!
Edit mailing list options or unsubscribe:
https://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.kamailio.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsr-users&data=05%7C01%7Cbkaufman%40bcmone.com%7C689296da8ce04ff6d9f808dac242662f%7Cafc1818e7b6848568913201b9396c4fc%7C1%7C0%7C638035887693322938%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=UHNOJsR%2F%2FAyNdwypXLZbMa%2FsuE6dsCydpkKOxagQ7sY%3D&reserved=0