Re: Concurrency bug in amcheck
Alexander Korotkov <aekorotkov@gmail.com>
From: Alexander Korotkov <aekorotkov@gmail.com>
To: Peter Geoghegan <pg@bowt.ie>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Michail Nikolaev <michail.nikolaev@gmail.com>
Date: 2020-08-04T23:17:48Z
Lists: pgsql-hackers
On Wed, Aug 5, 2020 at 1:58 AM Peter Geoghegan <pg@bowt.ie> wrote: > On Tue, Aug 4, 2020 at 7:27 AM Alexander Korotkov <aekorotkov@gmail.com> wrote: > > Thank you for your reminder. Revised patch is attached. Now, the contents of deleted btree pages isn't masked. I've checked that installcheck passes with wal_consistency_checking='Btree'. I'm going to push this if no objections. > > This looks good to me. One small thing, though: maybe the comments > should not say anything about the REDO routine -- that seems like a > case of "the tail wagging the dog" to me. Perhaps say something like: > > "Remove the last pivot tuple on the page. This keeps things simple > for WAL consistency checking." Pushed. Comment is changed as you suggested. But I've replaced "last pivot tuple" with "remaining tuples", because the page can also have a high key, which is also a tuple. ------ Regards, Alexander Korotkov
Commits
-
Remove btree page items after page unlink
- f47b5e139579 14.0 landed
-
Fix amcheck for page checks concurrent to replay of btree page deletion
- b9a45d8dba4d 11.9 landed
- ae1f9b0a9bc3 12.4 landed
- 34dae902ca1c 13.0 landed