记一次由于Druid连接池版本问题导致的系统崩溃

最新推荐文章于 2024-07-22 20:24:57 发布

Utopia丶程

最新推荐文章于 2024-07-22 20:24:57 发布

阅读量3k

点赞数

分类专栏： druid jdbc 文章标签： mysql jdbc 数据库

本文链接：https://blog.csdn.net/qq_36198235/article/details/109486708

版权

本文记录了一次由于Druid连接池版本过低导致的系统崩溃问题。错误表现为`关闭的连接`，经过排查确定是Druid在旧版本中存在线程中断后连接无法正常回收的Bug。通过升级Druid到最新版本，解决了这个问题。建议定期检查并更新依赖库以避免类似问题。

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

报错信息如下：

ERROR [com.alibaba.druid.pool.DruidDataSource] - recyle error
java.sql.SQLRecoverableException: 关闭的连接
   at oracle.jdbc.driver.PhysicalConnection.setAutoCommit(PhysicalConnection.java:2232)
   at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:553)
   at com.alibaba.druid.filter.FilterAdapter.connection_setAutoCommit(FilterAdapter.java:984)
   at com.alibaba.druid.filter.FilterChainImpl.connection_setAutoCommit(FilterChainImpl.java:549)
   at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.setAutoCommit(ConnectionProxyImpl.java:430)
   at com.alibaba.druid.pool.DruidConnectionHolder.reset(DruidConnectionHolder.java:246)
   at com.alibaba.druid.pool.DruidDataSource.recycle(DruidDataSource.java:1301)
   at com.alibaba.druid.pool.DruidPooledConnection.recycle(DruidPooledConnection.java:305)
   at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:4534)
   at com.alibaba.druid.filter.stat.StatFilter.dataSource_releaseConnection(StatFilter.java:647)
   at com.alibaba.druid.filter.FilterChainImpl.dataSource_recycle(FilterChainImpl.java:4530)
   at com.alibaba.druid.pool.DruidPooledConnection.close(DruidPooledConnection.java:253)
   at org.springframework.jdbc.datasource.DataSourceUtils.doCloseConnection(DataSourceUtils.java:341)
   at org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:328)
   at org.springframework.jdbc.datasource.DataSourceUtils.releaseConnection(DataSourceUtils.java:294)
   at org.springframework.jdbc.datasource.DataSourceTransactionManager.doCleanupAfterCompletion(DataSourceTransactionManager.java:329)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.cl