[pgpool-general: 6390] Re: jdbc connections

[Sylvie Pruvot]

Thanks for reply
We don't have error when application server is connected directly ti
Postgresql.
Today , i can't test in debug mode , testing platform is not available but
i send the pgpool's logs when i will can test again .
Regards

Le mer. 9 janv. 2019 à 02:08, Bo Peng <pengbo at sraoss.co.jp> a écrit :

> Hi,
>
> On Wed, 9 Jan 2019 09:34:03 +0900
> Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> > 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?
>
> Could you provide pgpool's log includig client messages and debug log?
>
> Setting "log_client_messages = on" to output client messages to pgpool's
> log.
> And starting pgpool with "-d" option to log debug messages.
>
> > 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
> >
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
> >
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190109/22d9d5e7/attachment.html>