<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">&lt;<a href="mailto:sylvie.halat@gmail.com">sylvie.halat@gmail.com</a>&gt;</span><br>Date: mar. 5 févr. 2019 à 09:49<br>Subject: Re: [pgpool-general: 6385] jdbc connections<br>To: Bo Peng &lt;<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>&gt;<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>&lt;datasource ....</div><div>&lt;connection-url ..../conection-url&gt;</div><div>



















<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">&lt;driver-class&gt;org.postgresql.Driver&lt;/driver-class&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span> </span>&lt;driver&gt;postgresql&lt;/driver&gt;<span></span></p>





</div><div>



















<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">&lt;pool&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;min-pool-size&gt;10&lt;/min-pool-size&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;max-pool-size&gt;200&lt;/max-pool-size&gt;<span></span></p><span> </span>&lt;/pool&gt;</div><div>&lt;security&gt;</div><div>&lt;user-name&gt;XXXXX&lt;/user-name&gt;</div><div>&lt;password&gt;XXXXX&lt;/password&gt;</div><div>&lt;/security&gt;<br></div><div>



















<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;valid-connection-checker
class-name=&quot;org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker&quot;/&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;validate-on-match&gt;true&lt;/validate-on-match&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;background-validation&gt;false&lt;/background-validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;exception-sorter class-name=&quot;org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter&quot;/&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;/validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span> 
</span>&lt;/datasource&gt;</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">After (no warnings Jboss):</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">
</p><div>&lt;datasource ....</div><div>&lt;connection-url ..../conection-url&gt;</div><div>



















<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">&lt;driver-class&gt;org.postgresql.Driver&lt;/driver-class&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span> </span>&lt;driver&gt;postgresql&lt;/driver&gt;</p></div>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">



















</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;pool&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;min-pool-size&gt;0&lt;/min-pool-size&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;/pool&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;timeout&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;idle-timeout-minutes&gt;1&lt;/idle-timeout-minutes&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;/timeout&gt;</p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">
</p><div>&lt;security&gt;</div><div>&lt;user-name&gt;XXXXX&lt;/user-name&gt;</div><div>&lt;password&gt;XXXXX&lt;/password&gt;</div><div>&lt;/security&gt;<br></div><div>



















<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;valid-connection-checker
class-name=&quot;org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLValidConnectionChecker&quot;/&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;validate-on-match&gt;true&lt;/validate-on-match&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;background-validation&gt;false&lt;/background-validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                       
</span>&lt;exception-sorter class-name=&quot;org.jboss.jca.adapters.jdbc.extensions.postgres.PostgreSQLExceptionSorter&quot;/&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span>                   
</span>&lt;/validation&gt;<span></span></p>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><span> 
</span>&lt;/datasource&gt;</p></div>

<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif">Best regards<br></p><br><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><br></p><p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,sans-serif"><br><span></span></p>





