MySQL报错 Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl

我有一只肥螳螂

已于 2022-10-14 15:29:34 修改

阅读量7.3k

点赞数

于 2022-08-18 16:34:29 首次发布

本文链接：https://blog.csdn.net/weixin_42555971/article/details/126408218

版权

JAVA 同时被 2 个专栏收录

72 篇文章 1 订阅

订阅专栏

MySQL

14 篇文章 0 订阅

订阅专栏

报错：springboot 项目向 MySQL 请求SqlSession时报错

Creating a new SqlSession
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@68f96343] was not registered for synchronization because synchronization is not active
2022-08-18 15:49:12.310 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@61dbd14f (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.312 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3b924218 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.313 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@47cbd8c (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.313 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@3018e7ae (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.314 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@71bf7c2 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.315 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@2e30e7bb (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.316 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@4fc1af2c (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.317 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@381314ed (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.317 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@60ee41ca (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
2022-08-18 15:49:12.318 WARN  [TID: N/A] com.zaxxer.hikari.pool.PoolBase -HikariPool-1 - Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@494a6f53 (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
JDBC Connection [HikariProxyConnection@723835006 wrapping com.mysql.cj.jdbc.ConnectionImpl@39562cc1] will not be managed by Spring

原因：连接池的线程已死

解决方案：application.yml 添加 max-lifetime 配置

spring:
  datasource:
    url: "jdbc:mysql://ip:3306/database?useUnicode=true&characterEncoding=UTF8&autoReconnect=true&zeroDateTimeBehavior=convertToNull&serverTimezone=Asia/Shanghai"
    username: "root"
    password: "xxx*k"
    driver-class-name: "com.mysql.cj.jdbc.Driver"
    hikari:
      max-lifetime: 500000