flowable exception during resetting expired jobs: Could not open JDBC Connection for transaction

项目中遇到的一个问题，记录一下：项目中引入flowable后，生产环境运行一段时间后，出现了奇怪的问题，

[flowable-bpmn-reset-expired-jobs] org.flowable.job.service.impl.asyncexecutor.ResetExpiredJobsRunnable.resetJobs - exception during resetting expired jobs: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 43014ms. for engine bpmn org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 43014ms. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:305) at org.springframework.transaction.support.AbstractPlatformTransactionManager.startTransaction(AbstractPlatformTransactionManager.java:400) at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:137) at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:56) at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51) at org.flowable.job.service.impl.asyncexecutor.ResetExpiredJobsRunnable.resetJobs(ResetExpiredJobsRunnable.java:98) at org.flowable.job.service.impl.asyncexecutor.ResetExpiredJobsRunnable.run(ResetExpiredJobsRunnable.java:62) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLTransientConnectionException: HikariCP - Connection is not available, request timed out after 43014ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:261) ... 10 common frames omitted

然后网上各种找资料，https://github.com/flowable/flowable-engine/issues/2354，找到类似的问题提问，后升级了一下flowable的版本到6.6.0，之前是6.5.0，然后又加大了maximum-pool-size到30，之前是20，后，问题解决，没有在报上面提到的异常