I also facing situation sometimes a slave was disjoin (pgpool treat it as down) from cluster, so my workaround was crontab to check and attach by pcp.<div><br></div><div>Pgpool 3.7.5 pg 10.1.5</div><div><br></div><div><br><br>On Thursday, September 12, 2019, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Hi,<br>
> on a node that had never had problems, the pgpool often goes down from<br>
> about 2 weeks. In the log it looks like a connection problem that<br>
> really doesn't seem to exist. When I restart pgpool after a few hours<br>
> it goes down again. What could be the problem?<br>
> The log also seems to fail to ping trusted servers (which are google<br>
> ones).<br>
> An extract of pgpool.log is in attached file.<br>
> Please, help me.<br>
> Thanks!<br>
> Best regards.<br>
> Giancarlo<br>
<br>
"Goes down" means clients cannot connect to the pgpool or any other<br>
situation?<br>
<br>
> In the log it looks like a connection problem that<br>
> really doesn't seem to exist. When I restart pgpool after a few hours<br>
<br>
Can you please point out which line number in the log file you are<br>
referring to when you say "looks like a connection problem"?<br>
<br>
Finally,<br>
<br>
> on a node that had never had problems, the pgpool often goes down from<br>
<br>
Do you remember anything changed when the problem has started?<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
</blockquote></div><br><br>-- <br>regards<br><br>ujang jaenudin | DBA Consultant (Freelancer)<br><a href="http://ora62.wordpress.com" target="_blank">http://ora62.wordpress.com</a><br><a href="http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab" target="_blank">http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab</a><br>