Communications link failure The last packet successfully received from the server was 2,687,887 mi

女爷i 2021-12-03 03:59 277阅读 0赞

使用场景：

1.tomcat jdbc连接池

2.mysql数据库

3.隔一段时间后就会出现

Communications link failureThe last packet successfully received from the server was **2,687,887 milliseconds** ago之类的错误提示，出现这个问题的原因是使用了无效数据库连接

spring.datasource.mysql.max-idle=10  
spring.datasource.mysql.max-wait=10000  
spring.datasource.mysql.min-idle=5  
spring.datasource.mysql.initial-size=5

下面是mysql服务器配置

![20190719190332409.png][]

重点看wait\_timeout这个参数跟**2,687,887** 这个打印信息，出现这个报错信息的原因在于操作mysql数据库时使用了一个无效连接，这个连接为什么无效呢？原因就在于**2,687,887** 这个时间是该连接上次操作mysql数据库的时间，由于这个时间超过2592000这个时间，mysql服务端会自动关闭这个连接，但是连接池没有把这个连接废除导致！

解决方法：

数据库连接增加下面配置

spring.datasource.mysql.validation-query=SELECT 1  
spring.datasource.mysql.test-on-borrow=false  
spring.datasource.mysql.test-while-idle=true  
spring.datasource.mysql.time-between-eviction-runs-millis=30000

time-between-eviction-runs-millis这个参数一定要小于wait\_timeout这个值，否则还有可能报上面的错！

test-on-borrow这个则可以完全避免上面的问题，但是效率没有使用test-while-idle高！

**PS:**

wait\_timeout是针对jdbc客户端的超时设置，而interactive\_timeout则是针对打开的mysql客户端，比如cmd等，但不包括navicat，navicat丢失连接后会自动重连的！！！

[20190719190332409.png]: /images/20211203/926d2fe5dbd54fa0b57f4baf043918b2.png

Communications link failure The last packet successfully received from the server was 2,687,887 mi

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Communications link failure The last packet successfully received from the server was 20 millisecon

相关 The last packet successfully received from the server was xxx milliseconds ago. The last packet sen

相关 Communications link failure The last packet sent successfully to the server

相关 Java Communications link failure.The last packet successfully received from the server was问题解决

相关 The last packet successfully received from the server was 1,547,682,071 milliseconds ago. The last

相关【异常】The last packet successfully received from the server was 179 milliseconds ago.

相关 Communications link failure The last packet successfully received from the server was 29,623,329 m

相关 Communications link failure，The last packet successfully received from the server was × millisecon..

相关 Communications link failure The last packet successfully received from the server was 2,687,887 mi

相关 Communications link failure，The last packet successfully received from the server was × millisecon..