[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