<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Hi,<br>
I answer you point by point:<br>
<br>
</font></font>On Thursday, September 12, 2019, Tatsuo Ishii
<a class="moz-txt-link-rfc2396E" href="mailto:ishii@sraoss.co.jp"><ishii@sraoss.co.jp></a> wrote:
<blockquote type="cite"
cite="mid:20190912.104200.531019519860583478.t-ishii@sraoss.co.jp">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Hi,
on a node that had never had problems, the pgpool often goes down from
about 2 weeks. In the log it looks like a connection problem that
really doesn't seem to exist. When I restart pgpool after a few hours
it goes down again. What could be the problem?
The log also seems to fail to ping trusted servers (which are google
ones).
An extract of pgpool.log is in attached file.
Please, help me.
Thanks!
Best regards.
Giancarlo
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
"Goes down" means clients cannot connect to the pgpool or any other
situation?
</pre>
</blockquote>
</blockquote>
</blockquote>
It means that pgpool process goes down.<br>
<br>
<br>
<blockquote type="cite"
cite="mid:20190912.104200.531019519860583478.t-ishii@sraoss.co.jp">
<blockquote type="cite">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">In the log it looks like a connection problem that
really doesn't seem to exist. When I restart pgpool after a few hours
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Can you please point out which line number in the log file you are
referring to when you say "looks like a connection problem"?</pre>
</blockquote>
</blockquote>
</blockquote>
because ping fails to all trusted servers:<br>
<pre style="white-space: pre-wrap; color: rgb(0, 0, 0); font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial;">2019-09-11 00:17:21: pid 26292: WARNING: watchdog failed to ping host"8.8.8.8"
2019-09-11 00:17:21: pid 26292: DETAIL: ping process exits with code: 1
2019-09-11 00:17:21: pid 26292: WARNING: watchdog failed to ping host"8.8.4.4"
2019-09-11 00:17:21: pid 26292: DETAIL: ping process exits with code: 1
2019-09-11 00:17:21: pid 26292: WARNING: watchdog lifecheck, failed to connect to any trusted servers
But really the connection does not go down.
Maybe a watchdog problem?
Is it possible to set up a number of ping attempts before throwing down pgpools?
</pre>
<blockquote type="cite"
cite="mid:20190912.104200.531019519860583478.t-ishii@sraoss.co.jp">
<blockquote type="cite">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
Finally,
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">on a node that had never had problems, the pgpool often goes down from
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Do you remember anything changed when the problem has started?</pre>
</blockquote>
</blockquote>
</blockquote>
No changes<br>
<br>
<br>
<blockquote type="cite"
cite="mid:20190912.104200.531019519860583478.t-ishii@sraoss.co.jp">
<blockquote type="cite">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en.php">http://www.sraoss.co.jp/index_en.php</a>
Japanese:<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
--
regards
ujang jaenudin | DBA Consultant (Freelancer)
<a class="moz-txt-link-freetext" href="http://ora62.wordpress.com">http://ora62.wordpress.com</a>
<a class="moz-txt-link-freetext" href="http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab">http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab</a>
</pre>
</blockquote>
</blockquote>
<br>
</body>
</html>