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

[Tatsuo Ishii]

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
branches.

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

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(+)
>