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