<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
On 3/14/23 03:00, Tatsuo Ishii wrote:<br>
<blockquote type="cite"
cite="mid:20230314.170003.1454665406536054372.t-ishii@sranhm.sra.co.jp">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">PgPool II 4.3.5 and Postgresql 13.10.
Three nodes: FISPCCPGS302a, b & c.
"a" has the primary database, "b" has the replica, and "c" has the VIP
(but no database).
One or more times a day, on each node, health_check times out when
trying to reach one or two of the others. (I'm working on figuring
out why that happens.)
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Maybe unstable network? You might want to use "SHOW
POOL_HEALTH_CHECK_STATS" command.
<a class="moz-txt-link-freetext" href="https://www.pgpool.net/docs/pgpool-II-4.3.5/en/html/sql-show-pool-health-check-stats.html">https://www.pgpool.net/docs/pgpool-II-4.3.5/en/html/sql-show-pool-health-check-stats.html</a></pre>
</blockquote>
<br>
health_check_max_retries was set to zero. I set it to 10 yesterday,
so we'll see what happens.<br>
<br>
<blockquote type="cite"
cite="mid:20230314.170003.1454665406536054372.t-ishii@sranhm.sra.co.jp">
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">What else happens is that nodes "b" and "c" will vote to failover from
"a" to "b", even though failover_on_backend_error = off.
Why does that happen?
<a class="moz-txt-link-freetext" href="https://www.pgpool.net/docs/pgpool-II-4.3.5/en/html/runtime-config-failover.html">https://www.pgpool.net/docs/pgpool-II-4.3.5/en/html/runtime-config-failover.html</a>
says it should just "report an error and disconnect the session in
case of such errors."
Is it because "if no client is connected, Pgpool-II will not detect
the event even if the parameter is on"? (This is a pre-production
system, so the application servers aren't talking to it.)
Attached is a log file extract and PGPOOL SHOW command.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
Turning off failover_on_backend_error prevents pgpool child process</pre>
</blockquote>
<br>
Meaning that "PostgreSQL backend connection" specifically and only
refers to processes which "do SQL stuff"?<br>
<br>
Because aren't <i>all</i> pgpool processes children of the "startup
pid"?<br>
<br>
<blockquote type="cite"
cite="mid:20230314.170003.1454665406536054372.t-ishii@sranhm.sra.co.jp">
<pre class="moz-quote-pre" wrap="">from triggering failover by failures like "An error occurs while
connecting to PostgreSQL, or network level errors occur while
communicating with it." (from the manual) This does not affect health
check process. i.e. Turning off failover_on_backend_error does not
prevent pgpool from trigerring failover by health check.
Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en/">http://www.sraoss.co.jp/index_en/</a>
Japanese:<a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp">http://www.sraoss.co.jp</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Born in Arizona, moved to Babylonia.</div>
</body>
</html>