<div dir="ltr"><div>Hi Ishii-San,</div><div><br></div><div>Sorry for a very delayed response, and thank you for pointing out the issue.</div><div><br></div><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Dec 7, 2021 at 10:55 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Usama,<br>
<br>
pcp_watchdog_info displays information of watchdog something like this:<br>
<br>
$ pcp_watchdog_info -w -p 50001<br>
4 4 YES localhost:50000 Linux tishii-CFSV9-2 localhost<br>
<br>
localhost:50000 Linux tishii-CFSV9-2 localhost 50000 50002 4 LEADER 0 MEMBER<br>
localhost:50004 Linux tishii-CFSV9-2 localhost 50004 50006 7 STANDBY 0 MEMBER<br>
localhost:50008 Linux tishii-CFSV9-2 localhost 50008 50010 7 STANDBY 0 MEMBER<br>
localhost:50012 Linux tishii-CFSV9-2 localhost 50012 50014 7 STANDBY 0 MEMBER<br>
<br>
The "YES" in the very first line means that VIP is up on this node<br>
according to the manual. But actually this is not correct because I<br>
have created the watchdog cluster using watchdog_setup and it never<br>
enables VIP. I guess it actually means whether the quorum exists or<br>
not.<br></blockquote><div><br></div><div>VIP is up on current node is in fact misleading when the VIP is not set in pgpool.conf,</div><div>while the quorum status gets already reported in <span style="font-variant-ligatures:no-common-ligatures;background-color:rgb(238,235,234);color:rgb(0,0,0);font-family:"Meslo LG L DZ for Powerline";font-size:14px">Quorum state</span><span style="background-color:transparent"> field.</span></div><div><span style="background-color:transparent">Actually the value of "Is VIP up on current node" comes from '</span>node->escalated' field</div><div>that gives the status of wd_escalation process execution status. So I think the field name</div><div>should be canged to "node escalation" from "VIP up on node".</div>
<div class="gmail_quote"><br></div>I have cooked up a quick patch for that, Please let me know what you think about that.</div><div class="gmail_quote"><br></div><div class="gmail_quote"><span style="background-color:transparent">Best regards</span><br></div><div class="gmail_quote">Muhammad Usama</div><div class="gmail_quote"><br class="gmail-Apple-interchange-newline"><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
Anyway this is misleading and should be fixed IMO.<br>
<br>
Note that "-v" (verbose) output also gives wrong information.<br>
<br>
$ pcp_watchdog_info -w -p 50001 -v<br>
Watchdog Cluster Information <br>
Total Nodes : 4<br>
Remote Nodes : 3<br>
Member Remote Nodes : 3<br>
Alive Remote Nodes : 3<br>
Nodes required for quorum: 3<br>
Quorum state : QUORUM EXIST<br>
VIP up on local node : YES<br>
Leader Node Name : localhost:50000 Linux tishii-CFSV9-2<br>
Leader Host Name : localhost<br>
<br>
Watchdog Node Information <br>
Node Name : localhost:50000 Linux tishii-CFSV9-2<br>
Host Name : localhost<br>
Delegate IP : Not_Set<br>
Pgpool port : 50000<br>
Watchdog port : 50002<br>
Node priority : 4<br>
Status : 4<br>
Status Name : LEADER<br>
Membership Status : MEMBER<br>
<br>
Node Name : localhost:50004 Linux tishii-CFSV9-2<br>
Host Name : localhost<br>
Delegate IP : Not_Set<br>
Pgpool port : 50004<br>
Watchdog port : 50006<br>
Node priority : 3<br>
Status : 7<br>
Status Name : STANDBY<br>
Membership Status : MEMBER<br>
<br>
Node Name : localhost:50008 Linux tishii-CFSV9-2<br>
Host Name : localhost<br>
Delegate IP : Not_Set<br>
Pgpool port : 50008<br>
Watchdog port : 50010<br>
Node priority : 2<br>
Status : 7<br>
Status Name : STANDBY<br>
Membership Status : MEMBER<br>
<br>
Node Name : localhost:50012 Linux tishii-CFSV9-2<br>
Host Name : localhost<br>
Delegate IP : Not_Set<br>
Pgpool port : 50012<br>
Watchdog port : 50014<br>
Node priority : 1<br>
Status : 7<br>
Status Name : STANDBY<br>
Membership Status : MEMBER<br>
<br>
Best reagards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
_______________________________________________<br>
pgpool-hackers mailing list<br>
<a href="mailto:pgpool-hackers@pgpool.net" target="_blank">pgpool-hackers@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a><br>
</blockquote></div></div>