[pgpool-hackers: 4069] Possible misleading info in pcp_watchdog_info
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Dec 7 14:55:34 JST 2021
Hi Usama,
pcp_watchdog_info displays information of watchdog something like this:
$ pcp_watchdog_info -w -p 50001
4 4 YES localhost:50000 Linux tishii-CFSV9-2 localhost
localhost:50000 Linux tishii-CFSV9-2 localhost 50000 50002 4 LEADER 0 MEMBER
localhost:50004 Linux tishii-CFSV9-2 localhost 50004 50006 7 STANDBY 0 MEMBER
localhost:50008 Linux tishii-CFSV9-2 localhost 50008 50010 7 STANDBY 0 MEMBER
localhost:50012 Linux tishii-CFSV9-2 localhost 50012 50014 7 STANDBY 0 MEMBER
The "YES" in the very first line means that VIP is up on this node
according to the manual. But actually this is not correct because I
have created the watchdog cluster using watchdog_setup and it never
enables VIP. I guess it actually means whether the quorum exists or
not.
Anyway this is misleading and should be fixed IMO.
Note that "-v" (verbose) output also gives wrong information.
$ pcp_watchdog_info -w -p 50001 -v
Watchdog Cluster Information
Total Nodes : 4
Remote Nodes : 3
Member Remote Nodes : 3
Alive Remote Nodes : 3
Nodes required for quorum: 3
Quorum state : QUORUM EXIST
VIP up on local node : YES
Leader Node Name : localhost:50000 Linux tishii-CFSV9-2
Leader Host Name : localhost
Watchdog Node Information
Node Name : localhost:50000 Linux tishii-CFSV9-2
Host Name : localhost
Delegate IP : Not_Set
Pgpool port : 50000
Watchdog port : 50002
Node priority : 4
Status : 4
Status Name : LEADER
Membership Status : MEMBER
Node Name : localhost:50004 Linux tishii-CFSV9-2
Host Name : localhost
Delegate IP : Not_Set
Pgpool port : 50004
Watchdog port : 50006
Node priority : 3
Status : 7
Status Name : STANDBY
Membership Status : MEMBER
Node Name : localhost:50008 Linux tishii-CFSV9-2
Host Name : localhost
Delegate IP : Not_Set
Pgpool port : 50008
Watchdog port : 50010
Node priority : 2
Status : 7
Status Name : STANDBY
Membership Status : MEMBER
Node Name : localhost:50012 Linux tishii-CFSV9-2
Host Name : localhost
Delegate IP : Not_Set
Pgpool port : 50012
Watchdog port : 50014
Node priority : 1
Status : 7
Status Name : STANDBY
Membership Status : MEMBER
Best reagards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-hackers
mailing list