MySQL master server goes down, automatic failover occurs two old connections remain and cannot be decommissioned. - Githubissues

brettwooldridge / HikariCP

光 HikariCP・A solid, high-performance, JDBC connection pool at last.

Apache License 2.0

19.91k stars 2.92k forks source link

MySQL master server goes down, automatic failover occurs two old connections remain and cannot be decommissioned. #2120

Open Stainlesswang opened 12 months ago

Stainlesswang commented 12 months ago

desc

version: 3.4.5

config:

minIdle=2
maxPoolSize=25
connectionTimeout=5000
maxLifeTime=60000
idleTimeout=10000

jdbcUrl:

mysql://m1234.XXX.com.cn:1234?useUnicode=true&characterEncoding=UTF-8&rewriteBatchedStatements=true&cachePrepStmts=true&autoReconnect=true&useSSL=false

Java dump

HikariPool.connectionBag.sharedList

quetion

The MySQL domain has already been switched to the IP of the new node, but the reason for not being able to re-establish connections, as shown in the image, is that the two connections in the connection bag are still present but not usable.