| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | pgpool-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgpool: Test: stablize 006.memqcache regression test. |
| Date: | 2026-09-19 04:50:29 |
| Message-ID: | E1x7n1x-00000005ZD9-3Cwr@gothos.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-committers |
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(at)postgresql(dot)org>
Backpatch-through: v4.3
Branch
------
V4_6_STABLE
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=24d17f9deb68564c7629df9eec7c26ea82df63af
Modified Files
--------------
src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++
1 file changed, 10 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-09-19 04:50:34 | pgpool: Test: stablize 006.memqcache regression test. |
| Previous Message | Tatsuo Ishii | 2026-09-19 04:50:24 | pgpool: Test: stablize 006.memqcache regression test. |