[pgpool-general: 6403] Re: jdbc connections

[Jaime Soler]

I didn't see any errors. Could you give us details of pgpool setup and
jboss datasource configuration ?

El lun., 28 ene. 2019 a las 14:53, Sylvie Pruvot (<sylvie.halat at gmail.com>)
escribió:

> Hi,
> When we run test with pgppol, we have always the same warnings
> I send you debug pgpool's log.
> Thanks
> Best regards
> S Halat
>
> Le mer. 9 janv. 2019 à 01:34, Bo Peng <pengbo at sraoss.co.jp> a écrit :
>
>> 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
>>
>> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190202/597f9a9f/attachment.html>