Good, we confirm this is not about Postgres version
Yes I understood that what was not working was the insert done when
receiving registration through DMQ, this is also what I have been testing.
Ok only db_mode 3 is not/never working ...
In my lab, only one server is trying to insert and this is the server
receiving registration trough DMQ.
I guess we could patch to output every queries generated in module
db_postgres
On Tue, Dec 19, 2017 at 11:43 AM, Alex Balashov <abalashov(a)evaristesys.com>
wrote:
I will further note that db_mode 2 works even with
timer_interval == 1,
so this is definitely some sort of timing / race issue related to
immediate use of the DB in db_mode 3.
On Tue, Dec 19, 2017 at 02:37:01PM -0500, Alex Balashov wrote:
I have tried against PG 9.6, and reloaded all the
table schemas just to
be completely sure. The problem persists.
I should reemphasise that local usrloc storage works. It's only on the
remote peers receiving bindings via dmq_usrloc that there is a problem.
--
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/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
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/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users