Re: amcheck's verify_heapam(), and HOT chain verification - Mailing list pgsql-hackers

From Mark Dilger
Subject Re: amcheck's verify_heapam(), and HOT chain verification
Date
Msg-id C6F9A9C5-9039-41DB-95BE-C997691DC271@enterprisedb.com
Whole thread Raw
In response to Re: amcheck's verify_heapam(), and HOT chain verification  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: amcheck's verify_heapam(), and HOT chain verification
List pgsql-hackers

> On Nov 6, 2021, at 3:09 PM, Peter Geoghegan <pg@bowt.ie> wrote:
>
> I am quite willing to help out with all this, if you're interested.

Yes, I am quite interested, though I will have to alternate between this work and the various patch sets that I've
alreadysubmitted for this development cycle. 

I think we need a corruption generating framework that can be deployed on the buildfarm.  What I have in mind is
inspiredby your comments about the "freeze the dead" bug.  We need to be able to build versions of the database with
knownbugs enabled, both real-world bugs from the past and contrived bugs we write only for this purpose, so as to
createnon-trivial corruption on the build farm.  I think it would be sufficient if such builds were run less
frequently,perhaps triggered by commits to a corruption testing branch?  We could keep the old bugs alive on that
branchwhile periodically merging in everything else from HEAD?  That seems a tad tiresome, but maybe it wouldn't be too
badif the intentional bugs were limited to just a few backend files, and as much as possible in code at the end of the
fileor in separate files to reduce merge conflicts? 

I'm cc'ing Andrew to get his thoughts about the buildfarm integration....

—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company






pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: GiST operator class for bool
Next
From: Andres Freund
Date:
Subject: Re: Predefined role pg_maintenance for VACUUM, ANALYZE, CHECKPOINT.