[pgpool-general: 7536] Re: Strange behavior on switchover with detach_false_primary enabled

[Tatsuo Ishii]

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

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: detach_false_primary_v3.diff
Type: text/x-patch
Size: 10345 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20210430/4a37c55e/attachment.bin>