[pgpool-hackers: 3293] Re: [pgpool-committers: 5618] pgpool: Fix occasional regression test error of 008.dbredirect.

Tatsuo Ishii ishii at sraoss.co.jp
Fri Apr 5 11:56:04 JST 2019

I have looked into 008.dbredirect test failure in buildfarm.  After
inspecting the log, I found that huge replication lag happened and I
guess the test failure was caused by this. See the reason explained
below (the replication lag does not occur in my local environment and
I guess the replication delay is just caused by poor hardware
performance of buildfarm machine). I have pushed the fix to master
branch. Let's see if the test failure is actually fixed in the next
buildfarm run. If it actually gets fixed, I will back-patch to other

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

From: Tatsuo Ishii <ishii at sraoss.co.jp>
Subject: [pgpool-committers: 5618] pgpool: Fix occasional regression test error of 008.dbredirect.
Date: Fri, 05 Apr 2019 02:48:17 +0000
Message-ID: <E1hCEtt-0007fk-7y at gothos.postgresql.org>

> Fix occasional regression test error of 008.dbredirect.
> The test runs pgbench to create test data. Under slow environment
> replication delay could become too much, and this would prevent load
> balancing because the default value for delay_threshold is set to
> 10000000 in the default pgpool.conf-stream and the tests would fail.
> The fix is, disabling delay_threshold. Also add "show_pool nodes" to
> confirm that replication delay actually happens.
> Branch
> ------
> master
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=2c2345bdcb5b06021842202c7b640eb82568f7b2
> Modified Files
> --------------
> src/test/regression/tests/008.dbredirect/test.sh | 5 +++++
> 1 file changed, 5 insertions(+)

More information about the pgpool-hackers mailing list