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

Love The Way You Lie 2022-03-12 19:58 323阅读 0赞

> ### 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 510,815 milliseconds ago.  The last packet sent successfully to the server was 0 milliseconds ago.

**【详细说明】： **

**具体解释是这样的：Mysql服务器默认的“wait\_timeout”是8小时【也就是默认的值默认是28800秒】，也就是说一个connection空闲超过8个小时，Mysql将自动断开该connection，通俗的讲就是一个连接在8小时内没有活动，就会自动断开该连接。而应用连接池却认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。**  
**【MySQL中my.ini配置】：**

**wait timeout的值可以设定，但最多只能是2147483，不能再大了。也就是约24.85天  
所以即使你MySQL通过my.ini 在  
\# The TCP/IP Port the MySQL Server will listen on  
port=3306下面添加  
\# this is myown dinifition for mysql connection timeout  
wait\_timeout=31536000  
interactive\_timeout=31536000  
无论超过最大限度多大的数值，只能被MySQL解析为2147483**  
**【解决方案】：**

**1、按照错误的提示，可以在JDBC URL中使用autoReconnect属性，实际测试时使用了autoReconnect=true&failOverReadOnly=false，不过并未起作用，使用的是5.1版本，可能真像网上所说的只对4之前的版本有效。**

**2、增大mysql的wait\_timeout属性值；(起不到实质性作用)**

**show variables like '%timeout';**

**3、最好的解决方法，如果使用了c3p0连接池，可以配置idleConnectionTestPeriod 属性，每多少秒检查所有连接池中的空闲连接，把该值设置的小于mysql的wait\_timeout值即可。**

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 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 179 milliseconds ago.

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

相关 The last packet successfully received from the server was 8,268,658 milliseconds ago

相关 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..