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

[Alex Balashov]

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.