<div dir="ltr"><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">---------- Forwarded message ---------<br>From: <b class="gmail_sendername" dir="auto">Sylvie Pruvot</b> <span dir="ltr"><<a href="mailto:sylvie.halat@gmail.com">sylvie.halat@gmail.com</a>></span><br>Date: mar. 5 févr. 2019 à 09:49<br>Subject: Re: [pgpool-general: 6385] jdbc connections<br>To: Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>><br></div><br><br><div dir="ltr"><div>Hi</div><div><br></div><div>We have solved these warnings , we have modified the datasource configuration.</div><div><br></div><div>Configuration DATASOURCE:</div><div><br></div><div>Before (warnings jboss):</div><div><datasource ....</div><div><connection-url ..../conection-url></div><div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><driver-class>org.postgresql.Driver</driver-class><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span> </span><driver>postgresql</driver><span></span></p>
</div><div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><pool><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><min-pool-size>10</min-pool-size><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><max-pool-size>200</max-pool-size><span></span></p><span> </span></pool></div><div><security></div><div><user-name>XXXXX</user-name></div><div><password>XXXXX</password></div><div></security><br></div><div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><validate-on-match>true</validate-on-match><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><background-validation>false</background-validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></datasource></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif">After (no warnings Jboss):</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif">
</p><div><datasource ....</div><div><connection-url ..../conection-url></div><div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><driver-class>org.postgresql.Driver</driver-class><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span> </span><driver>postgresql</driver></p></div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif">
</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><pool><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><min-pool-size>0</min-pool-size><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></pool><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><timeout><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><idle-timeout-minutes>1</idle-timeout-minutes><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></timeout></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif">
</p><div><security></div><div><user-name>XXXXX</user-name></div><div><password>XXXXX</password></div><div></security><br></div><div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><valid-connection-checker
class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker"/><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><validate-on-match>true</validate-on-match><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><background-validation>false</background-validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span><exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter"/><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></validation><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span>
</span></datasource></p></div>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif">Best regards<br></p><br><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><br><span></span></p>
<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:"Calibri",sans-serif"><span></span></p>
<br><span></span>
</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le mer. 30 janv. 2019 à 04:42, Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
Thank you for the debug log of pgpool.<br>
<br>
Because in the pgpool.log I can't find any errors,<br>
could you show me the time when application outputs warnings.<br>
Or show me the same time's application logs.<br>
<br>
On Mon, 28 Jan 2019 14:53:39 +0100<br>
Sylvie Pruvot <<a href="mailto:sylvie.halat@gmail.com" target="_blank">sylvie.halat@gmail.com</a>> wrote:<br>
<br>
> Hi,<br>
> When we run test with pgppol, we have always the same warnings<br>
> I send you debug pgpool's log.<br>
> Thanks<br>
> Best regards<br>
> S Halat<br>
> <br>
> Le mer. 9 janv. 2019 à 01:34, Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>> a écrit :<br>
> <br>
> > Hi,<br>
> ><br>
> > On Mon, 7 Jan 2019 17:35:43 +0100<br>
> > Sylvie Pruvot <<a href="mailto:sylvie.halat@gmail.com" target="_blank">sylvie.halat@gmail.com</a>> wrote:<br>
> ><br>
> > > Hi,<br>
> > > I'm using pgpool for load balancer and control VIP adress (3 servers<br>
> > > configured for streaming replication ) . Pgpool is accessed by<br>
> > applications<br>
> > > servers (JBOSS /spring-jdbc)<br>
> > > Version Pgpool :<br>
> > > pgpool-II-pg10-4.0.2-1pgdg.rhel7.x86_64<br>
> > > Version PostgreSQL : 10.4<br>
> > > Version JBOSS:<br>
> > > jboss-eap-7.0.2-1<br>
> > > During tests , application server logs many warnings :<br>
> > > 2018-12-20 16:36:26,956 WARN<br>
> > > [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default<br>
> > > task-19) IJ000621: Destroying connection that could not be validated:<br>
> > ><br>
> > org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@359e117e<br>
> > [state=NORMAL<br>
> > > managed<br>
> > ><br>
> > connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@3b73b9f1<br>
> > > connection handles=0 lastReturned=1545320007568<br>
> > lastValidated=1545318977951<br>
> > > lastCheckedOut=1545320007543 trackByTx=false<br>
> > > pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@6653ef59<br>
> > > mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@cae2d43<br>
> > [pool=ds_rest_api]<br>
> > > xaResource=LocalXAResourceImpl@17dce3ba[connectionListener=359e117e<br>
> > > connectionManager=62c08011 warned=false currentXid=null<br>
> > > productName=PostgreSQL productVersion=10.4 jndiName=java:jboss/rest_api]<br>
> > > txSync=null]<br>
> > > 2018-12-20 16:48:27,416 WARN<br>
> > > [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory]<br>
> > (default<br>
> > > task-23) IJ030027: Destroying connection that is not valid, due to the<br>
> > > following exception: org.postgresql.jdbc.PgConnection@28dcf51f:<br>
> > > org.postgresql.util.PSQLException: An I/O error occurred while sending to<br>
> > > the backend.<br>
> > > Please, can you help to figure out what's could be wrong?<br>
> ><br>
> > I'm not sure if this is Pgpool-II's problem.<br>
> > Does the same error occur even if connecting directly to PostgreSQL?<br>
> ><br>
> > Is there some error in pgpool's log?<br>
> > If you could provide a test program to reproduce this issue,<br>
> > I will look into it.<br>
> ><br>
> > > Regards<br>
> > > S. Halat<br>
> ><br>
> ><br>
> > --<br>
> > Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
> > SRA OSS, Inc. Japan<br>
> ><br>
> ><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div>
</div></div>