The last packet successfully received from the server was 1,072 milliseconds ago. The last packet s

最新推荐文章于 2024-08-18 17:37:54 发布
最新推荐文章于 2024-08-18 17:37:54 发布
阅读量3.6k 收藏 2
点赞数
分类专栏： 框架 文章标签： tomcat java apache mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yanzer/article/details/124614464
版权
本文探讨了在启动Spring Boot应用时遇到的数据库连接错误，特别提到当使用MySQL 5.7与com.mysql.jdbc.Driver时，解决方法是将useSSL参数设为false。通过实例和原因分析，提供了解决步骤。
摘要由CSDN通过智能技术生成

问题：

今天在运行一个打包好的 jar 项目的时候，报了标题上的这个错误。

具体错误如下：

2022-05-06 16:42:23.534 [main] INFO  com.zer.MyApplication - Starting MyApplication v1.0-SNAPSHOT on yanze with PID 13900 (E:\B_springboot_mybatis-1.0-SNAPSHOT.jar started by 51013 in E:\)
2022-05-06 16:42:23.542 [main] INFO  com.zer.MyApplication - No active profile set, falling back to default profiles: default
2022-05-06 16:42:26.501 [main] INFO  o.s.boot.web.embedded.tomcat.TomcatWebServer - Tomcat initialized with port(s): 8080 (http)
2022-05-06 16:42:26.527 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8080"]
2022-05-06 16:42:26.546 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
2022-05-06 16:42:26.547 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.27]
2022-05-06 16:42:27.076 [main] INFO  org.apache.jasper.servlet.TldScanner - At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
2022-05-06 16:42:27.455 [main] INFO  o.a.c.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
2022-05-06 16:42:27.457 [main] INFO  org.springframework.web.context.ContextLoader - Root WebApplicationContext: initialization completed in 3805 ms
2022-05-06 16:42:27.680 [main] INFO  c.a.d.s.b.a.DruidDataSourceAutoConfigure - Init DruidDataSource
2022-05-06 16:42:33.788 [main] ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url: jdbc:mysql://192.168.21.1:3306/spring?characterEncoding=utf8
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 1,072 milliseconds ago.  The last packet sent successfully to the server was 1,054 milliseconds ago.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:201)
	at com.mysql.jdbc.MysqlIO.negotiateSSLConnection(MysqlIO.java:4869)
	at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1656)
	at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217)
	at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189)
	at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786)
	at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:786)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623)
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:861)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1904)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1846)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1774)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:857)
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:760)
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:509)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1321)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1160)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1500)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1395)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:592)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:595)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:376)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1411)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:592)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:277)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1255)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1175)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:595)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:90)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:376)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1411)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:592)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:847)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:877)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:549)
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:744)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:391)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:312)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1204)
	at com.zer.MyApplication.main(MyApplication.java:17)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:87)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:51)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52)
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
	at sun.security.ssl.HandshakeContext.<init>(Unknown Source)
	at sun.security.ssl.ClientHandshakeContext.<init>(Unknown Source)
	at sun.security.ssl.TransportContext.kickstart(Unknown Source)
	at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
	at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:186)
	... 108 common frames omitted
2022-05-06 16:42:33.798 [main] ERROR com.alibaba.druid.pool.DruidDataSource - {dataSource-1} init error
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

解决：

出现这种错误的情况如下：

  1. 数据库连接长时间没有使用，断开连接之后再去连接，就会出现这种情况。
  2. 数据库连接的后缀参数问题。

我是属于第二种：数据库连接的后缀参数问题。

解决方案：

因为我使用的mysql版本是5.7的，驱动Driver使用的是：com.mysql.jdbc.Driver，

所以，必须要在连接的url后面添加 useSSL=false 即可。

$useSSL=false

 

解决这个问题，参考的是这篇文章，针对这次的错误，所以做一个记录。

如果是第一种情况，请参考参考文章：参考文章

