[pgpool-general: 9052] 0 th backend is not valid after upgrading to 4.5.1

Emond Papegaaij emond.papegaaij at gmail.com
Wed Mar 27 17:36:38 JST 2024


Hi,

After upgrading from 4.5.0 to 4.5.1 we see lots of regressions in our
test-suite when failovers are involved with the following exception in
WildFly:
Caused by: org.postgresql.util.PSQLException: ERROR: unable to read message
kind from backend
  Detail: 0 th backend is not valid

I'm not sure what is causing this, but I've got the feeling that pgpool
keeps trying to send queries to a database that not available. I've
attached logging from pgpool. You can find the first error at 04:10:16
(or 2024-03-27T03:10:16.735933246Z pgpool timestamp).

Best regards,
Emond
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240327/fab0afd1/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: tkh-pgpool
Type: application/octet-stream
Size: 261045 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240327/fab0afd1/attachment-0001.obj>


More information about the pgpool-general mailing list