Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint
Andrew Gierth <andrew@tao11.riddles.org.uk>
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Michael Paquier <michael@paquier.xyz>
Cc: Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2018-11-08T06:00:29Z
Lists: pgsql-hackers
>>>>> "Michael" == Michael Paquier <michael@paquier.xyz> writes: >> How? It's OK (and normal) for in-core pages to have newer LSNs than >> minRecoveryPoint, it's only on-disk pages that must not be more >> recent than that. And pageinspect will show the in-core page... Michael> If the standby is stopped cleanly once, what's in shared Michael> buffers gets flushed to disk by the checkpointer once at Michael> shutdown, forcing minRecoveryPoint to be updated by the Michael> checkpointer, and that update was not happening beforethe fix. Michael> And once the standby is started again, what's on disk gets Michael> reloaded, showing the inconsistency. Ah, I missed that you were shutting down. I think it would be nice to have a test that didn't rely on that, too. -- Andrew (irc:RhodiumToad)
Commits
-
Add TAP test to check consistency of minimum recovery LSN
- b0825d28ea83 12.0 landed