The last packet successfully received from the server was 4,758 milliseconds ago
隔壁老瓦的专栏
10-12 1322
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 2812
在使用kettle时遇到MySQL数据库连接问题： 1.Navicat可以连接到目标MySQL库，说明不是数据库权限的问题。 2.用kettle可以连接其他同版本MySQL库，说明也不是jar包的问题。 最终，尝试过重启电脑，删除kettle文件重装，替换jar包等各种办法之后，才发现问题在.kettle文件夹里面： 这是出问题时.kettle文件夹下面的文件，比正常文件多了一些东西。 个人的解决办法： 1.备份 kettle.properties 文件，这是平时用的连接资源库的信息 2.删除.kett
The last packet successfully received from the server was 8,098,360 milliseconds ago.
蓝天之枫
01-16 3680
线上环境凌晨5分有个定时任务没执行，查看日志发现报错 The last packet successfully received from the server was 8,098,360 milliseconds ago.  The last packet sent successfully to the server was 1 milliseconds ago. 这个意思是说 从服务器成...
数据库查询时间过长导致The last packet sent successfully to the server was 10,001 milliseconds ago深入分析及解决方案
qq_36677358的博客
08-10 773
就是说通过在配置文件中配置connectTimeout与socketTimeout即可解决此问题.找到application.yml
The last packet successfully received from the server was milliseconds ago
最新发布
向java进军
08-18 265
5）hibernate.c3p0.idle_test_period：表示连接池检测线程多长时间检测一次池内的所有连接对象是否超时，连接池本身不会把自己从连接池中移除。3）hibernate.c3p0.acquire_increment：当数据库连接池中的连接耗尽时，同一时刻获取多少个数据库连接。4）hibernate.c3p0.timeout：连接池中连接对象在多长时间没有使用过后，就应该被销毁。6）hibernate.c3p0.max_statements：缓存Statement对象的数量。
Communications link failure，The last packet successfully received from the server was × millisecon..
varyall的专栏
11-21 1万+
版权声明：本文为博主原创文章，未经博主允许不得转载。    https://blog.csdn.net/liuxiao723846/article/details/45534885         关于MySQL连接超时问题，估计很多人都遇到过：大致情形都是这样，开发测试时程序都是正常的，一到第二天就出先莫名错误，比如在我的项目中使用了多数据源，其中有一个数据源仅仅供查询使用，所以使用次数很少。当...
生产报错日志【The last packet successfully received from the server was 5,007 milliseconds ago】
qq_36010886的博客
02-20 1433
生产日志报错 显示日志异常为：
The last packet successfully received from the server was 59,866 milliseconds ago. The last packet
mt23
09-11 1069
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 ...
CLIENT_PLUGIN_AUTH is required
热门推荐
海洋之心
10-20 4万+
将mysql-connector-java由5.1.34升级到了6.0.6，本机MySQL5.7使用没问题，连测试服务器MySQL5.5创建数据库连接报错： Caused by: java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.
springboot集成mysql时报CLIENT_PLUGIN_AUTH is required异常处理
riemann_的博客
04-27 1240
异常信息： java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.15.jar:8.0....
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
The last packet successfully received from the server was 596,688 milliseconds a
qq123zhz的专栏
09-05 828
转载： The last packet successfully received from the server was 596,688 milliseconds ago. 后来查了一些资料，才发现遇到这个问题的人还真不少，大部分都是使用连接池方式时才会出现这个问题，短连接应该很难出现这个问题。这个问题的原因： MySQL服务器默认的“wait_timeout”是28800秒即8小时...
The last packet successfully received from the server was 8,268,658 milliseconds ago
秋枫
12-21 2万+
最近做一个小应用，启动后刚开始访问时报错，但是多点几次就好了，就没在意。应用里面有定时，分别是上午10点，11点和12点各执行一次。奇怪的是10点的定时执行的时候会报下面的错误，11点和12点的就没问题。然后我把10点的定时改成每分钟一次就没事了。连着两三天一直这样就觉得很奇怪。报错异常如下： The last packet successfully received from the se...
The last packet successfully received from the server was 123,051 milliseconds ago. The last packet
whax
12-19 670
The last packet successfully received from the server was 123,051 milliseconds ago. The last packet
【MySQL之轨迹】The last packet successfully received from the server was xxx milliseconds ago 连接超过 8 小时失效
Ice__Clean的博客
05-25 2880
数据库连接闲置 8 小时的解决方法之一：定时更新数据库连接池中的连接，使用了 jdk8 的新日期获取方式，通过连接创建的时间与当前使用的时间之差是否超时判断是否更新连接池
The last packet successfully received from the server was 1,547,682,071 milliseconds ago. The last
datouniao1的博客
09-13 775
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...
mysql连接池报错:The last packet successfully received from the server was XXXXX milliseconds ago
诸葛小猿
12-10 2万+
具体报错信息 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个小时没有从服务器上接
The last packet successfully received from the server was 30,516,920 milliseconds ago.
StrideBin的博客
06-22 1万+
今天早上发了一笔交易 发现服务器上报错 可见这笔交易是9点半左右发出的 入库的时候发现连接已经断掉,第一反应先计算了一下断掉的时间30516920/3600/1000 = 8.4769222222222. 大概就是半夜一点钟断掉的.我又去查了一下上一次启动项目的时间,发现现在的进程已经不是我上一次启动的进程了,也就是说中间肯定有人启过,于是我去查了一下Jenkins .果然有人动过.是不是
The last packet successfully received from the server was 11,226 milliseconds ago.
stujike123456的博客
08-13 3770
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 11,226 milliseconds ago. Caused by: java.net.Socket...
The last packet successfully received from the server was 1,266,537 milliseconds ago. The last pack
java1993666的博客
02-23 1万+
最近接手一个项目，由于该项目对mysql数据库使用频率不是很高，线上每天都会报几十条数据库连接失效的错误信息，刚开始没空处理这个错误，连接失效超时后会继续建立有效连接，不会影响正常的业务。今天抽空处理下这个错误，简单做下总结： 1、线上错误的日志信息如下： 2019-02-23 09:49:35:872 d.s.Statement 149 [ERROR] {conn-10345, stmt-4...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

写BUG的ySir

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值