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

Jose Maria Olmo Millan jmolmo at healthcentrix.com
Mon Feb 22 10:14:57 JST 2016


   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
   - 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"

                  min-pool-size="1" max-pool-size="1"
background-validation-millis="5000" idle-timeout-minutes="60000"

   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


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>

More information about the pgpool-general mailing list