[pgpool-hackers: 3293] Re: [pgpool-committers: 5618] pgpool: Fix occasional regression test error of 008.dbredirect.
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
SRA OSS, Inc. Japan
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.
> Modified Files
> src/test/regression/tests/008.dbredirect/test.sh | 5 +++++
> 1 file changed, 5 insertions(+)
More information about the pgpool-hackers