HikariPool-XXX - Connection is not available, request timed out after 30680s

黄黄黄黄黄莹

已于 2022-05-06 16:23:54 修改

阅读量1.1k

点赞数

分类专栏： IDEA 文章标签： intellij idea java

于 2021-11-14 12:20:00 首次发布

本文链接：https://blog.csdn.net/weixin_42311968/article/details/121316011

版权

IDEA 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

博客内容描述了在使用Spring Boot和Hibernate时遇到的数据库连接超时异常。异常信息显示为JDBCConnectionException，提示HikariPool无法在指定时间内获取连接。解决方案是增大Hikari数据源的最大生存时间(max-lifetime)配置。

摘要由CSDN通过智能技术生成

首先应该想到的是超时的处理，将max-lifetime改大一点即可

spring:
     datasource:
       hikari:
           max-lifetime: 60000

报这种错误，大致如下所示：

org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:277) 
~[spring-orm-5.2.9.RELEASE.jar!/:5.2.9.RELEASE] at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) 
~[spring-orm-5.2.9.RELEASE.jar!/:5.2.9.RELEASE] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:528) 
~[spring-orm-5.2.9.RELEASE.jar!/:5.2.9.RELEASE] ... 
Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48) ~[hibernate-core-5.4.21.Final.jar!/:5.4.21.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) 
~[hibernate-core-5.4.21.Final.jar!/:5.4.21.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) 
~[hibernate-core-5.4.21.Final.jar!/:5.4.21.Final] ... Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695) 
~[HikariCP-3.4.5.jar!/:?] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197) 
~[HikariCP-3.4.5.jar!/:?] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162) 
~[HikariCP-3.4.5.jar!/:?] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) 
~[HikariCP-3.4.5.jar!/:?] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) 
~[hibernate-core-5.4.21.Final.jar!/:5.4.21.Final] ...