The last packet successfully received from the server was 596,688 milliseconds a

最新推荐文章于 2025-09-15 12:02:24 发布
原创 最新推荐文章于 2025-09-15 12:02:24 发布 · 113 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍如何调整MySQL的wait_timeout和interactive_timeout参数以提高数据库性能，包括参数含义、默认值、影响范围及调整策略。

[mysqld]

wait_timeout=31536000

interactive_timeout=31536000

重启生效，需要同时修改这两个参数。

staffrobot
关注
The last packet successfully received from the server was 4,758 milliseconds ago
隔壁老瓦的专栏
10-12 2263
Thelastpacketsuccessfullyreceivedfromtheserverwas4,758millisecondsago.Thelastpacketsentsuccessfullytotheserverwas4,758millisecon dsago.;nestedexceptioniscom.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communicationslin...
kettle问题：The last packet successfully received from the server was 156 milliseconds ago.
Letitia1208的博客
04-23 3157
在使用kettle时遇到MySQL数据库连接问题： 1.Navicat可以连接到目标MySQL库，说明不是数据库权限的问题。 2.用kettle可以连接其他同版本MySQL库，说明也不是jar包的问题。 最终，尝试过重启电脑，删除kettle文件重装，替换jar包等各种办法之后，才发现问题在.kettle文件夹里面： 这是出问题时.kettle文件夹下面的文件，比正常文件多了一些东西。 个人的解决办法： 1.备份 kettle.properties 文件，这是平时用的连接资源库的信息 2.删除.kett
mysql the last_mysql The last packet successfully received from t
weixin_34483980的博客
02-01 617
mysql服务器最近老是报错，内容如下：The last packet successfully received from the server was 65,502,275 milliseconds ago. The last packet sent successfully to the server was 65,502,276 milliseconds ago. is longer t...
数据库连接超时：“The last packet successfully received from the server was xxx milliseconds ago”...
weixin_30770783的博客
01-21 1万+
产生的原因：应用方的数据库连接有效期时间，大于数据库自己设置的有效期。 解决方案： 一、修改druid配置（如果使用druid的话） spring.datasource.druid.validationQuery=select 1 spring.datasource.druid.testWhileIdle=true spring.datasource.druid.te...
mysql链接错误The last packet successfully received from the server was xxx milliseconds ago解决方案
热门推荐
weixin_44487203的博客
03-17 2万+
线上项目偶尔出现错误，这个错误发现是在项目无人操作一段时间后就产生，如果有人操作，那就不会出现。
mysql重连，连接丢失：The last packet successfully received
qq_31528289的博客
07-07 520
- 如果是在Spring中使用DBCP连接池，在定义datasource增加属性validationQuery和testOnBorrow，如 id="vrsRankDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> name="driverClassName"
doris Communications link failureThe last packet successfully received from the server was 10057
最新发布
u011250186的博客
09-15 395
doris jdbc连接错误。
The last packet successfully received from the server was 59,866 milliseconds ago. The last packet
mt23
09-11 1341
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 59,866 milliseconds ago. The last packet sent successfully ...
JDBC运行报错The last package successfully received from the sever was 0 milliseconds ago. The last ...
qq_41523340的博客
11-27 2377
JDBC运行报错服务器没有响应JDBC运行后，服务器没有响应报错更新mysql-connector-java的版本 JDBC运行后，服务器没有响应报错 The last packet successfully received from the server was 462 milliseconds ago. The last packet sent successfully to the server was 453 milliseconds ago. at sun.reflect.NativeCon
MySql重连，连接丢失：The last packet successfully received
杨浩瑞的博客
06-08 687
1.1 错误信息：Causedby:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Thelastpacketsuccessfullyreceivedfromtheserverwas20,820,001millisecondsago.Thelastpacketsentsucc...
The last packet successfully received from the server
hejian708837的专栏
12-27 1204
The last packet successfully received from the server 如果是在Spring中使用DBCP连接池，在定义datasource增加属性validationQuery和testOnBorrow <bean id="vrsRankDataSource" class="org.apache.commons.dbcp.BasicDataSourc...
The last packet successfully received from the server was 1,547,682,071 milliseconds ago. The last
datouniao1的博客
09-13 844
MySQL 经常出现这样的错误： org.springframework.dao.DataAccessResourceFailureException: PreparedStatementCallback; SQL [select * from mytable where clom=?]; The last packet successfully received from the server was 1,547,682,071 milliseconds ago. The last packe...
The last packet successfully received from the server was 78,682,686 milliseconds ago
oqqhot12的专栏
04-09 3760
The last packet successfully received from the server was 78,682,686 milliseconds ago.  The last packet sent successfully to the server was 78,682,686 milliseconds ago. is longer than the server confi
The last packet successfully received from the server was 0 millis
qq_42521108的博客
04-10 1390
备注：本人遇到并处理的方式。
mysql重连，连接丢失：The last packet successfully received from the server
qq_39951411的博客
07-16 7569
问题原因：其实上面的提示中已经给出了一部分的简要说明，简单来说就是： 程序启动时，在跟DB首次交互时，获得了相应的DB Connection资源，从而进行正常的DB读写操作。但是在下次进行DB读写时（我的定时任务本身设置的时间间隔是24小时），应用程序认为这个连接是可以正常使用的（程序执行过一次之后没有退出，这个连接从来并没有被释放掉），但实际上，这个连接已经坏掉了，因为Mysql本身已经把这...
The last packet successfully received from the server was 5,627,630 milliseconds ago.
Eric_ChenXiao的博客
10-31 1763
客户端连接池中的连接与MySQL server端连接池的连接是一一对应的，超出wait_timeout配置的时间未连接过，则服务端将对应的连接销毁，这时候客户端是不知道的。客户端应用的连接池中的连接最后一次收到MySQL server的相应是xxx毫秒之前；超过生命时长的，空闲的直接驱逐，非空闲的标记，下次获取时驱逐。服务端到期销毁连接之前，客户端就先销毁对应的连接,也就是客户端销毁连接的时间要小于wait_timeout配置的时间。下次客户端再去进行连接的时候，就会出现上面的错误。
The last packet successfully received from the server was 290 milliseconds a
08-12
报错信息"The last packet successfully received from the server was 290 milliseconds a"通常是由于与MySQL服务器的连接超时引起的。根据引用和引用的建议，您可以尝试修改MySQL的配置，将"useSSL"参数的值改为false，即"useSSL=false"。此外，您还可以在spring数据源配置中增加"connectTimeout"参数，并将其值适当增大。这样可以增加与MySQL服务器建立连接的超时时间，以确保成功接收到服务器的最后一个数据包。您可以参考引用中的示例配置来进行修改。修改完成后，重新启动Java项目，应该能够解决该报错。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [The last packet successfully received from the server was xxx milliseconds ago. The last packet sen](https://blog.youkuaiyun.com/qq_42701659/article/details/131012082)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"] - *2* *3* [解决 ‘The last packet successfully received from the server was xxx milliseconds ago‘ 问题](https://blog.youkuaiyun.com/tiantang_1986/article/details/130689791)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT0_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值