<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<font size="4">PgPool 4.3.7 and PG 14.7<br>
<br>
By "occasionally", I mean 1 or 2 times for every 500 "batches" of
data we process.<br>
<br>
Attached is the error message text, the pgpool.conf file and
postgresql.conf file.<br>
<br>
"ps | aux | grep <db application user name>" shows maybe a
dozen connections to PgPool.<br>
<br>
We do not get these errors when connecting directly to the
database on node "a".<br>
<br>
It's a three node cluster (named "a", "b" and "c"). The VIP is
attached to node "c", and the PostgreSQL primary database is on
node "a". PG streaming replica is node "b".<br>
<br>
Putting the VIP on node "a" does _not_ solve the problem (but it
does make things run slower).<br>
<br>
"num_init_children = 350" on all three nodes, and "max_connections
= 400" on the two DB servers.<br>
<br>
There's nothing in the error logs where PgPool "log_min_messages =
notice" and Postgresql log_min_error_statement and
log_min_messages are both = info, and client_min_messages =
notice.<br>
<br>
Where else should we look?<br>
</font><br>
<div class="moz-signature">-- <br>
Born in Arizona, moved to Babylonia.</div>
</body>
</html>