Re: walreceiver that is behind doesn't quit, send replies

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: walreceiver that is behind doesn't quit, send replies
Дата
Msg-id 20210511025940.rkx73zezq3hq3eae@alap3.anarazel.de
обсуждение исходный текст
Ответ на walreceiver that is behind doesn't quit, send replies  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Hi,

On 2021-05-10 19:27:55 -0700, Andres Freund wrote:
> I've a couple times gotten into a situation where I was shutting down
> the primary while the standby was behind, and the system appeared to
> just lock up, with neither primary nor standby reacting to normal
> shutdown attempts. This seems to happen more often with larger wal
> segment size...

Ah - to reproduce it, you can put a pg_usleep(10000) or so above the
pg_pwrite() in XLogWalRcvMain(). That triggers it fairly reliably for
me.

Greetings,

Andres Freund



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

Предыдущее
От: Andrey Lepikhov
Дата:
Сообщение: Re: Asynchronous Append on postgres_fdw nodes.
Следующее
От: Amit Langote
Дата:
Сообщение: update/delete and execution-time partition pruning