<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=PT-BR link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Hello!</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Here are the output of each command:</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8019 ~]$ pcp_attach_node -U pgpool -h 192.168.21.60 --port=9898 -n 1</p><p class=MsoNormal>Password:</p><p class=MsoNormal>ERROR: failback request for node_id: 1 from pid [1384321] is canceled by other pgpool</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8019 ~]$ pcp_attach_node -U pgpool -h 192.168.21.60 --port=9898 -n 2</p><p class=MsoNormal>Password:</p><p class=MsoNormal>ERROR: failback request for node_id: 2 from pid [1384337] is canceled by other pgpool</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8019 ~]$ pcp_watchdog_info -h spcdmvm8019 -v -U pgpool</p><p class=MsoNormal>Password:</p><p class=MsoNormal>Watchdog Cluster Information</p><p class=MsoNormal>Total Nodes : 3</p><p class=MsoNormal>Remote Nodes : 2</p><p class=MsoNormal>Quorum state : QUORUM EXIST</p><p class=MsoNormal>Alive Remote Nodes : 2</p><p class=MsoNormal>VIP up on local node : YES</p><p class=MsoNormal>Master Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Master Host Name : spcdmvm8019</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Watchdog Node Information</p><p class=MsoNormal>Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Host Name : spcdmvm8019</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 10</p><p class=MsoNormal>Status : 4</p><p class=MsoNormal>Status Name : MASTER</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8020:5000 Linux spcdmvm8020</p><p class=MsoNormal>Host Name : spcdmvm8020</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 5</p><p class=MsoNormal>Status : 7</p><p class=MsoNormal>Status Name : STANDBY</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8021:5000 Linux spcdmvm8021</p><p class=MsoNormal>Host Name : spcdmvm8021</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 1</p><p class=MsoNormal>Status : 7</p><p class=MsoNormal>Status Name : STANDBY</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8019 ~]$ pcp_watchdog_info -h spcdmvm8020 -v -U pgpool</p><p class=MsoNormal>Password:</p><p class=MsoNormal>Watchdog Cluster Information</p><p class=MsoNormal>Total Nodes : 3</p><p class=MsoNormal>Remote Nodes : 2</p><p class=MsoNormal>Quorum state : QUORUM EXIST</p><p class=MsoNormal>Alive Remote Nodes : 2</p><p class=MsoNormal>VIP up on local node : NO</p><p class=MsoNormal>Master Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Master Host Name : spcdmvm8019</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Watchdog Node Information</p><p class=MsoNormal>Node Name : spcdmvm8020:5000 Linux spcdmvm8020</p><p class=MsoNormal>Host Name : spcdmvm8020</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 5</p><p class=MsoNormal>Status : 7</p><p class=MsoNormal>Status Name : STANDBY</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Host Name : spcdmvm8019</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 10</p><p class=MsoNormal>Status : 4</p><p class=MsoNormal>Status Name : MASTER</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8021:5000 Linux spcdmvm8021</p><p class=MsoNormal>Host Name : spcdmvm8021</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 1</p><p class=MsoNormal>Status : 7</p><p class=MsoNormal>Status Name : STANDBY</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8019 ~]$ pcp_watchdog_info -h spcdmvm8021 -v -U pgpool</p><p class=MsoNormal>Password:</p><p class=MsoNormal>Watchdog Cluster Information</p><p class=MsoNormal>Total Nodes : 3</p><p class=MsoNormal>Remote Nodes : 2</p><p class=MsoNormal>Quorum state : QUORUM EXIST</p><p class=MsoNormal>Alive Remote Nodes : 2</p><p class=MsoNormal>VIP up on local node : NO</p><p class=MsoNormal>Master Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Master Host Name : spcdmvm8019</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Watchdog Node Information</p><p class=MsoNormal>Node Name : spcdmvm8021:5000 Linux spcdmvm8021</p><p class=MsoNormal>Host Name : spcdmvm8021</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 1</p><p class=MsoNormal>Status : 7</p><p class=MsoNormal>Status Name : STANDBY</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8019:5000 Linux spcdmvm8019</p><p class=MsoNormal>Host Name : spcdmvm8019</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 10</p><p class=MsoNormal>Status : 4</p><p class=MsoNormal>Status Name : MASTER</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Node Name : spcdmvm8020:5000 Linux spcdmvm8020</p><p class=MsoNormal>Host Name : spcdmvm8020</p><p class=MsoNormal>Delegate IP : 192.168.21.60</p><p class=MsoNormal>Pgpool port : 5000</p><p class=MsoNormal>Watchdog port : 9000</p><p class=MsoNormal>Node priority : 5</p><p class=MsoNormal>Status : 1</p><p class=MsoNormal>Status Name : LOADING</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='border:none;padding:0cm'><b>De: </b><a href="mailto:pengbo@sraoss.co.jp">Bo Peng</a><br><b>Enviado:</b>quinta-feira, 16 de setembro de 2021 02:07<br><b>Para: </b><a href="mailto:rinaldo.uehara@gmail.com">Rinaldo Akio Uehara</a><br><b>Cc:</b><a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><b>Assunto: </b>Re: [pgpool-general: 7705] Nodes down as quarentined, but not sure what is the problem</p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hello,</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>> If I try the pcp_attach_node, the msg is:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> ERROR: failback request for node_id: 1 from pid [854715] is canceled by other pgpool</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I could not reproduce this issue in 4.1.1.</p><p class=MsoNormal>I think it may be in a network isolation state in your environment.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Cloud you share your pcp_attach_node command and the following result?</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> $ pcp_watchdog_info -h spcdmvm8019 -v -U pgpool</p><p class=MsoNormal> $ pcp_watchdog_info -h spcdmvm8020 -v -U pgpool</p><p class=MsoNormal> $ pcp_watchdog_info -h spcdmvm8021 -v -U pgpool</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On Mon, 13 Sep 2021 22:16:55 -0300</p><p class=MsoNormal>Rinaldo Akio Uehara <rinaldo.uehara@gmail.com> wrote:</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>> _______________________________________________</p><p class=MsoNormal>> pgpool-general mailing list</p><p class=MsoNormal>> pgpool-general@pgpool.net</p><p class=MsoNormal>> http://www.pgpool.net/mailman/listinfo/pgpool-general</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>-- </p><p class=MsoNormal>Bo Peng <pengbo@sraoss.co.jp></p><p class=MsoNormal>SRA OSS, Inc. Japan</p><p class=MsoNormal>http://www.sraoss.co.jp/</p><p class=MsoNormal><o:p> </o:p></p></div></body></html>