pgpool: Test: fix occasional failure of 034.promote_node.

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgpool-committers(at)lists(dot)postgresql(dot)org
Subject: pgpool: Test: fix occasional failure of 034.promote_node.
Date: 2025-12-17 09:07:24
Message-ID: E1vVnVE-00BOuj-09@gothos.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-committers

Test: fix occasional failure of 034.promote_node.

The error is caused by follow primary process. In the process
pg_rewind is executed to sync a standby with new primary. If new
primary promotion is slow, pg_rewind incorrectly returns "there's no
need to pg_rewind". Even if new standby starts, the standby causes an
error later on which make the 034.promote_node test failed.

To fix this, add CHECKPOINT in the failover script. Also add "-c"
option pg_rewind to retrieve WAL from archives so that pg_rewind could
find necessary WAL.

Reported-by: Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
Suggested-by: Bo Peng <pengbo(at)sraoss(dot)co(dot)jp>
Backpatch-through: v4.3

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=8d2ceadefcecf2b40d1df03003ec1ab8fe514dee

Modified Files
--------------
src/test/pgpool_setup.in | 27 +++++++++++++++++++++++++--
1 file changed, 25 insertions(+), 2 deletions(-)

Browse pgpool-committers by date

  From Date Subject
Next Message Bo Peng 2025-12-18 09:11:07 pgpool: Doc: update verified platforms.
Previous Message Tatsuo Ishii 2025-12-17 09:07:18 pgpool: Test: fix occasional failure of 034.promote_node.