[pgpool-general: 6386] Re: jdbc connections

[Bo Peng]

Hi,

On Mon, 7 Jan 2019 17:35:43 +0100
Sylvie Pruvot <sylvie.halat at gmail.com> wrote:

>  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?

I'm not sure if this is Pgpool-II's problem.
Does the same error occur even if connecting directly to PostgreSQL?

Is there some error in pgpool's log?
If you could provide a test program to reproduce this issue, 
I will look into it.

> Regards
> S. Halat


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan