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

最新推荐文章于 2024-01-17 08:48:31 发布
最新推荐文章于 2024-01-17 08:48:31 发布
阅读量1k 收藏
点赞数
分类专栏： mysql 文章标签： mysql java datasource link-fail
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/change_on/article/details/77838857
版权

数据库迁移过后，一直被一个bug困扰，有时候可以访问页面，有时候报mysql连接错误，刷新一遍又可以了。因为迁移以前是在虚拟主机上装的mysql，可以修改mysql的配置文件，设置连接时长，但是迁移的新数据库是一个实例，所以只能在代码中改动。

解决办法如下：

数据源是dataSource 

<property name="validationQuery" value="SELECT 1" />
<property name="testOnBorrow" value="true"/>


错误内容：

HTTP Status 500 - Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

type Exception report

message Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 325,737 milliseconds ago. The last packet sent successfully to the server was 14 milliseconds ago.
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:980)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 325,737 milliseconds ago. The last packet sent successfully to the server was 14 milliseconds ago.
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:245)
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
com.sun.proxy.$Proxy48.getAreas(Unknown Source)
com.xforce.storm.controller.StormDemoController.goStormDemo(StormDemoController.java:26)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause

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

The last packet successfully received from the server was 325,737 milliseconds ago. The last packet sent successfully to the server was 14 milliseconds ago.
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:526)
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3720)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3609)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4160)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)
com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5372)
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
org.apache.commons.dbcp.PoolingDataSource PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:225)org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)com.sun.proxy. Proxy48.getAreas(Unknown Source)
com.xforce.storm.controller.StormDemoController.goStormDemo(StormDemoController.java:26)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
root cause

java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost.
com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3166)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3620)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3609)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4160)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2828)
com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:5372)
org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:331)
org.apache.commons.dbcp.PoolingDataSource PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:317)org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:225)org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:427)org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:276)org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)com.sun.proxy. Proxy48.getAreas(Unknown Source)
com.xforce.storm.controller.StormDemoController.goStormDemo(StormDemoController.java:26)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:606)
org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:178)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:444)
org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:432)
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
note The full stack trace of the root cause is available in the Apache Tomcat/8.0.33 logs.

Apache Tomcat/8.0.33

