[pgpool-committers: 5705] pgpool: Speed up failover when all of backends are down.

Tatsuo Ishii ishii at sraoss.co.jp
Fri May 3 09:17:16 JST 2019


Speed up failover when all of backends are down.

Pgpool-II tries to find primary node till search_primary_node_timeout
expires even if all of the backend are in down status. This is not
only a waste of time but makes Pgpool-II looked like hanged because
while searching primary node failover process is suspended and all of
the Pgpool-II child process are in defunct state, thus there's no
process which accepts connection requests from clients. Since the
default value of searching primary is 300 seconds, typically this
keeps on for 300 seconds. This is not comfortable for users.

So immediately give up finding primary node regardless
search_primary_node_timeout and promptly finish the failover process
if all of the backend are in down status.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2019-May/003321.html

Branch
------
V3_6_STABLE

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=a0952b7f07bb6ea0923700b301ba2e71ca842524

Modified Files
--------------
src/main/pgpool_main.c | 17 +++++++++++++++++
1 file changed, 17 insertions(+)



More information about the pgpool-committers mailing list