Tomcat not reconnecting PostgreSQL JDBC pools on DB restart

Question

Recently we had to restart our database server (yes, a production one), and one of the Tomcats didn't reconnect to the JNDI resources.

This is our JNDI resource definition:

<Resource name="jdbc/postgres" auth="Container"
          type="javax.sql.DataSource"
          driverClassName="org.postgresql.Driver"
          url="jdbc:postgresql://10.1.0.104:5432/db"
          username="******" password="*****"
          maxTotal="30" maxIdle="5" maxWaitMillis="10000"
          logAbandoned="true" removeAbandonedOnBorrow="true"
          removeAbandonedOnMaintenance="true"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          validationQueryTimeout="5" validationQuery="select 1"
          testOnBorrow="true" />

Software versions:

Debian GNU/Linux 8.2 (jessie)
Apache Tomcat/8.0.14
OpenJDK 1.7.0_91-b02
PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit

What could be wrong? Why it didn't reconnect automatically?

PS: This maybe is a cross forum question dba vs stackoverflow, but as it involves both side don't know actually where to ask it.

What is different with your previous question? stackoverflow.com/questions/36139235/… — Marco
– Marco, Commented Apr 8, 2016 at 13:42

Matteo Baldi · Accepted Answer · 2016-04-07 07:37:19Z

1

It could happen on database server restart that the webserver connection pool become faulty or incapable of reconnect to the db. If you can't restart your Tomcat instance after the database restart (easiest choice) you should configure your connection pool to test, remove and replace your connections. See the validationQuery, testOnConnect and testWhileIdle attributes in the Tomcat 8 jdbc-pool guide.

answered Apr 7, 2016 at 7:37

Matteo Baldi

5,83811 gold badges44 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

gvasquez Over a year ago

I already gave the validationQuery, but not the other 2 attributes

Collectives™ on Stack Overflow

Tomcat not reconnecting PostgreSQL JDBC pools on DB restart

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related