agora inbox for pgpool-committers@postgresql.org
help / color / mirror / Atom feedFrom: Tatsuo Ishii <ishii@postgresql.org>
To: pgpool-committers@lists.postgresql.org
Subject: pgpool: Test: stablize 006.memqcache regression test.
Date: Sat, 19 Sep 2026 04:50:34 +0000
Message-ID: <E1x7n22-00000005ZJU-23ob@gothos.postgresql.org> (raw)
Test: stablize 006.memqcache regression test.
The test sometimes fails on slower environment like build farm.
I suspect one of the causes was replication delay. From the regression log:
2026-09-17 20:21:19.129: child pid 18495: LOG: pool_read_kind: error message from 1 th backend:role "foo" does not exist
2026-09-17 20:21:19.129: child pid 18495: ERROR: unable to read message kind
2026-09-17 20:21:19.129: child pid 18495: DETAIL: kind does not match between main(53) slot[1] (45)
It seems when a new role was created, standby did not catch up
it. This commit sets up synchronous replication in streaming
replication mode to avoid the delay.
Author: Tatsuo Ishii <ishii@postgresql.org>
Backpatch-through: v4.3
Branch
------
V4_7_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=5f258a055d6d10fb8c91b2529342734ba503e...
Modified Files
--------------
src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++
1 file changed, 10 insertions(+)
view thread (6+ messages) latest in thread
Message-ID: <E1x7n22-00000005ZJU-23ob@gothos.postgresql.org>
Permalink: ../E1x7n22-00000005ZJU-23ob@gothos.postgresql.org/
Also on: postgresql.org/message-id/E1x7n22-00000005ZJU-23ob@gothos.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgpool-committers@postgresql.org
Cc: ishii@postgresql.org, pgpool-committers@lists.postgresql.org
Subject: Re: pgpool: Test: stablize 006.memqcache regression test.
In-Reply-To: <E1x7n22-00000005ZJU-23ob@gothos.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox