pgsql: In tests, await an LSN no later than the recovery target.

From: Noah Misch <noah(at)leadboat(dot)com>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: In tests, await an LSN no later than the recovery target.
Date: 2018-01-01 06:06:10
Message-ID: E1eVtEg-0000jp-1B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/f9c1c6099519609aceb54fc5366f096a0b1e1b41

Modified Files
--------------
src/test/recovery/t/003_recovery_targets.pl | 11 ++++++-----
1 file changed, 6 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2018-01-01 22:42:00 pgsql: Fix EXPLAIN ANALYZE output for Parallel Hash.
Previous Message Tom Lane 2017-12-31 22:20:46 pgsql: Improve regression tests' code coverage for plpgsql control stru