[pgpool-general: 6394] Re: jdbc connections

[Jaime Soler]

hi,

could you share us the configuration of the datasource, are you using XA
datasource or non-XA ? in case of use of XA did you configured
max_prepared_transactions on all your database server ? also did you
configured the validation query of your datasoucer ?

Regards

El mié., 9 ene. 2019 a las 10:33, Sylvie Pruvot (<sylvie.halat at gmail.com>)
escribió:

> 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
>>
>> _______________________________________________
> 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/20190111/d4912f43/attachment.html>