Communications link failure The last packet successfully received from the server was millisec

最新推荐文章于 2024-03-26 05:39:28 发布
最新推荐文章于 2024-03-26 05:39:28 发布
阅读量3.4k 收藏 1
点赞数 1
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_33286695/article/details/103489375
版权

使用JDBC连接Mysql数据库棘手错误

错误情况

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 8,451 milliseconds ago.  The last packet sent successfully to the server was 8,451 milliseconds ago.
	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:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3559)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3459)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3900)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:873)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1710)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1226)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at jdbc.JDBCHelper.<init>(JDBCHelper.java:109)
	at jdbc.JDBCHelper.getInstance(JDBCHelper.java:64)
	at mapper.originalDao.insertBatch(originalDao.scala:39)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:103)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:80)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
	at org.apache.spark.scheduler.Task.run(Task.scala:109)
	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:345)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Software caused connection abort: recv failed
	at java.net.SocketInputStream.socketRead0(Native Method)
	at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
	at java.net.SocketInputStream.read(SocketInputStream.java:171)
	at java.net.SocketInputStream.read(SocketInputStream.java:141)
	at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:101)
	at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:144)
	at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:174)
	at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3008)
	at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3469)
	... 34 more
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:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at jdbc.JDBCHelper.<init>(JDBCHelper.java:109)
	at jdbc.JDBCHelper.getInstance(JDBCHelper.java:64)
	at mapper.originalDao.insertBatch(originalDao.scala:39)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:103)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:80)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
	at org.apache.spark.scheduler.Task.run(Task.scala:109)
	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:345)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Network is unreachable: 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 com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
	... 29 more
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:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at jdbc.JDBCHelper.<init>(JDBCHelper.java:109)
	at jdbc.JDBCHelper.getInstance(JDBCHelper.java:64)
	at mapper.originalDao.insertBatch(originalDao.scala:39)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:103)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:80)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
	at org.apache.spark.scheduler.Task.run(Task.scala:109)
	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:345)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Software caused connection abort: 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 com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
	... 29 more
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:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2186)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2219)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2014)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	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:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at jdbc.JDBCHelper.<init>(JDBCHelper.java:109)
	at jdbc.JDBCHelper.getInstance(JDBCHelper.java:64)
	at mapper.originalDao.insertBatch(originalDao.scala:39)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:103)
	at controller.KafkaConsumeFlume$$anonfun$main$1$$anonfun$apply$1.apply(KafkaConsumeFlume.scala:80)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.rdd.RDD$$anonfun$foreachPartition$1$$anonfun$apply$29.apply(RDD.scala:935)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.SparkContext$$anonfun$runJob$5.apply(SparkContext.scala:2074)
	at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:87)
	at org.apache.spark.scheduler.Task.run(Task.scala:109)
	at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:345)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.SocketException: Network is unreachable: 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 com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
	... 29 more

解决方案

1、配置jdbcURL上加上了 ?autoReconnect=true&amp;failOverReadOnly=false
	只针对MySQL版本在4.X版本
2、配置在mysql的my.ini里面加上这两个参数：
	wait_timeout=2147483 
	interactive_timeout=2147483 
3、把jdbcURl的ip地址链接，改成localhost，这个解决方案映射了最后一个解决方案代理问题
4、如果以前好好的突然出现了这个问题，代理问题的可能性很大，看看下面链接的第三条，希望对你有帮助
	https://yq.aliyun.com/articles/614447
5、网络不稳定问题，导致JDBC在连接数据库时不稳定出现异常。可以尝试关闭浏览器或者耗网络应用试一试。
6、参考大神的连接：
	https://blog.csdn.net/qq_27471405/article/details/80921846
