agora inbox for pgpool-committers@postgresql.orghelp / color / mirror / Atom feed
pgpool: Test: stablize 006.memqcache regression test. 6+ messages / 1 participants [nested] [flat]
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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_3_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=43ffdb322dbca7b901b499bf625bf3f5ab14c... Modified Files -------------- src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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_4_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2d9f72de1221670c421302f576d110db44a40... Modified Files -------------- src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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_5_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=abfd530f37a8b1a8cb42ceaad94cd9b9d8084... Modified Files -------------- src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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_6_STABLE Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=24d17f9deb68564c7629df9eec7c26ea82df6... Modified Files -------------- src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
* pgpool: Test: stablize 006.memqcache regression test. @ 2026-09-19 04:50 Tatsuo Ishii <ishii@postgresql.org> 0 siblings, 0 replies; 6+ messages in thread From: Tatsuo Ishii @ 2026-09-19 04:50 UTC (permalink / raw) To: pgpool-committers@lists.postgresql.org 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 ------ master Details ------- https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=9bcce470d7fc8731d78396bc679c1236a9a6f... Modified Files -------------- src/test/regression/tests/006.memqcache/test.sh | 10 ++++++++++ 1 file changed, 10 insertions(+) ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-09-19 04:50 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org> 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org> 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org> 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org> 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org> 2026-09-19 04:50 pgpool: Test: stablize 006.memqcache regression test. Tatsuo Ishii <ishii@postgresql.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox