Re: Why is src/test/modules/committs/t/002_standby.pl flaky?
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: Thomas Munro <thomas.munro@gmail.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2021-12-30T20:35:45Z
Lists: pgsql-hackers
On 12/30/21 15:01, Thomas Munro wrote: > Hi, > > There's a wait for replay that is open coded (instead of using the > wait_for_catchup() routine), and sometimes the second of two such > waits at line 51 (in master) times out after 3 minutes with "standby > never caught up". It's happening on three particular Windows boxes, > but once also happened on the AIX box "tern". > > branch | animal | count > ---------------+-----------+------- > HEAD | drongo | 1 > HEAD | fairywren | 8 > REL_10_STABLE | drongo | 3 > REL_10_STABLE | fairywren | 10 > REL_10_STABLE | jacana | 3 > REL_11_STABLE | drongo | 1 > REL_11_STABLE | fairywren | 4 > REL_11_STABLE | jacana | 3 > REL_12_STABLE | drongo | 2 > REL_12_STABLE | fairywren | 5 > REL_12_STABLE | jacana | 1 > REL_12_STABLE | tern | 1 > REL_13_STABLE | fairywren | 3 > REL_14_STABLE | drongo | 2 > REL_14_STABLE | fairywren | 6 > > FYI, drongo and fairywren are run on the same AWS/EC2 Windows Server 2019 instance. Nothing else runs on it. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com
Commits
-
Revert "graceful shutdown" changes for Windows.
- 29992a6a509b 15.0 landed
-
Revert "graceful shutdown" changes for Windows, in back branches only.
- bbb1caf6b220 11.15 landed
- 75674c7ec1b1 14.2 landed
- 64b2c6507e57 12.10 landed
- 645c9457f296 10.20 landed
- 213c5aa3bdba 13.6 landed