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@evaristesys.com wrote:
db_mode 1 also does not work.
On December 19, 2017 3:05:44 PM EST, Julien Chavanton < jchavanton@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@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