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

[Julien Chavanton]

Right looking back at your initial logs the DB handle is null when it
should not be.

Wonder where is it lost, we may need to run in debug mode to follow what is
going on in db_postgress

On Tue, Dec 19, 2017 at 12:08 PM, Alex Balashov <abalashov at evaristesys.com>
wrote:

> db_mode 1 also does not work.
>
> On December 19, 2017 3:05:44 PM EST, Julien Chavanton <
> jchavanton at gmail.com> wrote:
> >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
> >>
>
>
> -- Alex
>
> --
> Sent via mobile, please forgive typos and brevity.
>
> _______________________________________________
> 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/1bf42600/attachment.html>