postgres.git / summary / log / commit / refs

commit    4f8cefcadef318f5ea446943a473e7364bd40ec6
Author:   Thomas Munro <tmunro@postgresql.org>
Date:     Sat Aug 31 02:32:08 2024 +0000
First released in: 18.0, 12.21, 13.17, 14.14, 15.9, 16.5, 17.0

    Stabilize 039_end_of_wal test.
    
    The first test was sensitive to the insert LSN after setting up the
    catalogs, which depended on environmental things like the locales on the
    OS and usernames.  Switch to a new WAL file before the first test, as a
    simple way to put every computer into the same state.
    
    Back-patch to all supported releases.
    
    Reported-by: Anton Voloshin <a.voloshin@postgrespro.ru>
    Reported-by: Nathan Bossart <nathandbossart@gmail.com>
    Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
    Reviewed-by: Nathan Bossart <nathandbossart@gmail.com>
    Discussion: https://postgr.es/m/b26aeac2-cb6d-4633-a7ea-945baae83dcf%40postgrespro.ru


 src/test/recovery/t/039_end_of_wal.pl | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/src/test/recovery/t/039_end_of_wal.pl b/src/test/recovery/t/039_end_of_wal.pl
index 2013e663a31..58327359bb4 100644
--- a/src/test/recovery/t/039_end_of_wal.pl
+++ b/src/test/recovery/t/039_end_of_wal.pl
@@ -257,6 +257,12 @@ $WAL_BLOCK_SIZE = get_int_setting($node, 'wal_block_size');
 $TLI = $node->safe_psql('postgres',
 	"SELECT timeline_id FROM pg_control_checkpoint();");
 
+# Initial LSN may vary across systems due to different catalog contents set up
+# by initdb.  Switch to a new WAL file so all systems start out in the same
+# place.  The first test depends on trailing zeroes on a page with a valid
+# header.
+$node->safe_psql('postgres', "SELECT pg_switch_wal();");
+
 my $end_lsn;
 my $prev_lsn;
 


[parent: 6f2525c775f2]