Re: failure in 019_replslot_limit

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: failure in 019_replslot_limit
Дата
Msg-id 20230405185514.bbietghwyh7v4zl4@awork3.anarazel.de
обсуждение исходный текст
Ответ на failure in 019_replslot_limit  (Andres Freund <andres@anarazel.de>)
Ответы Re: failure in 019_replslot_limit  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
Список pgsql-hackers
Hi,

On 2023-04-05 11:48:53 -0700, Andres Freund wrote:
> Note that a checkpoint started at "17:50:23.787", but didn't finish before the
> database was shut down.  As far as I can tell, this can not be caused by
> checkpoint_timeout, because by the time we get to invalidating replication
> slots, we already did CheckPointBuffers(), and that's the only thing that
> delays based on checkpoint_timeout.
> 
> ISTM that this indicates that checkpointer got stuck after signalling
> 344783.
> 
> Do you see any other explanation?

This all sounded vaguely familiar. After a bit bit of digging I found this:

https://postgr.es/m/20220223014855.4lsddr464i7mymk2%40alap3.anarazel.de

Which seems like it plausibly explains the failed test?

Greetings,

Andres Freund



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: failure in 019_replslot_limit
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Should vacuum process config file reload more often