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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Michael Paquier-2
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@...

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(-)