Re: pgsql: Allow pgoutput to send logical decoding messages.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: pgsql: Allow pgoutput to send logical decoding messages.
Дата
Msg-id CAA4eK1+faTVhxSrVthLxP6N1Smo5cdAarLtOjQwKND+meyMpJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgsql: Allow pgoutput to send logical decoding messages.  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-committers
On Tue, Apr 6, 2021 at 2:12 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Tue, Apr 6, 2021 at 8:55 AM Amit Kapila <akapila@postgresql.org> wrote:
> >
> > Allow pgoutput to send logical decoding messages.
> >
>
> One of the tests added by this commit is failing:
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sidewinder&dt=2021-04-06%2005%3A45%3A20
>
> I think there is a race condition in one of the tests. I'll analyze
> this further.
>

As this is a timing issue so not easy to reproduce but as per my
analysis in the tests, after disabling the subscription, we were not
waiting for the replication connection to drop from the publisher. So
later when the test was trying to use the same slot to fetch the
messages via SQL API, it sometimes gives an error that the replication
slot is active for other PID. I have pushed a fix for this.

-- 
With Regards,
Amit Kapila.



В списке pgsql-committers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: pgsql: Fix the tests added by commit ac4645c015.
Следующее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION