<div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">I'm using pgpool version 3.7.2 . </div><div dir="ltr">I
<span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:small;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">configured<span> </span></span> IN pgpool 3 nodes (that havethe DISALLOW_FAILOVER command). </div><div dir="ltr">I configured those 3 nodes replication with repmgr. I synced all the nodes and started the pgpool (but forgot to deatch them via pcp in the pool when I stopped the cluster).</div><div dir="ltr"> After starting the pgpool process many times It took the pool about 10 minutes to identify the nodes and you see in the log the same ourput during the 10 minutes : </div><div dir="ltr"><div dir="ltr">[[No Connection]]([No Connection]) - 2018-03-18 18:56:02 - [No Connection] [31193]LOG: find_primary_node: checking backend no 0</div><div dir="ltr">[[No Connection]]([No Connection]) - 2018-03-18 18:56:02 - [No Connection] [31193]LOG: find_primary_node: checking backend no 1</div><div dir="ltr">[[No Connection]]([No Connection]) - 2018-03-18 18:56:02 - [No Connection] [31193]LOG: find_primary_node: checking backend no 2</div><div dir="ltr"><br></div><div>Moreover, I couldnt use the pcp_commands <i>, </i>I got the next error : </div><div><div>[postgres@pgpool1 log]$ pcp_node_info -h localhost -U postgres -p 9898 0</div><div>Password: </div><div>ERROR: connection to host "localhost" failed with error "Connection refused"</div></div><div><br></div><div>Suddenly, after 10 minutes I saw in the log that the nodes where identified :</div><div><br></div><div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:56:04 - [No Connection] [31193]LOG: find_primary_node: checking backe</div><div>nd no 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:56:04 - [No Connection] [31193]LOG: find_primary_node: checking backe</div><div>nd no 1</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:56:04 - [No Connection] [31193]LOG: find_primary_node: checking backe</div><div>nd no 2</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:56:05 - [No Connection] [31193]LOG: pgpool-II successfully started. v</div><div>ersion 3.7.2 (amefuriboshi)</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:23 - [No Connection] [1132]LOG: forked new pcp worker, pid=1942 so</div><div>cket=8</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:23 - [No Connection] [1132]LOG: PCP process with pid: 1942 exit wi</div><div>th SUCCESS.</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:23 - [No Connection] [1132]LOG: PCP process with pid: 1942 exits w</div><div>ith status 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:26 - [No Connection] [1132]LOG: forked new pcp worker, pid=1957 so</div><div>cket=8</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:26 - [No Connection] [1132]LOG: PCP process with pid: 1957 exit with SUCCESS.</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:26 - [No Connection] [1132]LOG: PCP process with pid: 1957 exits with status 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:29 - [No Connection] [1132]LOG: forked new pcp worker, pid=1971 socket=8</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:29 - [No Connection] [1132]LOG: PCP process with pid: 1971 exit with SUCCESS.</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:29 - [No Connection] [1132]LOG: PCP process with pid: 1971 exits with status 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [1132]LOG: forked new pcp worker, pid=2074 socket=8</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [2074]LOG: received failback request for node_id: 1 from pid [2074]</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: Pgpool-II parent process has received failover request</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: starting fail back. reconnect host pgserver2(5432)</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: Node 0 is not down (status: 2)</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [1132]LOG: PCP process with pid: 2074 exit with SUCCESS.</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [1132]LOG: PCP process with pid: 2074 exits with status 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: Do not restart children because we are failing back node id 1 host: pgserver2 port: 5432 and we are in streaming replication mode and not all backends were down</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: find_primary_node_repeatedly: waiting for finding a primary node</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: find_primary_node: checking backend no 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: find_primary_node: checking backend no 1</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: find_primary_node: primary node id is 1</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: failover: set new primary node: 1</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: failover: set new master node: 0</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [31193]LOG: failback done. reconnect host pgserver2(5432)</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:50 - [No Connection] [1135]LOG: worker process received restart request</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:51 - [No Connection] [1132]LOG: restart request received in pcp child process</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:51 - [No Connection] [31193]LOG: PCP child 1132 exits with status 0 in failover()</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:51 - [No Connection] [31193]LOG: fork a new PCP child pid 2078 in failover()</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:51 - [No Connection] [31193]LOG: worker child process with pid: 1135 exits with status 256</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:51 - [No Connection] [31193]LOG: fork a new worker child process with pid: 2079</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]WARNING: child process with pid: 31214 was terminated by segmentation fault</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: fork a new child process with pid: 2086</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [2086]LOG: failback event detected</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [2086]DETAIL: restarting myself</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: child process with pid: 2086 exits with status 256</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: fork a new child process with pid: 2087</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]WARNING: child process with pid: 31215 was terminated by segmentation fault</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: fork a new child process with pid: 2090</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [2090]LOG: failback event detected</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [2090]DETAIL: restarting myself</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: child process with pid: 2090 exits with status 256</div><div>[[No Connection]]([No Connection]) - 2018-03-18 18:57:53 - [No Connection] [31193]LOG: fork a new child process with pid: 2091</div></div><div> </div><div><br></div><div><br></div><div><br></div><div>--It seems that the pool was stuck and restarting it didnt resolve it. Is it suppose to happen or is it a bug ? Can you explain to me what is the reason behind it ?</div><div><br></div></div></div>