[pgpool-general: 8856] Fwd: pgpool is not accepting connections

[Zhaoxun Yan]

I have also tested connecting postgres directly via ip address registered
as first backend in pgpool.conf
backend_hostname0 = '172.17.0.2'

And it works:
# psql -h 172.17.0.2 -p 5432 -U checker -c '\l' template1
Password for user checker:
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access
privileges
-----------+----------+----------+-------------+-------------+-----------------------
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
         +
           |          |          |             |             |
postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
         +
           |          |          |             |             |
postgres=CTc/postgres+
           |          |          |             |             |
checker=CTc/postgres
(3 rows)

while pgpool getsdozens of subprocess waiting for connection, it still
believes that all nodes are down:

# ps aux|grep pgpool|grep -v grep
root      100949  0.0 17.5 149080 137180 ?       Ss   Jun28   0:00 pgpool
root      100950  0.0  0.3  15308  2932 ?        S    Jun28   0:00 pgpool:
PgpoolLogger
root      100953  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100955  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100956  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100958  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100959  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100960  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100961  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100962  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100963  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100964  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100966  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100967  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100969  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100970  0.0  0.3 149080  2784 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100971  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100972  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100973  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100974  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100975  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100977  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100978  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100981  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100982  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      100983  0.0  0.3 149080  2788 ?        S    Jun28   0:00 pgpool:
wait for connection request
root      101010  0.0  0.1 149084  1352 ?        S    Jun28   0:00 pgpool:
PCP: wait for connection request
root      101011  0.0  0.1 149080  1352 ?        S    Jun28   0:00 pgpool:
worker process

---------- Forwarded message ---------
From: Zhaoxun Yan <yan.zhaoxun at gmail.com>
Date: Wed, Jun 28, 2023 at 4:47 PM
Subject: pgpool is not accepting connections
To: <pgpool-general at pgpool.net>


Hi guys!

I have tested local postgresql, and it is ok for psql works:
psql -h 127.0.0.1  -U checker -c '\l' template1
But as I add in `-p 9999` the pgpool is down:
psql -h 127.0.0.1 -p 9999 -U checker -c '\l' template1
And I have found the latest log with these lines repeating:

2023-06-28 16:36:22.928: child pid 100980: FATAL:  pgpool is not accepting
any new connections
2023-06-28 16:36:22.928: child pid 100980: DETAIL:  all backend nodes are
down, pgpool requires at least one valid node
2023-06-28 16:36:22.928: child pid 100980: HINT:  repair the backend nodes
and restart pgpool
2023-06-28 16:36:22.928: main pid 100949: LOG:  reaper handler
2023-06-28 16:36:22.929: main pid 100949: LOG:  child process with pid:
100980 exited with success and will not be restarted
2023-06-28 16:36:22.929: main pid 100949: LOG:  reaper handler: exiting
normally
2023-06-28 16:36:28.899: child pid 100976: FATAL:  pgpool is not accepting
any new connections

Attached is the current pgpool configuration.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230629/8fc258f9/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 52934 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230629/8fc258f9/attachment-0001.obj>