Re: Odd, intermittent failure in contrib/pageinspect
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Michael Paquier <michael@paquier.xyz>, pgsql-hackers@lists.postgresql.org
Date: 2021-01-18T22:47:40Z
Lists: pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes: > On 2021-Jan-18, Tom Lane wrote: >> [ thinks for a bit... ] Does the checkpointer pin pages it's writing >> out? I guess it'd have to ... > It does, per SyncOneBuffer(), called from BufferSync(), called from > CheckPointBuffers(). Right, then we don't need any strange theories about autovacuum, just bad timing luck. whelk does seem pretty slow, so it's not much of a stretch to imagine that it's more susceptible to this corner case than faster machines. So, do we have any other tests that are invoking a manual vacuum and assuming it won't skip any pages? By this theory, they'd all be failures waiting to happen. regards, tom lane
Commits
-
Disable vacuum page skipping in selected test cases.
- c2dc1a79767a 14.0 landed
- a57dbfcda553 13.2 landed
- 6a97ca31288d 11.11 landed
- 53a24faaa403 12.6 landed
- 3ae247d40231 10.16 landed