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

[Markus Bönke]

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 at gmail.com <mailto:dujinfang at 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 at bcmone.com <mailto:bkaufman at 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 at lists.kamailio.org <mailto: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 <mailto: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 <mailto: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 <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 at lists.kamailio.org <mailto: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://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users <https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users>
> 
> 
> -- 
> Work:  http://xswitch.cn
>  <http://xswitch.cn/>Community:  http://rts.cn <http://rts.cn/>
> About: http://about.me/dujinfang <http://about.me/dujinfang>
> 
> __________________________________________________________
> Kamailio - Users Mailing List - Non Commercial Discussions
> sr-users at lists.kamailio.org <mailto: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://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20221115/28f9ffe9/attachment.htm>