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 <bkauf...@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-boun...@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&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 > > __________________________________________________________ > 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 > -- Work: http://xswitch.cn Community: http://rts.cn About: http://about.me/dujinfang
__________________________________________________________ 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