<div dir="ltr">Hello<div><br></div><div> we have </div><div><ul><li>AWS RDS Postgres 94 multiAZ with 2 read replicas<br></li><li>pgpool2 running in a Docker container with</li><ul><li>stream replication</li><li>load balacing to master and 2 replicas</li><li>cache, initially shared memory, AWS elasticache next iterations of setup</li></ul><li>and serveral Java Applications on top of Wildfly 8.1 using this JNDI datasource where we have tried to delete JDNI pool management from Wildfly and pgpool willl be pool manager.</li></ul><div><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"> <datasource</span> <span class="" style="color:teal">jndi-name=</span><span class="" style="color:rgb(187,136,68)">"java:/jdbc/hieos-adt"</span> <span class="" style="color:teal">pool-name=</span><span class="" style="color:rgb(187,136,68)">"hieos-adt-pool"</span> <span class="" style="color:teal">enabled=</span><span class="" style="color:rgb(187,136,68)">"true"</span> <span class="" style="color:teal">use-java-context=</span><span class="" style="color:rgb(187,136,68)">"true"</span> <span class="" style="color:teal">use-ccm=</span><span class="" style="color:rgb(187,136,68)">"true"</span> </pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:teal"> min-pool-size=</span><span class="" style="color:rgb(187,136,68)">"1"</span> <span class="" style="color:teal">max-pool-size=</span><span class="" style="color:rgb(187,136,68)">"1"</span> <span class="" style="color:teal">background-validation-millis=</span><span class="" style="color:rgb(187,136,68)">"5000"</span> <span class="" style="color:teal">idle-timeout-minutes=</span><span class="" style="color:rgb(187,136,68)">"60000"</span> <span class="" style="color:teal">background-validation=</span><span class="" style="color:rgb(187,136,68)">"true"</span><span class="" style="color:navy">></span>
<a name="standalone.xml-174" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"><connection-url></span>jdbc:postgresql://${env.POSTGRES_HOST:localhost}:${env.POSTGRES_PORT:5432}/${env.ADT_DATABASE:adt}<span class="" style="color:navy"></connection-url></span>
<a name="standalone.xml-175" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"><driver></span>postgresql<span class="" style="color:navy"></driver></span>
<a name="standalone.xml-176" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"><security></span>
<a name="standalone.xml-177" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"><user-name></span>${env.POSTGRES_USERNAME:postgres}<span class="" style="color:navy"></user-name></span>
<a name="standalone.xml-178" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"><password></span>${env.POSTGRES_PASSWORD:postgres}<span class="" style="color:navy"></password></span>
<a name="standalone.xml-179" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"></security></span>
<a name="standalone.xml-181" style="color:rgb(53,114,176)"></a> <span class="" style="color:navy"></datasource></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"><br></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"> Initially, pgpool and apps/wildfly starting correctly and there is periodical connections from wildfly to pgpool</span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class="" style="line-height:16.8px"><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace">2016-02-22 01:07:53: pid 59: LOCATION: child.c:2110
2016-02-22 01:08:18: pid 60: LOG: new connection received
2016-02-22 01:08:18: pid 60: DETAIL: connecting host=ip-10-244-0-1.ec2.internal port=39734
2016-02-22 01:08:18: pid 60: LOCATION: child.c:2110
2016-02-22 01:08:23: pid 46: LOG: new connection received
2016-02-22 01:08:23: pid 46: DETAIL: connecting host=ip-10-244-0-1.ec2.internal port=39751</font></span><span class="" style="color:navy;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4">
</span></pre><div><span class="" style="color:navy"><br></span></div><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"> BUT, once we have the first connections from java App, after 2 mins later we got this in our wildfly log</span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class=""><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace"><span style="line-height:16.8px"><br></span></font></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class=""><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace"><span style="line-height:16.8px">01:11:43,403 ERROR [com.vangent.hieos.logbrowser.servlets.GetTableServlet] (default task-33) class org.postgresql.util.PSQLException:</span></font></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class=""><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace"><span style="line-height:16.8px">An I/O error occurred while sending to the backend.</span></font></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class=""><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace"><span style="line-height:16.8px"><br></span></font></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px"><span class=""><font color="#000080" face="Consolas, Menlo, Liberation Mono, Courier, monospace"><span style="line-height:16.8px"> We suppose the connection is closed
</span><span style="line-height:1.4"><br></span></font></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><br></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"> I have found some recommendations about Tomcat pooling setup in PGPOOL2 FAQ, but i havent found any guide about </span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy">how to setup Wildfly JNDI datasource.</span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"><br></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"> I will appreciate any guidance or link to information about this.</span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy"><br></span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy">Thanks in advance</span></pre><pre style="margin-top:0px;margin-bottom:0px;padding:0px;font-family:Consolas,Menlo,'Liberation Mono',Courier,monospace;font-size:12px;line-height:1.4;color:rgb(51,51,51)"><span class="" style="color:navy">Regards</span></pre></div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div>Jose M. Olmo, Founder & CEO, Prevvy's product lead, a Spaniard (de mi querida Madrid!!!) in the States</div><div><a href="http://healthcentrix.com/" style="color:rgb(17,85,204)" target="_blank">healthcentrix.com</a>, <a href="http://prevvy.co" target="_blank">prevvy.co</a></div><div><img src="cid:ii_13ff1d140088050e" alt="Inline image 1" width="200" height="77"></div></div></div></div></div></div></div>
</div></div>