[pgpool-general: 8830] DB Connection ERROR during a failover

Gopikrishnan nksgopikrishnan at gmail.com
Tue Jun 13 21:09:49 JST 2023


In my application, I see an error:

Caused by: org.postgresql.util.PSQLException: FATAL: failed to create a
backend connection
  Detail: executing failover on backend
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
at
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)

Is there a configuration I can use to make the connection wait for the
failover to complete?
Also, I can see that the failover was not indeed a failover, i.e the
failover would eventually
be skipped since it is not the primary node that failed:

2023-06-12_18:27:55 [failover.sh]: failed_node_id=1 failed_host=10.198.49.42
2023-06-12_18:27:55 [failover.sh]: old_master_node_id=0
old_primary_node_id=0
2023-06-12_18:27:55 [failover.sh]: new_primary_node_id=0
new_master_host=10.198.49.41
2023-06-12_18:27:55 [failover.sh]: Node 1 dies, but it's not the primary
node. Skipping failover.

*Thanks & Regards*
*Gopi*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230613/4a5721a8/attachment.htm>


More information about the pgpool-general mailing list