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