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 <abalas...@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 >
_______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users