| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> | 
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> | 
| Cc: | Postgres hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint | 
| Date: | 2018-11-08 06:00:29 | 
| Message-ID: | 87efbwyurq.fsf@news-spur.riddles.org.uk | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-hackers | 
>>>>> "Michael" == Michael Paquier <michael(at)paquier(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-11-08 06:11:35 | Re: move PartitionBoundInfo creation code | 
| Previous Message | David Rowley | 2018-11-08 05:59:19 | Re: Removing unneeded self joins |