<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Thanks for the answers. Maybe we need to add some additional trace logs in the code in one of the next versions ...<br class=""><div class="">
<meta charset="UTF-8" class=""><div><br class=""></div></div><div><blockquote type="cite" class=""><div class="">Am 09.11.2022 um 23:53 schrieb Seven Du <<a href="mailto:dujinfang@gmail.com" class="">dujinfang@gmail.com</a>>:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">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.</div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Nov 9, 2022 at 11:24 PM Kaufman <<a href="mailto:bkaufman@bcmone.com" class="">bkaufman@bcmone.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">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.<br class="">
<br class="">
Kaufman<br class="">
<br class="">
<br class="">
-----Original Message-----<br class="">
From: sr-users <<a href="mailto:sr-users-bounces@lists.kamailio.org" target="_blank" class="">sr-users-bounces@lists.kamailio.org</a>> On Behalf Of Markus Bönke<br class="">
Sent: Wednesday, November 9, 2022 5:01 AM<br class="">
To: Kamailio (SER) - Users Mailing List <<a href="mailto:sr-users@lists.kamailio.org" target="_blank" class="">sr-users@lists.kamailio.org</a>><br class="">
Subject: [SR-Users] USRLOC module - Not all records are written to the db with db_mode 2<br class="">
<br class="">
<br class="">
Hello NG,<br class="">
<br class="">
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".<br class="">
<br class="">
Has anyone else seen that issue or is this might already fixed in a newer version?<br class="">
<br class="">
Thanks and regards<br class="">
<br class="">
Markus<br class="">
<br class="">
<br class="">
__________________________________________________________<br class="">
Kamailio - Users Mailing List - Non Commercial Discussions <a href="mailto:sr-users@lists.kamailio.org" target="_blank" class="">sr-users@lists.kamailio.org</a><br class="">
Important: keep the mailing list in the recipients, do not reply only to the sender!<br class="">
Edit mailing list options or unsubscribe:<br class="">
<a href="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" rel="noreferrer" target="_blank" class="">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</a><br class="">
<br class="">
__________________________________________________________<br class="">
Kamailio - Users Mailing List - Non Commercial Discussions<br class="">
<a href="mailto:sr-users@lists.kamailio.org" target="_blank" class="">sr-users@lists.kamailio.org</a><br class="">
Important: keep the mailing list in the recipients, do not reply only to the sender!<br class="">
Edit mailing list options or unsubscribe:<br class="">
<a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" rel="noreferrer" target="_blank" class="">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br class="">
</blockquote></div><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div dir="ltr" class="gmail_signature"><div dir="ltr" class="">Work: <a href="http://xswitch.cn/" target="_blank" class="">http://xswitch.cn<br class=""></a>Community: <a href="http://rts.cn/" target="_blank" class="">http://rts.cn</a><div class="">About: <a href="http://about.me/dujinfang" target="_blank" class="">http://about.me/dujinfang</a><br class=""><div class=""><div class=""><div class=""><br class=""></div></div></div></div></div></div>
__________________________________________________________<br class="">Kamailio - Users Mailing List - Non Commercial Discussions<br class=""><a href="mailto:sr-users@lists.kamailio.org" class="">sr-users@lists.kamailio.org</a><br class="">Important: keep the mailing list in the recipients, do not reply only to the sender!<br class="">Edit mailing list options or unsubscribe:<br class=""><a href="https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users" class="">https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users</a><br class=""></div></blockquote></div><br class=""></div></body></html>