<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;}
.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>Hi, I have been running pgpool 4.1.1 and after a recovery, I can’t make the node to status up again.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>[postgres@spcdmvm8020 ~]$ pcp_watchdog_info -h 192.168.21.60 -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@spcdmvm8020 ~]$ psql -h 192.168.21.60 -p 5000 -U pgpool postgres -c "show pool_nodes"</p><p class=MsoNormal>Password for user pgpool:</p><p class=MsoNormal> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_</p><p class=MsoNormal>sync_state | last_status_change</p><p class=MsoNormal>---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+-------------</p><p class=MsoNormal>-----------+---------------------</p><p class=MsoNormal> 0 | spcdmvm8019 | 5432 | up | 0.333333 | primary | 25206 | true | 0 | |</p><p class=MsoNormal> | 2021-09-13 20:25:51</p><p class=MsoNormal> 1 | spcdmvm8020 | 5432 | down | 0.333333 | standby | 0 | false | 0 | streaming | async</p><p class=MsoNormal> | 2021-09-13 20:25:51</p><p class=MsoNormal> 2 | spcdmvm8021 | 5432 | down | 0.333333 | standby | 4 | false | 0 | streaming | async</p><p class=MsoNormal> | 2021-09-13 20:25:51</p><p class=MsoNormal>(3 rows)</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>And the error log shows:</p><p class=MsoNormal>Sep 13 22:14:38 spcdmvm8020 pgpool[1176]: [50-1] 2021-09-13 22:14:38: pid 1176: LOG: remote node "spcdmvm8019:5000 Linux spcdmvm8019" is asking to inform about quarantined backend nodes</p><p class=MsoNormal>Sep 13 22:14:38 spcdmvm8020 pgpool[1137]: [33-1] 2021-09-13 22:14:38: pid 1137: LOG: Pgpool-II parent process received inform quarantine nodes signal from watchdog</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>So, I am not sure how to change the status from quarantine on those two nodes.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>What should I do on this case?</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Rinaldo Akio Uehara</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>