pgsql: Add TAP test to check consistency of minimum recovery LSN

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Add TAP test to check consistency of minimum recovery LSN
Date: 2019-03-13 06:03:46
Message-ID: E1h3wzS-00059D-Vn@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add TAP test to check consistency of minimum recovery LSN

c186ba13 has fixed an issue related to the updates of the minimum
recovery LSN across multiple processes on standbys, but we never really
had a test case able to reliably check its logic.

This commit introduces a new test case to close the gap, and is designed
to check the consistency of data based on the minimum recovery point set
by either the startup process or the checkpointer for both an offline
cluster (by looking at the on-disk page headers) and an online cluster
(using pageinspect).

Note that with c186ba13 reverted, this test fails badly for both the
online and offline cases, as designed.

Author: Michael Paquier, Andrew Gierth
Reviewed-by: Andrew Gierth, Georgios Kokolatos, Arthur Zakirov
Discussion: https://postgr.es/m/20181108044525.GA17482@paquier.xyz

Branch
------
master

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

Modified Files
--------------
src/test/perl/TestLib.pm | 11 ++
src/test/recovery/Makefile | 2 +-
src/test/recovery/t/016_min_consistency.pl | 175 +++++++++++++++++++++++++++++
3 files changed, 187 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Magnus Hagander 2019-03-13 12:44:27 pgsql: Remove extra comma
Previous Message Michael Paquier 2019-03-13 05:03:31 Re: pgsql: Add support for hyperbolic functions, as well as log10().