Horton

Re: 011_crash_recovery.pl intermittently fails

Kyotaro Horiguchi <horikyota.ntt@gmail.com>

View thread View on postgr.es
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: x4mmm@yandex-team.ru
Cc: tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org, craig.ringer@enterprisedb.com, robertmhaas@gmail.com
Date: 2021-03-05T08:00:41Z
Lists: pgsql-hackers 
(Sorry for my slippery fingers.)

At Fri, 5 Mar 2021 10:07:06 +0500, Andrey Borodin <x4mmm@yandex-team.ru> wrote in 
> 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.

The problem records have 15 pages of FPIs.  The reduction of their
size may prevent WAL-buffer wrap around and wal writes.  If no wal is
written the test fails.

regrds.

-- 
Kyotaro Horiguchi
NTT Open Source Software Center

Commits

  1. Remove recovery test 011_crash_recovery.pl

  2. Add a txid_status function.