Plan could not be started JDBC exception in Hibernate data access: SQLException for SQL

Julian Jaramillo

Hi Team,
one of our plans stopped working recently, when we try to run manually we get this error and the plan doesn't start at all:

Plan 'PTAUT' could not be started. org.springframework.orm.hibernate5.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [53300]; error code [0]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

in the logs we can see this:

JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [53300]; error code [0]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Caused by: org.postgresql.util.PSQLException: ERROR: remaining connection slots are reserved for non-replication superuser and rds_superuser connections

We have Bamboo datacentre 8.1.2 build 80109 connected to RDS

anyone knows what could be the problem here?

Thank you!

Julian Jaramillo

we found the reason why our plans wouldn't run.

we hit a limit on the number of iterations.
basically one of our customers configured a plan to run every 15 min, after a year this became over 26k iterations and suddenly stop working

deleting  old entries from the history of the plan got it working again, however it was easier to clone it and start fresh