<p class="m_1215209346621553666gmail-MsoNoSpacing" style="margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:&quot;Calibri&quot;,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 &lt;<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>&gt; 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&#39;t find any errors,<br>
could you show me the time when application outputs warnings.<br>
Or show me the same time&#39;s application logs.<br>
<br>
On Mon, 28 Jan 2019 14:53:39 +0100<br>
Sylvie Pruvot &lt;<a href="mailto:sylvie.halat@gmail.com" target="_blank">sylvie.halat@gmail.com</a>&gt; wrote:<br>
<br>
&gt; Hi,<br>
&gt; When we run test with pgppol, we have always the same warnings<br>
&gt; I send you debug pgpool&#39;s log.<br>
&gt; Thanks<br>
&gt; Best regards<br>
&gt; S Halat<br>
&gt; <br>
&gt; Le mer. 9 janv. 2019 à 01:34, Bo Peng &lt;<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>&gt; a écrit :<br>
&gt; <br>
&gt; &gt; Hi,<br>
&gt; &gt;<br>
&gt; &gt; On Mon, 7 Jan 2019 17:35:43 +0100<br>
&gt; &gt; Sylvie Pruvot &lt;<a href="mailto:sylvie.halat@gmail.com" target="_blank">sylvie.halat@gmail.com</a>&gt; wrote:<br>
&gt; &gt;<br>
&gt; &gt; &gt;  Hi,<br>
&gt; &gt; &gt; I&#39;m using pgpool for load balancer and control VIP adress (3 servers<br>
&gt; &gt; &gt; configured for streaming replication ) . Pgpool is accessed by<br>
&gt; &gt; applications<br>
&gt; &gt; &gt; servers (JBOSS /spring-jdbc)<br>
&gt; &gt; &gt; Version Pgpool :<br>
&gt; &gt; &gt; pgpool-II-pg10-4.0.2-1pgdg.rhel7.x86_64<br>
&gt; &gt; &gt; Version PostgreSQL : 10.4<br>
&gt; &gt; &gt; Version JBOSS:<br>
&gt; &gt; &gt; jboss-eap-7.0.2-1<br>
&gt; &gt; &gt; During tests , application server logs many warnings :<br>
&gt; &gt; &gt; 2018-12-20 16:36:26,956 WARN<br>
&gt; &gt; &gt; [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default<br>
&gt; &gt; &gt; task-19) IJ000621: Destroying connection that could not be validated:<br>
&gt; &gt; &gt;<br>
&gt; &gt; org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@359e117e<br>
&gt; &gt; [state=NORMAL<br>
&gt; &gt; &gt; managed<br>
&gt; &gt; &gt;<br>
&gt; &gt; connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@3b73b9f1<br>
&gt; &gt; &gt; connection handles=0 lastReturned=1545320007568<br>
&gt; &gt; lastValidated=1545318977951<br>
&gt; &gt; &gt; lastCheckedOut=1545320007543 trackByTx=false<br>
&gt; &gt; &gt; pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@6653ef59<br>
&gt; &gt; &gt; mcp=SemaphoreConcurrentLinkedQueueManagedConnectionPool@cae2d43<br>
&gt; &gt; [pool=ds_rest_api]<br>
&gt; &gt; &gt; xaResource=LocalXAResourceImpl@17dce3ba[connectionListener=359e117e<br>
&gt; &gt; &gt; connectionManager=62c08011 warned=false currentXid=null<br>
&gt; &gt; &gt; productName=PostgreSQL productVersion=10.4 jndiName=java:jboss/rest_api]<br>
&gt; &gt; &gt; txSync=null]<br>
&gt; &gt; &gt; 2018-12-20 16:48:27,416 WARN<br>
&gt; &gt; &gt; [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory]<br>
&gt; &gt; (default<br>
&gt; &gt; &gt; task-23) IJ030027: Destroying connection that is not valid, due to the<br>
&gt; &gt; &gt; following exception: org.postgresql.jdbc.PgConnection@28dcf51f:<br>
&gt; &gt; &gt; org.postgresql.util.PSQLException: An I/O error occurred while sending to<br>
&gt; &gt; &gt; the backend.<br>
&gt; &gt; &gt; Please, can you help to figure out what&#39;s could be wrong?<br>
&gt; &gt;<br>
&gt; &gt; I&#39;m not sure if this is Pgpool-II&#39;s problem.<br>
&gt; &gt; Does the same error occur even if connecting directly to PostgreSQL?<br>
&gt; &gt;<br>
&gt; &gt; Is there some error in pgpool&#39;s log?<br>
&gt; &gt; If you could provide a test program to reproduce this issue,<br>
&gt; &gt; I will look into it.<br>
&gt; &gt;<br>
&gt; &gt; &gt; Regards<br>
&gt; &gt; &gt; S. Halat<br>
&gt; &gt;<br>
&gt; &gt;<br>
&gt; &gt; --<br>
&gt; &gt; Bo Peng &lt;<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>&gt;<br>
&gt; &gt; SRA OSS, Inc. Japan<br>
&gt; &gt;<br>
&gt; &gt;<br>
<br>
<br>
-- <br>
Bo Peng &lt;<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>&gt;<br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div>
</div></div>