Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments
Date
Msg-id 20180928030208.GC1500@paquier.xyz
Whole thread Raw
In response to Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments  (Michael Paquier <michael@paquier.xyz>)
Responses Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments
List 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

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15408: Postgresql bad planning with multicolumn gist and search with empty results
Next
From: TAKATSUKA Haruka
Date:
Subject: Re: BUG #15402: Hot standby server with archive_mode=on keepsinitial WAL segments