[SR-Users] dmq_usrloc, usrloc:db_mode 3, and PostgreSQL

[Julien Chavanton]

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 at 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 at 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 at lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20171219/991bd534/attachment.html>