Re: 011_crash_recovery.pl intermittently fails

x4mmm@yandex-team.ru

From: Andrey Borodin <x4mmm@yandex-team.ru>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>, pgsql-hackers@lists.postgresql.org, Craig Ringer <craig.ringer@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>
Date: 2021-03-05T05:07:06Z
Lists: pgsql-hackers

> 5 марта 2021 г., в 08:32, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
> 
> Kyotaro Horiguchi <horikyota.ntt@gmail.com> writes:
>> I noticed that 011_crash_recovery.pl intermittently (that being said,
>> one out of three or so on my environment) fails in the second test.
> 
> Hmmm ... what environment is that?  This test script hasn't changed
> meaningfully in several years, and we have not seen any real issues
> with it up to now.

Maybe it's offtopic here, but anyway...
While working on "lz4 for FPIs" I've noticed that this test fails with wal_compression = on.
I did not investigate the case at that moment, but I think that it would be good to run recovery regression tests with compression too.

Best regards, Andrey Borodin.


Commits

  1. Remove recovery test 011_crash_recovery.pl

  2. Add a txid_status function.