[pgpool-general: 4478] pgpool2/Wildfly pools and lost connections

[Jose Maria Olmo Millan]

Hello

   we have

   - AWS RDS Postgres 94 multiAZ with 2 read replicas
   - pgpool2 running in a Docker container with
      - stream replication
      - load balacing to master and 2 replicas
      - cache, initially shared memory, AWS elasticache next iterations of
      setup
   - 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.

                <datasource jndi-name="java:/jdbc/hieos-adt"
pool-name="hieos-adt-pool" enabled="true" use-java-context="true"
use-ccm="true"

                  min-pool-size="1" max-pool-size="1"
background-validation-millis="5000" idle-timeout-minutes="60000"
background-validation="true">
<connection-url>jdbc:postgresql://${env.POSTGRES_HOST:localhost}:${env.POSTGRES_PORT:5432}/${env.ADT_DATABASE:adt}</connection-url>
                   <driver>postgresql</driver>
<security>
<user-name>${env.POSTGRES_USERNAME:postgres}</user-name>
         <password>${env.POSTGRES_PASSWORD:postgres}</password>
            </security>
                                                         </datasource>


   Initially, pgpool and apps/wildfly starting correctly and there is
periodical connections from wildfly to pgpool

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


   BUT, once we have the first connections from java App, after 2 mins
later we got this in our wildfly log


01:11:43,403 ERROR
[com.vangent.hieos.logbrowser.servlets.GetTableServlet] (default
task-33) class org.postgresql.util.PSQLException:

An I/O error occurred while sending to the backend.


  We suppose the connection is closed


  I have found some recommendations about Tomcat pooling setup in
PGPOOL2 FAQ, but i havent found any guide about

how to setup Wildfly JNDI datasource.


   I will appreciate any guidance or link to information about this.


Thanks in advance

Regards


-- 
Jose M. Olmo, Founder & CEO, Prevvy's product lead,  a Spaniard (de mi
querida Madrid!!!) in the States
healthcentrix.com, prevvy.co
[image: Inline image 1]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160221/c8a1ad79/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logo_healthcentrix.jpg
Type: image/jpeg
Size: 18405 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160221/c8a1ad79/attachment-0001.jpg>