[pgpool-general: 7536] Re: Strange behavior on switchover with detach_false_primary enabled
ishii at sraoss.co.jp
Fri Apr 30 19:46:05 JST 2021
>> I started to think that detach_false_primary should not active on
>> other than leader watchdog node because standby watchdog node can be
>> interrupted by other watchdog node and causes unexpected failover. I
>> will investigate more.
> I was in the middle of typing this, it seems we are in agreement: I'm
> wondering why a node that is not the pgpool leader makes this decision
> at all. Shouldn't the view of the database cluster be the same from
> all pgpool nodes? I'm not that much at home in how the watchdog makes
> its decisions, but to me it seems only the leader can make autonomous
> decisions. A node may request the cluster status to be reviewed, but
> for an automated detach, I would at least expect a quorum is needed.
Attached is the patch which implement this:
- only the leader watchdog node runs detach_false_primary
- if a quorum does not exist, the leader node does not run detach_false_primary
SRA OSS, Inc. Japan
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 10345 bytes
Desc: not available
More information about the pgpool-general