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

绝地灬酷狼 2022-06-09 11:06 179阅读 0赞

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

### **解决办法如下：** ###

数据源是dataSource

错误内容：

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.PoolingDataSourcePoolGuardConnectionWrapper.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.PoolingDataSourcePoolGuardConnectionWrapper.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