pgsql: In tests, await an LSN no later than the recovery target. - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: In tests, await an LSN no later than the recovery target.
Date
Msg-id E1eVtEg-0000jo-16@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
In tests, await an LSN no later than the recovery target.

Otherwise, the test fails with "Timed out while waiting for standby to
catch up".  This happened rarely, perhaps only when autovacuum wrote WAL
between our choosing the recovery target and choosing the LSN to await.
Commit b26f7fa6ae2b4e5d64525b3d5bc66a0ddccd9e24 fixed one case of this.
Fix two more.  Back-patch to 9.6, which introduced the affected test.

Discussion: https://postgr.es/m/20180101055227.GA2952815@rfd.leadboat.com

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/5f5d73dd1a813fbd84b5dbeedb665403bc26d98a

Modified Files
--------------
src/test/recovery/t/003_recovery_targets.pl | 15 +++++++--------
1 file changed, 7 insertions(+), 8 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Merge coding of return/exit/continue cases in plpgsql's loopsta
Next
From: Andres Freund
Date:
Subject: pgsql: Fix EXPLAIN ANALYZE output for Parallel Hash.