011_crash_recovery.pl intermittently fails
Kyotaro Horiguchi <horikyota.ntt@gmail.com>
From: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
To: pgsql-hackers@lists.postgresql.org
Date: 2021-03-05T02:50:11Z
Lists: pgsql-hackers
Attachments
- stabilize_011_crash_recovery_pl.patch (text/x-patch) patch
Hello. 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. > t/011_crash_recovery.pl .. 2/3 > # Failed test 'new xid after restart is greater' > # at t/011_crash_recovery.pl line 56. > # '539' > # > > # '539' > > # Failed test 'xid is aborted after crash' > # at t/011_crash_recovery.pl line 60. > # got: 'committed' > # expected: 'aborted' > # Looks like you failed 2 tests of 3. > t/011_crash_recovery.pl .. Dubious, test returned 2 (wstat 512, 0x200) > Failed 2/3 subtests > > Test Summary Report > ------------------- > t/011_crash_recovery.pl (Wstat: 512 Tests: 3 Failed: 2) > Failed tests: 2-3 > Non-zero exit status: 2 > Files=1, Tests=3, 3 wallclock secs ( 0.03 usr 0.01 sys + 1.90 cusr 0.39 csys = 2.33 CPU) > Result: FAIL If the server crashed before emitting WAL records for the transaction just started, the restarted server cannot know the xid is even started. I'm not sure that is the intention of the test but we must make sure the WAL to be emitted before crashing. CHECKPOINT ensures that. Thoughts? The attached seems to stabilize the test for me. regards. -- Kyotaro Horiguchi NTT Open Source Software Center
Commits
-
Remove recovery test 011_crash_recovery.pl
- 403d82dd54b5 11.19 landed
- e8fb2a721b36 12.14 landed
- ee11824ac4c2 13.10 landed
- 96d42bd27fef 14.7 landed
- c5b2975ec183 15.2 landed
- 8c1cd726c5d9 16.0 landed
-
Add a txid_status function.
- 857ee8e391ff 10.0 cited