The last packet successfully received from the server was 43200 milliseconds ago.
... longer than the server configured value of 'wait_timeout'.
Connection.close() has already been called. Invalid operation in this state.
MySQL wait_timeout(預設 28800 秒 = 8 小時)控制閒置連線最大存活時間。連線池借出的連線若閒置超過此值,Server 主動斷開;應用端再次使用時未檢測連線有效性,拋出異常。
| 方案 | 優點 | 缺點 | 推薦度 |
|---|---|---|---|
| 增大 wait_timeout(如 1 年) | 簡單 | 治標不治本,資源浪費,仍有斷開風險 | ★ |
| 連線池借用前測試 | 治本,自動重連,資源可控 | 微小效能開銷 | ★★★★★ |
| 定期心跳/驗證查詢 | 主動保持連線存活 | 需額外排程,增加複雜度 | ★★★ |
| JDBC url 加 autoReconnect=true | 零代碼變更 | 官方不推薦,可能掩蓋問題,事務安全性差 | ★★ |
spring.datasource.hikari.connection-test-query=SELECT 1
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.maximum-pool-size=20
spring.datasource.hikari.idle-timeout=300000 # 5 分鐘
spring.datasource.hikari.max-lifetime=1800000 # 30 分鐘
spring.datasource.hikari.connection-timeout=30000 # 30 秒獲取超時
spring.datasource.druid.validation-query=SELECT 1
spring.datasource.druid.test-on-borrow=true
spring.datasource.druid.test-on-return=false
spring.datasource.druid.test-while-idle=true
spring.datasource.druid.time-between-eviction-runs-millis=60000
spring.datasource.druid.min-evictable-idle-time-millis=300000
hibernate.c3p0.testConnectionOnCheckout=true
hibernate.c3p0.preferredTestQuery=SELECT 1
hibernate.c3p0.idle_test_period=300
hibernate.c3p0.maxIdleTime=1800
SELECT 1 執行頻率。ActiveConnections, IdleConnections, PendingThreads。wait_timeout 後繼續請求,確認無異常。