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

最新推荐文章于 2024-03-22 10:17:37 发布
原创 最新推荐文章于 2024-03-22 10:17:37 发布 · 2.5k 阅读 · 5 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#项目报错 #The last packet sent successfu

本文记录了在SSM项目中遇到的数据库连接池错误，包括详细的错误日志及原因分析，并提供了两种解决方法，一是检查数据库连接是否正常，二是更改数据库配置文件中的地址。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

我在学习ssm项目的时候遇到了一个问题，大致就是说我数据库连接池有问题什么的，具体报错如下：

2018-02-28 12:03:00,328 [main] [org.mybatis.spring.SqlSessionUtils]-[DEBUG] Creating a new SqlSession
2018-02-28 12:03:00,338 [main] [org.mybatis.spring.SqlSessionUtils]-[DEBUG] SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7f284218] was not registered for synchronization because synchronization is not active
2018-02-28 12:03:00,398 [main] [org.springframework.jdbc.datasource.DataSourceUtils]-[DEBUG] Fetching JDBC Connection from DataSource
2018-02-28 12:03:00,498 [main] [com.alibaba.druid.pool.DruidDataSource]-[INFO] {dataSource-1} inited
2018-02-28 12:03:21,648 [Druid-ConnectionPool-Create-807328355] [com.alibaba.druid.pool.DruidDataSource]-[ERROR] create connection error
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:355)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2490)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2527)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2309)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:419)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at java.net.Socket.connect(Socket.java:538)
	at java.net.Socket.<init>(Socket.java:434)
	at java.net.Socket.<init>(Socket.java:244)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:305)
	... 15 more
2018-02-28 12:03:42,666 [Druid-ConnectionPool-Create-807328355] [com.alibaba.druid.pool.DruidDataSource]-[ERROR] create connection error
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:355)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2490)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2527)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2309)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:419)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at java.net.Socket.connect(Socket.java:538)
	at java.net.Socket.<init>(Socket.java:434)
	at java.net.Socket.<init>(Socket.java:244)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:305)
	... 15 more
2018-02-28 12:04:03,686 [Druid-ConnectionPool-Create-807328355] [com.alibaba.druid.pool.DruidDataSource]-[ERROR] create connection error
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1137)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:355)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2490)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2527)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2309)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:419)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:344)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1375)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1431)
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1844)
Caused by: java.net.ConnectException: Connection timed out: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
	at java.net.Socket.connect(Socket.java:589)
	at java.net.Socket.connect(Socket.java:538)
	at java.net.Socket.<init>(Socket.java:434)
	at java.net.Socket.<init>(Socket.java:244)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:258)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:305)
	... 15 more

Process finished with exit code 1

方法一：

点击打开链接这个方法是根据“The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.”所报错误查询到的。

方法二：

打开数据库配置文件“db.properties”

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://192.168.25.134:3306/taotao?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456