binbincoder
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
## @[Android studio通过jdbc连接mysql基本步骤 以及 遇到的坑“The last packet sent successfully to the server was 0 m
01-03
@[Android studio通过jdbc连接mysql基本步骤 以及 遇到的坑“The last packet sent successfully to the server was 0 milliseconds ago”哈哈] 小白第一次发博客哈哈，记录一下这三个晚上来我的悲惨经历以及我成功解决bug后的极度开心。 第一个晚上，有点小烦躁，但感觉还可以，有点小bug明天解决吧。 第二个晚上，不急，就一个小bug，20分钟调好吧。。。。。直到半夜1点，我开始锤墙，太难了！垃圾电脑垃圾软件！真想抽根烟，可惜我不会。三点钟，锤墙！不能锤电脑！关机睡觉，我就是笨我就是不会咋地。 第三个晚上，我就
get_tcp_code.rar_The Capture_get_packet_code
09-24
用libpcap 库实现的tcp抓包程序,应该是刚刚学习linux环境网络编程的好材料Achieved with the tcp packet capture library libpcap program is just learning linux network programming environment, a good material
Communications link failureThe last packet successfully received from the server was 100 milliseco
最新发布
即将毕业的大学生
03-26 446
Communications link failureThe last packet successfully received from the server was 100 milliseco
ACL.rar_Cisco Packet Tracer_The Handle
09-22
this code contain the procedure to handle access controll List in Cisco packet tracer
Packet-Capture.rar_Packet_The Network
09-20
This is the programme to capture network traffic packet.
Communications link failure 原因：The last packet successfully received from the server was
诸葛小猿
02-04 3万+
最近线上日志报错： 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 server was 0 millis...
Communications link failure:The last packet successfully received from the server was 0 millisecond
LookingTomorrow的博客
12-03 8520
出现这种错误的大致情况如下： 1、数据库连接长时间未使用，断开连接后，再去连接出现这种情况。这种情况常见于用连接池连接数据库出现的问题 2、数据库连接的后缀参数问题 针对上述两种情况，解决方案如下 1、修改MySQL的参数,my.cnf位于/etc目录下，修改完成后，重启mysql wait_timeout最大为31536000即1年，在my.cnf中加入： [mysqld] wait_timeout=31536000 interactive_timeout=31536000 2、连接数
Communications link failure The last packet sent successfully to the server was 0 milliseconds ago
热门推荐
weixin_45936094的博客
05-24 3万+
最近用idea写了一个程序，中间把mysql从5.7升级到了8.0.原来程序正常，升级之后报错！ idea程序连接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. 首先检查一下url连接串是不是有错误，我这里之前程序可以
解决数据库超时问题
北京平安力合科技发展有限公司产品技术官博
07-29 1127
最近做测试，发现Mysql 过一段时间会无法连接，导致数据库数据不一至，极其郁闷。下面是转一哥门的使用Connector/J连接MySQL数据库，程序运行较长时间后就会报以下错误：Communications link failure，The last packet succes
【Mysql】Communications link failure，The last packet sent successfully to the server was 0 millisecond
A-Itfuture的博客
12-03 2万+
解决错误【Mysql】Communications link failure，The last packet sent successfully to the server was 0 millisecond
Communications link failure，The last packet successfully received from the server was *** millisecon
阿里旺仔。
06-01 2万+
最近做测试，发现Mysql 过一段时间会无法连接，导致数据库数据不一至，极其郁闷。 下面是转一哥门的     使用Connector/J连接MySQL数据库，程序运行较长时间后就会报以下错误： Communications link failure，The last packet successfully received from the server was *** millisec
packet_mmap.rar_The Driver_conexant
09-14
Driver for the Conexant CX23885 7 8 PCIe bridge.
Communications link failure，The last packet successfully received from the serve
xiaomin1991222的专栏
08-29 1249
  关于MySQL连接超时问题，估计很多人都遇到过：大致情形都是这样，开发测试时程序都是正常的，一到第二天就出先莫名错误，比如在我的项目中使用了多数据源，其中有一个数据源仅仅供查询使用，所以使用次数很少。当出现了超时错误，一般错误日志如下：Communications link failure The last packet successfully received from the ser...
MySQL数据库提示：Communications link failure，The last packet succe
Aeroleo的博客
10-22 2658
web网站使用MySQL数据库，今天突然报以下错误：       Communications link failure，The last packet successfully received from the server was *** millisecond ago.The last packet successfully sent to the server was *** 
Communications link failure The last packet successfully received from the server was 2,687,887 mi
johnhuster的专栏
07-19 2774
使用场景： 1.tomcat jdbc连接池 2.mysql数据库 3.隔一段时间后就会出现 Communications link failureThe last packet successfully received from the server was 2,687,887 milliseconds ago之类的错误提示，出现这个问题的原因是使用了无效数据库连接 spring....
关于使用mysql数据，系统检测到Communications link failure的报错提示
biqinyun8506的博客
01-28 2127
关于使用mysql数据，系统检测到Communications link failure的报错提示： 使用Connector/J连接MySQL数据库，程序运行较长时间后就会报以下错误： Communications link failure，The last packet successfully received from the server was *** millisecond ago.The last packet successfully sent to the server was ***
Java Communications link failure.The last packet successfully received from the server was问题解决
旭东怪的博客
09-24 8370
问题描述： com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure 问题分析： 1、数据库已关闭当前连接，导致报错。
mysql 异常连接_解决mysql连接异常
weixin_36087905的博客
02-27 846
出现异常”The last packet sent successfully to the server was 0 milliseconds ago.“的大部分原因是由于数据库回收了连接，而系统的缓冲池不知道，继续使用被回收的连接所致的。以mysql为例：第一种解决办法，就是将mysql回收空闲连接的时间变长，mysql默认回收时间是8小时，可以在mysql目录下的my.ini中增加下面配置，将...
解决com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure, The last packe.
抓饭不吃皮牙子
11-03 1万+
希望这篇文章能帮助你解决"com.mysql.cj.jdbc.exceptions.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."的错误，顺利连接到MySQL服务器。
Communications link failure The last packet successfully received from the server was 10,001 millise
02-28
错误信息"The last packet successfully received from the server was 10,001 milliseconds ago"表示最后一次成功接收到的数据包距离当前时间已经过去了10,001毫秒。 这种错误通常发生在以下情况下： 1. 网络连接...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值