On Thu, Aug 30, 2018 at 10:55:23AM +0200, Alexander Kukushkin wrote: > Bgwriter itself never changes updateMinRecoveryPoint to true and boom, > we can get a lot of pages written to disk, but minRecoveryPoint in the > pg_control won't be updated!
That's indeed obvious by reading the code. The bgwriter would be started only once a consistent point has been reached, so the startup process would have normally already updated the control file to the consistent point. Something like the attached should take care of the problem. As the updates of the local copy of minRecoveryPoint strongly rely on if the startup process is used, I think that we should use InRecovery for the sanity checks. I'd like to also add a TAP test for that, which should be easy enough if we do sanity checks by looking up at the output of the control file. I'll try to put more thoughts on that. Does it take care of the problem? -- Michael
diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c
index 493f1db7b9..f9c52fb9d8 100644
--- a/src/backend/access/transam/xlog.c
+++ b/src/backend/access/transam/xlog.c
@@ -2723,9 +2723,14 @@ UpdateMinRecoveryPoint(XLogRecPtr lsn, bool force)
* i.e., we're doing crash recovery. We never modify the control file's
* value in that case, so we can short-circuit future checks here too. The
* local values of minRecoveryPoint and minRecoveryPointTLI should not be
- * updated until crash recovery finishes.
+ * updated until crash recovery finishes. We only do this for the startup
+ * process replaying WAL which needs to keep clean references of
+ * minRecoveryPoint until it is made sure that it has replayed all WAL
+ * available for crash recovery. Other processes would be started after
+ * the consistency point has been reached on a standby, so it would be
+ * actually safe to update the control file in this case.
*/
- if (XLogRecPtrIsInvalid(minRecoveryPoint))
+ if (XLogRecPtrIsInvalid(minRecoveryPoint) && InRecovery)
{
updateMinRecoveryPoint = false;
return;
@@ -2737,7 +2742,9 @@ UpdateMinRecoveryPoint(XLogRecPtr lsn, bool force)
minRecoveryPoint = ControlFile->minRecoveryPoint;
minRecoveryPointTLI = ControlFile->minRecoveryPointTLI;
- if (force || minRecoveryPoint < lsn)
+ if (XLogRecPtrIsInvalid(minRecoveryPoint))
+ updateMinRecoveryPoint = false;
+ else if (force || minRecoveryPoint < lsn)
{
XLogRecPtr newMinRecoveryPoint;
TimeLineID newMinRecoveryPointTLI;
signature.asc
Description: PGP signature
