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

Julian Jaramillo July 12, 2022

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!

3 answers

1 accepted

0 votes
Answer accepted
Julian Jaramillo July 27, 2022

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

0 votes
Julian Jaramillo July 13, 2022

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

0 votes
Eduardo Alvarenga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
July 12, 2022

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:

Regards,

Eduardo Alvarenga
Atlassian Support APAC

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events