<div dir="ltr">Sorry, forgot to attach the patch.<div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Sep 16, 2016 at 1:23 AM, Muhammad Usama <span dir="ltr"><<a href="mailto:m.usama@gmail.com" target="_blank">m.usama@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi<div><br></div><div>I was working on fixing the "<span style="font-size:12.8px">[<span>pgpool</span>-general: 4997] Avoiding downtime when <span>pgpool</span> changes require a restart"</span></div><div><span style="font-size:12.8px">And the part of the fix was to downgrade the FATAL error to WARNING when the configurations on the coordinator/master and the standby node differs. But since some configuration differences on the watchdog nodes can be catastrophic in some cases and the pgpool-II warning messages can be easily ignored,</span></div><div><span style="font-size:12.8px">So I was thinking of a small watchdog feature that records all the warning messages generated on a watchdog node and the pcp_watchdog_info on master node displays all the warnings on the node.</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">See the attached WIP test patch.</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Output of pcp_watchdog_info with the patch. The WARNING MESSAGE fields are added by the attached patch</span></div><div><br></div><div><div><font face="monospace, monospace"><span style="font-size:12.8px">[usama@localhost bin]$ ./pcp_watchdog_info -h 127.0.0.1 -p 9891 -U postgres -w -v</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Watchdog Cluster Information </span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Total Nodes : 3</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Remote Nodes : 2</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Quorum state : QUORUM EXIST</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Alive Remote Nodes : 2</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">VIP up on local node : YES</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Master Node Name : Linux_localhost.localdomain_<wbr>9991</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Master Host Name : localhost</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px"><br></span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Watchdog Node Information </span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node Name : Linux_localhost.localdomain_<wbr>9991</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Host Name : localhost</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Delegate IP : Not_Set</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Pgpool port : 9991</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Watchdog port : 9001</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node priority : 1</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status : 4</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status Name : MASTER</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">WARNING MESSAGES [0]</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px"><br></span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node Name : Linux_localhost.localdomain_<wbr>9992</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Host Name : localhost</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Delegate IP : Not_Set</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Pgpool port : 9992</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Watchdog port : 9002</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node priority : 1</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status : 7</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status Name : STANDBY</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">WARNING MESSAGES [1]</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">0<span style="white-space:pre-wrap"> </span>value for num_init_children is 1 which is 4 on the master node</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px"><br></span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node Name : Linux_localhost.localdomain_<wbr>9993</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Host Name : localhost</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Delegate IP : Not_Set</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Pgpool port : 9993</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Watchdog port : 9003</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Node priority : 1</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status : 7</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">Status Name : STANDBY</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">WARNING MESSAGES [3]</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">0<span style="white-space:pre-wrap"> </span>value for num_init_children is 1 which is 4 on the master node</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">1<span style="white-space:pre-wrap"> </span>value for health_check_period is 10 which is 0 on the master node</span></font></div><div><font face="monospace, monospace"><span style="font-size:12.8px">2<span style="white-space:pre-wrap"> </span>value for enable_pool_hba is OFF which is ON on the master node</span></font></div></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif"><br></font></span></div><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif">Thoughts and suggestions </font></span></div><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif"><br></font></span></div><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif">Thanks</font></span></div><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif">Best regards</font></span></div><span class="HOEnZb"><font color="#888888"><div><span style="font-size:12.8px"><font face="arial, helvetica, sans-serif">Muhammad Usama</font></span></div></font></span></div>
</blockquote></div><br></div>