Horton

Re: BUG #17212: pg_amcheck fails on checking temporary relations

Andrew Dunstan <andrew@dunslane.net>

View thread View on postgr.es
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Geoghegan <pg@bowt.ie>, Mark Dilger <mark.dilger@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, Pavel Borisov <pashkin.elfe@gmail.com>, Alexander Lakhin <exclusion@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-10-15T14:46:03Z
Lists: pgsql-bugs, pgsql-hackers 
On 10/14/21 5:52 PM, Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>> Yes, that's been puzzling me too. I've just been staring at it again and
>> nothing jumps out. But maybe we can investigate that offline if this
>> test is deemed not worth keeping.
> As Mark says, it'd be interesting to know whether the use of
> background_psql is related, because if it is, we'd want to debug that.
> (I don't really see how it could be related, but maybe I just lack
> sufficient imagination today.)



Yeah. I'm working on  getting a cut-down reproducible failure case.


cheers


andrew


-- 

Andrew Dunstan
EDB: https://www.enterprisedb.com

Commits

  1. Remove unstable pg_amcheck tests.

  2. pg_amcheck: avoid unhelpful verification attempts.

  3. amcheck: Skip unlogged relations in Hot Standby.

  4. amcheck: Skip unlogged relations during recovery.