mysql连接池报错:The last packet successfully received from the server was XXXXX milliseconds ago

喜欢ヅ旅行 2022-12-27 11:25 325阅读 0赞

## 具体报错信息 ##

> 0:Communications link failure The last packet successfully received  
> from the server was 87,537,289 milliseconds ago. The last packet sent  
> successfully to the

## 报错日志解释 ##

从服务器成功接收的最后一个数据包是87,537,289（24.3小时）毫秒前。最后一个成功发送到服务器的数据包是0毫秒前。说明这个连接已经24个小时没有从服务器上接收数据了，而mysql上定义，如果一个连接的空闲时间超过24个小时，MySQL将自动断开该连接，而连接池却认为该连接还是有效的(因为并未校验连接的有效性)，当应用申请使用该连接时，就会导致上面的报错。而我们的数据库的配置参数wait\_timeout的值，show variables like ‘wait\_timeout’= 86400 ，正好是24个小时。

## 现有配置 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1eGlhb2xvbmdhaA_size_16_color_FFFFFF_t_70]

## 现有配置的问题 ##

现有项目连接池配置中未配置testWhileIdle，则默认为false; 只有设置为true，连接池才会运行清理无效连接的线程；  
目前现有的配置中testWhileIdle=false，所以不会清理连接池中认为有效，但mysql认为无效的连接；当有新的请求过来，连接池把mysl认为无效的连接分配出去，请求到达mysql就会出现上述问题。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1eGlhb2xvbmdhaA_size_16_color_FFFFFF_t_70 1]  
**参考tomcat的连接池配置**：https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html

## 连接池相关参数配置建议 ##

参考：阿里云druid配置参考：https://github.com/alibaba/druid/wiki/DruidDataSource%E9%85%8D%E7%BD%AE

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1eGlhb2xvbmdhaA_size_16_color_FFFFFF_t_70]: /images/20221120/5d0701bb7734464fa35e4316dc3bbd57.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1eGlhb2xvbmdhaA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20201210195557290.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3d1eGlhb2xvbmdhaA==,size_16,color_FFFFFF,t_70

mysql连接池报错:The last packet successfully received from the server was XXXXX milliseconds ago

发表评论取消回复

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

相关阅读

相关 The last packet successfully received from the server was XXX milliseconds ago 问题排查

相关 mysql连接池报错:The last packet successfully received from the server was XXXXX milliseconds ago

相关 The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received

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

相关 The last packet sent successfully to the server was 0 milliseconds ago问题的解决

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

相关 The last packet sent successfully to the server was 0 milliseconds ago.

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

相关连接数据库报错：The last packet successfully received from the server was 67 milliseconds ago.

相关数据库连接异常：The last packet sent successfully to the server was 0 milliseconds ago