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

[Seven Du]

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> 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> 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
>
> __________________________________________________________
> 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://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>


-- 
Work:  http://xswitch.cn
Community:  http://rts.cn
About: http://about.me/dujinfang
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20221110/9098ea60/attachment.htm>