9 Nov
2022
9 Nov
'22
noon
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
9 Nov
9 Nov
4:17 p.m.
Yes, I have experienced this as well.
On Nov 9, 2022, at 6:00 AM, Markus Bönke
<mb(a)tenios.de> wrote:
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(a)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
--
Alex Balashov | Principal | Evariste Systems LLC
Tel: +1-706-510-6800 / +1-800-250-5920 (toll-free)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
4:24 p.m.
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(a)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(a)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(a)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.kam…
11:53 p.m.
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(a)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(a)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(a)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(a)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.kam…
__________________________________________________________
Kamailio - Users Mailing List - Non Commercial Discussions
sr-users(a)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
15 Nov
15 Nov
4:42 p.m.
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(a)gmail.com <mailto: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(a)bcmone.com
<mailto: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(a)lists.kamailio.org
<mailto: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(a)lists.kamailio.org
<mailto: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(a)lists.kamailio.org
<mailto: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.kam…
<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(a)lists.kamailio.org <mailto: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
<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(a)lists.kamailio.org <mailto: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
534
days inactive
540
days old
4 comments
4 participants
participants (4)
-
Alex Balashov -
Kaufman -
Markus Bönke -
Seven Du