J_小浩子
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Idea启动项目报错:com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
李指导的博客
04-28 388
之前使用IDEA2022.1版本运行SprintBoot项目,在yml配置文件配置了MYSQL的datasource, 启动项目没有任何问题,后来电脑重装了系统,就装了一个IDEA2024.1的版本,再次运行项目时报错：
连接数据库报错com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure的解决方法
热门推荐
m0_52767002的博客
02-08 7万+
控制台报错 Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. T.
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
我的博客
07-25 1039
Druid 1.0.20版本之后，开始支持配置connectTimeout和socketTimeout。在1.0.20版本之前，Druid默认使用Java底层的连接超时和读取超时参数。 如果不配置 connect-timeout 和 socket-timeout 参数，则默认启用 Druid 的默认超时时间。默认情况下，连接超时时间为 1000 毫秒，读取超时时间为 30 分钟。如果需要更改超时时间，可以配置 connect-timeout 和 socket-timeout 参数来覆盖默认值。 一般来说，建
解决：com.mysql.cj.jdbc.exceptions.CommunicationsException Communications link failure
m0_67393593的博客
04-29 1911
1.增加一个配置 #下面这两个配置，可以在每次连接的时候判断一些连接是否有效 spring.datasource.druid.test-on-borrow=true spring.datasource.druid.test-while-idle=true 参考: 解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure（真实有效） ...
Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last p
style_L_的博客
02-20 580
Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet successfully received from the server was 10,310 milliseconds ago. The last packet sent successfully to the server was 10,310 milliseconds ago.
解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
知北行的博客
01-10 2万+
1.增加一个配置 #下面这两个配置，可以在每次连接的时候判断一些连接是否有效 spring.datasource.druid.test-on-borrow=true spring.datasource.druid.test-while-idle=true 参考: 解决：com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure（真实有效） ...
Caused by: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
最新发布
中年程序员一枚的博客
01-17 832
报错问题： The last packet successfully received from the server was 34,384 milliseconds ago. The last packet sent successfully to the server was 34,392 milliseconds ago. at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.jav
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
qq_21128741的博客
03-01 1万+
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failur
解决数据库查询时间过长导致com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
u012785397的博客
02-28 1万+
数据库查询时间长时报错：The last packet successfully received from the server was 10,017 milliseconds ago. The last packet sent successfully to the server was 10,018 milliseconds ago. Communications link failure
mybatis 使用jdbc.properties文件设置不起作用的解决方法
08-27
然后，我们可以在 `<dataSource>` 元素中使用 `${jdbc.driverClass}`、`${jdbc.url}`、`${jdbc.username}` 和 `${jdbc.password}` 等变量来获取 jdbc.properties 文件中的信息。例如： ```xml <dataSource type=...
Spring对JDBC的支持jar包.rar
11-28
Spring框架是Java开发中最常用的框架之一，其对JDBC（Java Database Connectivity）的支持极大地简化了数据库操作，使得开发者能够更加专注于业务逻辑，而非底层数据库交互的繁琐细节。本压缩包包含"spring-jdbc-...
kingbasejdbc4.jar
12-06
4. Type 4：全Java数据库连接驱动，直接通过网络协议与数据库通信，提供最佳性能。 金仓kingbasejdbc4.jar属于Type 4驱动，完全用Java编写，直接与金仓数据库服务器进行通信，无需依赖其他中间件或接口。 使用...
MySql5.x升级MySql8.x的方法步骤
09-08
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF8 ``` **三、升级数据库服务器** 1. **停服并备份**：在升级前，停止所有数据库服务，...
dbcp.rar_Commons-jdbc.zip jar_DBCP_commons jdbc_dbcp jar_dbcp.ja
09-24
标题中的"dbcp.rar_Commons-jdbc.zip jar_DBCP_commons jdbc_dbcp jar_dbcp.jar"提到了几个关键元素，这些元素都是关于Java数据库连接池（JDBC Connection Pool）技术的，特别是Apache Commons DBCP组件。...
mycat实现简单的mysql集群负载均衡
小浩子的博客
07-14 1万+
什么是mycat呢？简单理解为一个mysql中间件，它支持分流、基于心跳的自动故障切换，支持读写分离，支持MySQL主从，基于Nio管理线程的高并发… 详见官网：http://www.mycat.io/ 为什么需要mysql集群？一个庞大的分布式系统的性能瓶颈中，最脆弱的就是连接，一个是客户端与后端的连接，另一个是后端与数据库的连接，说白了就是发送端请求太多，接收端能够的接收和处理的请求并不多，
ERROR 1142 CREATE command denied to user 'root'@'xxxxx
小浩子的博客
08-15 8908
mysql>grant all on . to root@’%’ identified by ‘密码’;mysql>flush privileges;
opensuse做服务器小结
小浩子的博客
02-25 2918
昨天要把项目部署到opensuse上，项目是ss2h框架，按照传统，在opensuse安装有tomcat，tomcat，jdk，当项目部署在tomcat时，普通的页面可以打开，但是与数据库有交互的页面报了500错误 报不能连接错误：org.springframework.transaction.CannotCreateTransactionException: Could not open Hi
win7 64位安装mysql5.7.22
小浩子的博客
07-24 351
5.7.22是免安装版 一、先从官网下 选择5.7的： 先选择64位，再下载： 二、下载后解压到目录中，我是：F:\mysql-5.7.22-winx64 然后新建my.ini文件 [mysqld] port = 3306 basedir=F:\mysql-5.7.22-winx64 datadir=F:\mysql-5.7.22-winx64\data max_c...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值