postgres.git / summary / log / commit / refs

commit    f5f5e7b47351f0443d9720bfc7916ed2af940bd3
Author:   Heikki Linnakangas <heikki.linnakangas@iki.fi>
Date:     Mon Dec 16 13:56:38 2024 +0000

    Make 009_twophase.pl test pass with recovery_min_apply_delay set
    
    The test failed if you ran the regression tests with TEMP_CONFIG with
    recovery_min_apply_delay = '500ms'. Fix the race condition by waiting
    for transaction to be applied in the replica, like in a few other
    tests.
    
    The failing test was introduced in commit cbfbda7841. Backpatch to all
    supported versions like that commit (except v12, which is no longer
    supported).
    
    Reported-by: Alexander Lakhin
    Discussion: https://www.postgresql.org/message-id/09e2a70a-a6c2-4b5c-aeae-040a7449c9f2@gmail.com


 src/test/recovery/t/009_twophase.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/src/test/recovery/t/009_twophase.pl b/src/test/recovery/t/009_twophase.pl
index b9d96453167..a5686db2526 100644
--- a/src/test/recovery/t/009_twophase.pl
+++ b/src/test/recovery/t/009_twophase.pl
@@ -315,6 +315,7 @@ $cur_primary->psql('postgres', "COMMIT PREPARED 'xact_009_12'");
 
 $cur_primary->psql(
 	'postgres', "
+	SET synchronous_commit='remote_apply'; -- To ensure the standby is caught up
 	CREATE TABLE t_009_tbl_standby_mvcc (id int, msg text);
 	BEGIN;
 	INSERT INTO t_009_tbl_standby_mvcc VALUES (1, 'issued to ${cur_primary_name}');


[parent: 2a23dbcf3594]