Re: BUG #15346: Replica fails to start after the crash
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Cc: cyberdemn@gmail.com, pgsql-hackers@postgresql.org, alvherre@2ndquadrant.com, 9erthalion6@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2018-08-31T06:23:54Z
Lists: pgsql-bugs, pgsql-hackers
On Fri, Aug 31, 2018 at 02:52:06PM +0900, Kyotaro HORIGUCHI wrote: > The patch inhibits turning off updateMinRecoveryPoint on other > than the startup process running crash-recovery except at the end > of XLogNeedsFlush. Yes that's a matter of safety, as I put into the truck any modules which may use XLogFlush(). And that maps with the old code, so there is no more surprise. > Even if any other processes than the startup calls the function > during crash recovery, they don't have a means to turn on > updateMinRecoveryPoint again. Actually the only process that > calls the function during crash recovery is the startup. bwriter > and checkpointer doesn't. Hot-standby backends come after > crash-recvery ends. After all, we just won't have an invalid > minRecoveryPoint value there, and updateMinRecoverypoint must be > true. Yes, until a recovery point is reached only the startup process could call that. Now I would imagine that we could have a background worker as well which is spawned when the postmaster starts, and calls those code paths... > + /* > + * No other process than the startup doesn't reach here before crash > + * recovery ends. So minRecoveryPoint must have a valid value here. > + */ > + Assert(minRecoveryPoint != InvalidXLogRecPtr); ... And that would invalidate your assertion here. -- Michael
Commits
-
Ensure correct minimum consistent point on standbys
- 65f39408ee71 9.3.25 landed
- d9638a326f72 9.4.20 landed
- f3520ff6fbf1 9.5.15 landed
- 4a9a5bb3fd2a 9.6.11 landed
- 2c8cff5dd60b 10.6 landed
- c34f8078aa35 11.0 landed
- c186ba135eca 12.0 landed
-
Prevent references to invalid relation pages after fresh promotion
- 8d68ee6f31ca 9.6.10 cited