[pgpool-general: 6431] Re: follow_master_command executed on node shown as down (one of unrecovered masters from previous failover)

[Tatsuo Ishii]

> Is this correct behavior?
> 
> In 3-node setup, node1(primary) is shutdown, failover is executed and node2
> becomes new primary and node3 follows new primary on node2.
> Now, node2(new primary) is shutdown, failover is executed and node3 becomes
> new primary but fallow_master_command is executed on node1 even though it
> is reported as down.

No. follow master command should not be executed on an already-down
node (in this case node1).

> It happens that my script repoints node1 and restarts it which breaks hell
> because node1 was never recovered after being shutdown.
> 
> I'm on PgPool 3.7.4.

Can you share the log from when node2 was shutdown to when node1 was
recovered by your follow master command?

In the mean time 3.7.4 is not the latest one. Can you try with the
latest one? (3.7.8).

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp