open连接MySQL超时_mysql5 超时链接

最新推荐文章于 2021-03-03 19:50:02 发布

香烟配红唇

最新推荐文章于 2021-03-03 19:50:02 发布

阅读量108

点赞数

文章标签： open连接MySQL超时

本文链接：https://blog.csdn.net/weixin_42400970/article/details/113470351

版权

在集群环境中，由于MySQL的wait_timeout设置为4小时，导致出现了请求处理失败，异常信息提示通信超时。建议考虑在应用中设置连接过期或验证连接有效性，增加服务器客户端超时值，或启用数据库连接的'autoReconnect=true'属性来避免此问题。

摘要由CSDN通过智能技术生成

三个系统，做的共享，集群，mysql设置wait_timeout位4小时，有什么号的解决办法，求解决

问题补充：tomcat

问题补充：有没有可能是做集群导致的错误，下面是异常

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: The last packet successfully received from the server was 92,817,508 milliseconds ago. The last packet sent successfully to the server was 92,817,508 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

--------------------------------------------------------------------------------

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: The last packet successfully received from the server was 92,817,508 milliseconds ago. The last packet sent successfully to the server was 92,817,508 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

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: The last packet successfully received from the server was 92,817,508 milliseconds ago. The last packet sent successfully to the server was 92,817,508 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:583)

org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501)

javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

com.zxtx.zpaas.build.utils.filter.AdminAuthFilter.doFilter(AdminAuthFilter.java:150)

org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)

org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

edu.yale.its.tp.cas.client.filter.CASFilter.doFilter(CASFilter.java:212)

root cause

org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 92,817,508 milliseconds ago. The last packet sent successfully to the server was 92,817,508 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:238)

org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)

org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)

org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

$Proxy21.findAllMenu(Unknown Source)

com.zxtx.zpaas.admin.menu.webtier.PMenuController.showMenu(PMenuController.java:131)

sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

java.lang.reflect.Method.invoke(Method.java:597)

org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473)

org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410)

org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)

org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)

org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875)

org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807)

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571)