Re: Race conditions in 019_replslot_limit.pl

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Race conditions in 019_replslot_limit.pl
Дата
Msg-id CAD21AoAFZAD5kzR3M8mmziQo1x94n4Jv3ZBKTPfv6k7BWDCNjA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Race conditions in 019_replslot_limit.pl  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
On Wed, Feb 16, 2022 at 3:22 PM Kyotaro Horiguchi
<horikyota.ntt@gmail.com> wrote:
>
> At Wed, 16 Feb 2022 14:58:23 +0900, Masahiko Sawada <sawada.mshk@gmail.com> wrote in
> > Or it's possible that the process took a time to clean up the
> > temporary replication slot?
>
> Checkpointer may take ReplicationSlotControlLock. Dead lock between
> ReplicationSlotCleanup and InvalidateObsoleteReplicationSlots
> happened?

That's possible. Whatever the exact cause of this failure, I think we
can stabilize this test by adding a condition of application_name to
the query.

Regards,

-- 
Masahiko Sawada
EDB:  https://www.enterprisedb.com/



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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Design of pg_stat_subscription_workers vs pgstats
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Table AM and DROP TABLE [ Was: Table AM and DDLs]