19 Dec
2017
19 Dec
'17
9:37 p.m.
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(a)evaristesys.com>
wrote:
db_mode 1 also does not work.
On December 19, 2017 3:05:44 PM EST, Julien Chavanton <
jchavanton(a)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(a)evaristesys.com>
wrote:
-- Alex
--
Sent via mobile, please forgive typos and brevity.
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
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(a)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(a)lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
>