[pgpool-committers: 4322] pgpool: Fix for bug in watchdog where sometime failover is not reliably

Muhammad Usama m.usama at gmail.com
Tue Oct 17 00:40:59 JST 2017


Fix for bug in watchdog where sometime failover is not reliably performed

Currently watchdog process only considers the node's watchdog state before
deciding if it can handle the failover and failover-locking requests. But the
problem with this technique is that, for the instance when the node has
announced itself as a master/coordinator of the cluster and is waiting for
the standby nodes to recognise it as a Master node. For that period of time
the watchdog state of the node is Master/coordinator, but it is yet not fully
capable of handling the failover and failover-locking requests.
So sometimes this leads to a situation where a failover is not reliably
performed in case when the failover request arrives while watchdog cluster
is in the process of electing a leader.

The fix for the above situation is to make sure that the node has fully acquired
the Master status before accepting the failover and failover-locking requests.

Branch
------
V3_6_STABLE

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

Modified Files
--------------
src/watchdog/watchdog.c | 12 +++++++++---
1 file changed, 9 insertions(+), 3 deletions(-)



More information about the pgpool-committers mailing list