DevTest Error - com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
book
Article ID: 113244
calendar_today
Updated On:
Products
CA Application TestCA Continuous Application Insight (PathFinder)
Issue/Introduction
After running for several days seeing Errors in the log: - Database error recovering from misfires - Failed restore connection's original auto commit setting. - BeanCreationNotAllowedException occurred when processing request: [POST] /api/v1/dradis/registries/Registry%40devbsv0186.corp.erac.com%3A2010 Error creating bean with name 'multipartResolver': Singleton bean creation not allowed while the singletons of this factory are in destruction (Do not request a bean from a BeanFactory in a destroy method implementation!) - Couldn't rollback jdbc connection. No operations allowed after connection closed.
Environment
Release: All supported DevTest releases. Component: ITKOTF
Cause
These errors are over and over in the enterprisedashboard.log file:
2018-08-01 00:22:12,117Z (19:22) [quartzScheduler_QuartzSchedulerThread] ERROR org.springframework.scheduling.quartz.LocalDataSourceJobStore - Couldn't rollback jdbc connection. No operations allowed after connection closed. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
Resolution
DBA changed the timeout from 60 to 28000+ on the Enterprise Dashboard MySQL database.