[pgpool-general: 6405] Fwd: jdbc connections

[Sylvie Pruvot]

---------- Forwarded message ---------
From: Sylvie Pruvot <sylvie.halat at gmail.com>
Date: mar. 5 févr. 2019 à 09:49
Subject: Re: [pgpool-general: 6385] jdbc connections
To: Bo Peng <pengbo at sraoss.co.jp>


Hi

We have solved these warnings , we have modified the datasource
configuration.

Configuration DATASOURCE:

Before (warnings jboss):
<datasource ....
<connection-url ..../conection-url>

<driver-class>org.postgresql.Driver</driver-class>

 <driver>postgresql</driver>

<pool>

                        <min-pool-size>10</min-pool-size>

                        <max-pool-size>200</max-pool-size>
</pool>
<security>
<user-name>XXXXX</user-name>
<password>XXXXX</password>
</security>

                    <validation>

                        <valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>

                        <validate-on-match>true</validate-on-match>

                        <background-validation>false</background-validation>

                        <exception-sorter
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>

                    </validation>

  </datasource>


After (no warnings Jboss):

<datasource ....
<connection-url ..../conection-url>

<driver-class>org.postgresql.Driver</driver-class>

 <driver>postgresql</driver>

                    <pool>

                        <min-pool-size>0</min-pool-size>

                    </pool>

                    <timeout>

                        <idle-timeout-minutes>1</idle-timeout-minutes>

                    </timeout>

<security>
<user-name>XXXXX</user-name>
<password>XXXXX</password>
</security>

                    <validation>

                        <valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/>

                        <validate-on-match>true</validate-on-match>

                        <background-validation>false</background-validation>

                        <exception-sorter
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/>

                    </validation>

  </datasource>


Best regards






Le mer. 30 janv. 2019 à 04:42, Bo Peng <pengbo at sraoss.co.jp> a écrit :

> Hi,
>
> Thank you for the debug log of pgpool.
>
> Because in the pgpool.log I can't find any errors,
> could you show me the time when application outputs warnings.
> Or show me the same time's application logs.
>
> On Mon, 28 Jan 2019 14:53:39 +0100
> Sylvie Pruvot <sylvie.halat at gmail.com> wrote:
>
> > 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
> > >
> > >
>
>
> --
> 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/20190205/782b6029/attachment.html>