Re: pgsql: Ensure that a standby is able to follow a primary on a newer tim

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pgsql: Ensure that a standby is able to follow a primary on a newer tim
Дата
Msg-id fae8015c-ee1a-281b-e76e-573a6124652c@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: pgsql: Ensure that a standby is able to follow a primary on a newer tim  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers

On 2021/01/14 14:23, Tom Lane wrote:
> Fujii Masao <masao.fujii@oss.nttdata.com> writes:
>> On 2021/01/14 13:59, Michael Paquier wrote:
>>> florican is telling that this test has some stability problems:
>>> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=florican&dt=2021-01-14%2003%3A55%3A45
> 
>> My guess is that the requested WAL file was removed unfortunately by
>> checkpoint because no replication slot is used and wal_keep_size is not set.
>> So easy fix is to set wal_keep_size to 512MB or other in that test. Thought?
> 
> florican did pass this test on the v13 branch, so I agree it's probably
> a timing issue not any deeper bug.  Your theory seems plausible.

Thanks for the check!

So, barring any objection, I will push the attached patch that sets
wal_keep_size in the test.

BTW, I included the URL to Michael's report [1] in the commit log. But this
URL doesn't seem to work fine maybe because <message-id> part includes
a slash character.

[1]
https://postgr.es/m/X//PsenxcC50jDzX@paquier.xyz

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION

Вложения

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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: pgsql: Minor header cleanup for the new iovec code.
Следующее
От: Fujii Masao
Дата:
Сообщение: pgsql: Improve tab-completion for CLOSE, DECLARE, FETCH and MOVE.