Re: regression test failed when enabling checksum

 

I've been trying, but see message "commit dfda6ebaec67 versus wal_keep_segments".

Looking at some of the log files more, I see that vacuum is involved, but in some way I don't understand.  The crash always happens on a test cycle immediately after the sleep that allows the autovac to kick in and finish.  So the events goes something like this:

...

run the frantic updating of "foo" until crash

recovery

query "foo" and verify the results are consistent with expectations

sleep to allow autovac to do its job.

truncate "foo" and repopulate it.

run the frantic updating of "foo" until crash

recovery

attempt to query "foo" but get the checksum failure.

What the vacuum is doing that corrupts the system in a way that survives the truncate is a mystery to me.

Also, at one point I had the harness itself exit as soon as it detected the problem, but I failed to have it shut down the server.  So the server keep running idle and having autovac do its thing, which produced some interesting log output:

WARNING:  relation "foo" page 45 is uninitialized --- fixing

WARNING:  relation "foo" page 46 is uninitialized --- fixing

...

WARNING:  relation "foo" page 72 is uninitialized --- fixing