Spring boot/Amazon PostgreSQL RDS connection pool issue

Question

I am troubleshooting an issue with a Spring Boot app connecting to a PostgreSQL database. The app runs normally, but under fairly moderate load it will begin to log errors like this:

java.sql.SQLException: Timeout after 30000ms of waiting for a connection.

This is running on an Amazon EC2 instance connecting to a PostgreSQL RDS. The app is configured like the following:

spring.datasource.url=jdbc:postgresql://[rds_path]:5432/[db name]
spring.datasource.username=[username]
spring.datasource.password=[password]
spring.datasource.max-active=100

In the AWS console, I see 60 connections active to the database, but that is across several Spring Boot apps (not all this app). When I query the database for current activity using pg_stat_activity, I see all but one or 2 connections in an idle state. It would seem the Spring Boot app is not using all available connections? Or is somehow leaking connections? I'm trying to interpret how pg_stat_activity would show so many idle connections and the app still getting connection pool time outs.

probably firewall issue. are you sure you opened port for your application server? — Dzmitry Savinkou
– Dzmitry Savinkou, Commented May 17, 2016 at 23:09
Sorry, clarified my post. Only under some load does the application encounter connection errors. — Mike
– Mike, Commented May 17, 2016 at 23:30

Mike · Accepted Answer · 2016-05-18 18:17:15Z

0

Figured it out. Spring is using the Hikari database connection pooling (didn't realize that until after more closely inspecting the stack trace). Hikari configuration parameters have different names, to set the pool size you use maximum-pool-size. Updated that and problem solved.

answered May 18, 2016 at 18:17

Mike

1,09116 silver badges37 bronze badges

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

2 Comments

Anantha Raman Over a year ago

Hey Mike! Can you please help me with the setup. I am facing same problem here.

acolleoni Jul 28 at 10:29

spring.datasource.hikari.maximum-pool-size=1 worked for me

Collectives™ on Stack Overflow

Spring boot/Amazon PostgreSQL RDS connection pool issue

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related