修改为：

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/taotao?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456
重新运行项目即可，我被这个问题搞得一夜没睡好觉，希望能解决大家问题。
IDEA连接Mysql数据库报错：“The last packet sent successfully to the server was 0 milliseconds ago.”
weixin_59744818的博客
11-26 1万+
今天IDEA使用druid连接Mysql数据库报错，MySQL版本5.7.34，druid-spring-boot-starter版本1.1.13。更新druid版本到最新1.2.6也没用。 “The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.” “No appropriate protocol (p
解决MySQL报错：“The last packet sent successfully to the server was 0 milliseconds ago.”
培根芝士的专栏
09-07 3万+
方法就是将mysql回收空闲连接的时间变长，mysql默认回收时间是8小时，可以在mysql目录下的my.cnf中增加下面配置，将时间改为1天。之所以出现异常，是由于数据库回收了连接，而系统的缓冲池不知道，继续使用被回收的连接所致的。wait_timeout=86400 //加上这一句。
mysql数据库连接报错The last packet sent successfully to the server was 0 milliseconds ago. The drive
flyf000的博客
08-16 1万+
mysql数据库连接报错The last packet sent successfully to the server was 0 milliseconds ago. The drive
The last packet sent successfully to the server was 0 milliseconds ago.问题分析
qq_42865087的博客
06-30 2万+
mysql问题
测试链接报错 The last packet sent successfully to the server was 0 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
04-09
当遇到 `Communications link failure` 错误以及提示 `The last packet sent successfully to the server was 0 milliseconds ago.` 的情况，通常表明客户端无法成功建立与 MySQL 服务器的通信连接。以下是可能的...
Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
最新发布
07-31
> The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 说明客户端在尝试与数据库建立连接时，未能从服务器接收到任何响应数据包...
若依框架The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
02-12
当遇到错误提示 `The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.`，这通常意味着客户端无法成功建立到MySQL服务器的连接。...
mysql异常The last packet sent successfully to the server was 0 milliseconds ago. The driver has not re
love_live2的博客
03-22 1837
网上查了很多原因，最终发现应该是mysql远程连接未开启，但是运维同学查看权限配置是ok的。最近公司测试环境mysql数据库由5升级到了8，测试环境程序就连接报错了。这里说明权限是放开的无需修改，然后我们执行了一下刷新命令就解决了。如果权限没有放开则先要执行赋权的命令再刷新。
异常报错：The last packet sent successfully to the server was 0 milliseconds ago
tzzt01的博客
07-25 813
在网上找了一圈，没有找到合适的解决方案。最后猜测问题有可能出在MySQL上，想起前几天改过MySQL的 my.ini 文件，于是改回来，重启项目就OK了。
已解决The last packet sent successfully to the server was 0 milliseconds ago. The driver has not receiv
热门推荐
Huang405267467的博客
07-07 4万+
注：此文章是在mysql8版本的前提下编写的。在我们使用springcloud在连接mysql数据库时，有时会碰到如下这种异常： 为此我上网查了不少资料，在这里小总结一下：1. 连接url是否正确（自己看看useSSL是否为false）：2.数据库服务是否打开：找到MySql服务：3.网上最多解决的等待时间问题：（wait_timeout)我使用的mysql版本为 8.0.27 ，在用网上的修改my.ini配置文件时 mysql会直接报错，启动不了，即使临时修改wait_timeout时间，也是一样会报
the last packet sent successful to the server was 0 milliseconds ago
09-06
"The last packet sent successfully to the server was 0 milliseconds ago"是一个异常错误信息，它通常是由于数据库回收了连接，而系统的缓冲池不知道，继续使用被回收的连接导致的。 解决这个问题有两种方法。第一种方法是将数据库回收空闲连接的时间变长，比如将mysql的回收时间改为1天。可以通过在mysql目录下的my.ini文件中增加配置来实现，将wait_timeout参数设置为86400秒，即1天。 第二种方法是通过配置让缓冲池去测试连接是否被回收。以dbcp连接池为例，可以设置以下参数来实现： - 配置一个SQL查询语句，用来验证从连接池取出的连接是否有效：dbcp.validationQuery=SELECT 1 - 设置连接池在空闲连接回收器线程运行期间休眠的时间值，一般比minEvictableIdleTimeMillis小：dbcp.timeBetweenEvictionRunsMillis=300000 - 设置每次空闲连接回收器线程运行时检查的连接数量，最好和maxActive一致：dbcp.numTestsPerEvictionRun=50 - 设置连接池中连接在时间段内一直空闲，被逐出连接池的时间：dbcp.minEvictableIdleTimeMillis=3600000 另外，有些情况下重启计算机也可以解决这个问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* [以及 遇到的坑“The last packet sent successfully to the server was 0 m](https://download.csdn.net/download/weixin_38631729/14017081)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* *3* [The last packet sent successfully to the server was 0 milliseconds ago.](https://blog.csdn.net/weixin_43069201/article/details/86636380)[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^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值