I think the null DB handle pointer is at the heart of the problem, not any problematic query...
On December 19, 2017 3:05:44 PM EST, Julien Chavanton <jchavan...@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 ><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 >> -- Alex -- Sent via mobile, please forgive typos and brevity. _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users