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 · Accepted solution]

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

[Julian Jaramillo]

Hi @Eduardo Alvarenga 
thank you very much for the information, checking the database we are pretty sure max_connections is not the problem. we are well below
 

SHOW max_connections; 
3466

we also experience this problem with only one plan in particular, all the other plans are working fine.

we suspect there is something in the cache related to this plan that is throwing this error.
is there a way to refresh that for a particular plan?

Cheers

[Eduardo Alvarenga]

Hey @Julian Jaramillo

The following message:

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

Indicates that the database has exceeded the max_connections parameter.

You can try extending upgrade your RDS instance or adjusting the max_connections on parameter groups directly on the database:

• Working with parameter groups

Regards,

Eduardo Alvarenga
Atlassian Support APAC