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

旧城等待， 2024-04-08 09:51 56阅读 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