Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments
Дата
Msg-id 20180928030208.GC1500@paquier.xyz
обсуждение исходный текст
Ответ на Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments
Список pgsql-bugs
On Thu, Sep 27, 2018 at 01:44:30PM +0900, Michael Paquier wrote:
> I looked at this problem, and I completely agree.  From what I can see,
> the restart point run on the standby creates a .ready file for the
> oldest segment because there were no .done file present in it, so the
> checkpointer thinks that it should mark the file with .ready, and then
> makes it ready for archiving, which is never going to happen with
> archive_mode = on.  All the newer segments are already marked with
> .done, so they are getting recycled correctly.

I have spent a couple of hours on this problem, checked the behavior on
all branches, and committed the fix.  Thanks for the report!
--
Michael

Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #15408: Postgresql bad planning with multicolumn gist and search with empty results
Следующее
От: TAKATSUKA Haruka
Дата:
Сообщение: Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments