[pgpool-general: 6385] jdbc connections

Sylvie Pruvot sylvie.halat at gmail.com
Tue Jan 8 01:35:43 JST 2019


 Hi,
I'm using pgpool for load balancer and control VIP adress (3 servers
configured for streaming replication ) . Pgpool is accessed by applications
servers (JBOSS /spring-jdbc)
Version Pgpool :
pgpool-II-pg10-4.0.2-1pgdg.rhel7.x86_64
Version PostgreSQL : 10.4
Version JBOSS:
jboss-eap-7.0.2-1
During tests , application server logs many warnings :
2018-12-20 16:36:26,956 WARN
[org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default
task-19) IJ000621: Destroying connection that could not be validated:
org.jboss.jca.core.connectionmanager.listener.TxConnectionListener at 359e117e[state=NORMAL
managed
connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection at 3b73b9f1
connection handles=0 lastReturned=1545320007568 lastValidated=1545318977951
lastCheckedOut=1545320007543 trackByTx=false
pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool at 6653ef59
mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool at cae2d43[pool=ds_rest_api]
xaResource=LocalXAResourceImpl at 17dce3ba[connectionListener=359e117e
connectionManager=62c08011 warned=false currentXid=null
productName=PostgreSQL productVersion=10.4 jndiName=java:jboss/rest_api]
txSync=null]
2018-12-20 16:48:27,416 WARN
[org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (default
task-23) IJ030027: Destroying connection that is not valid, due to the
following exception: org.postgresql.jdbc.PgConnection at 28dcf51f:
org.postgresql.util.PSQLException: An I/O error occurred while sending to
the backend.
Please, can you help to figure out what's could be wrong?
Regards
S. Halat
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190107/552f98d1/attachment.html>


More information about the pgpool-general mailing list