Thanks for the answers. Maybe we need to add some additional trace logs in the code in one of the next versions ...

Am 09.11.2022 um 23:53 schrieb Seven Du <dujinfang@gmail.com>:

We have the same problem like 1 ~ 2 times a year with some version between 5.4 and 5.5.2, we didn't try the latest yet, and we didn't find a way to reproduce it yet.

On Wed, Nov 9, 2022 at 11:24 PM Kaufman <bkaufman@bcmone.com> wrote:
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@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@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@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&amp;data=05%7C01%7Cbkaufman%40bcmone.com%7C689296da8ce04ff6d9f808dac242662f%7Cafc1818e7b6848568913201b9396c4fc%7C1%7C0%7C638035887693322938%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&amp;sdata=UHNOJsR%2F%2FAyNdwypXLZbMa%2FsuE6dsCydpkKOxagQ7sY%3D&amp;reserved=0

__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
sr-users@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://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users


--
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
sr-users@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://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users