Mysql 设置超时重连 autoReconnect=true

最新推荐文章于 2024-02-29 10:40:55 发布
最新推荐文章于 2024-02-29 10:40:55 发布
阅读量2.5w 收藏 5
点赞数 1
分类专栏： Mysql Spring Hibernate J2EE
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/return__null/article/details/51589038
版权
Spring 同时被 3 个专栏收录
3 篇文章 0 订阅
订阅专栏
Hibernate
3 篇文章 0 订阅
订阅专栏
J2EE
3 篇文章 0 订阅
订阅专栏

1需求

昨天在vps测试机上部署了web Demo(SH+mysql)程序,今天访问发现挂了.吓得我赶快把log down下来压压惊.

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.TransactionException: JDBC begin transaction failed: 
	at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:515)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:373)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:420)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:257)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
	at com.sun.proxy.$Proxy36.addVisitor(Unknown Source)
	at tk.licer.util.aop.Recorder.recorderVisitor(Recorder.java:86)
	at tk.licer.util.aop.Recorder.around(Recorder.java:60)
	at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:68)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644)
	at tk.licer.controller.LoginController$$EnhancerBySpringCGLIB$$8f9cd742.login(<generated>)
	at sun.reflect.GeneratedMethodAccessor63.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:152)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.TransactionException: JDBC begin transaction failed: 
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:76)
	at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:162)
	at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1435)
	at org.springframework.orm.hibernate4.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:474)
	... 63 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 85,245,420 milliseconds ago.  The last packet sent successfully to the server was 85,245,420 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.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3652)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2460)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
	at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4874)
	at org.apache.commons.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
	at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:72)
	... 66 more
Caused by: java.net.SocketException: Broken pipe
	at java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
	at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
	at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
	at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3634)
	... 73 more
2016-06-05 12:26:13,247 [http-bio-8080-exec-13] DEBUG org.springframework.orm.hibernate4.support.OpenSessionInViewFilter - Closing Hibernate Session in OpenSessionInViewFilter
2016-06-05 12:26:13,247 [http-bio-8080-exec-13] DEBUG org.hibernate.engine.jdbc.internal.LogicalConnectionImpl - Releasing JDBC connection
2016-06-05 12:26:13,248 [http-bio-8080-exec-13] DEBUG org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Could not close connection [n/a]
java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144)
	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.close(LogicalConnectionImpl.java:182)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:205)
	at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.close(TransactionCoordinatorImpl.java:297)
	at org.hibernate.internal.SessionImpl.close(SessionImpl.java:369)
	at org.springframework.orm.hibernate4.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:119)
	at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:161)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
2016-06-05 12:26:13,253 [http-bio-8080-exec-13] WARN  org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
2016-06-05 12:26:13,253 [http-bio-8080-exec-13] ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Already closed.
2016-06-05 12:26:13,253 [http-bio-8080-exec-13] DEBUG org.springframework.orm.hibernate4.SessionFactoryUtils - Could not close Hibernate Session
org.hibernate.exception.GenericJDBCException: Could not close connection
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:259)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.close(LogicalConnectionImpl.java:182)
	at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:205)
	at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.close(TransactionCoordinatorImpl.java:297)
	at org.hibernate.internal.SessionImpl.close(SessionImpl.java:369)
	at org.springframework.orm.hibernate4.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:119)
	at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:161)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Already closed.
	at org.apache.commons.dbcp.PoolableConnection.close(PoolableConnection.java:114)
	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:191)
	at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.closeConnection(DatasourceConnectionProviderImpl.java:144)
	at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.releaseConnection(AbstractSessionImpl.java:391)
	at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:255)
	... 28 more


2.问题

说的是hibernate session事物开始失败,导致系统出错,但是我记得配置的spring 事物管理器是没问题的呀.

接着往下看  

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 85,245,420 milliseconds ago.  The last packet sent successfully to the server was 85,245,420 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.

3.原因

出错的原因就这里,

在使用mysql是的时候,如果超过8小时数据库没有操作,会自动断开连接,可以配置:

autoReconnect=true

来避免这个问题.


4.解决

网上开了一下,

4.1如果直接使用jdbc url连接的时候,设置:

connection url加参数: autoReconnect=true

4.2使用hibernate就设置:

<prop key="connection.autoReconnect">true</prop>
<prop key="connection.autoReconnectForPools">true</prop>
<prop key="connection.is-connection-validation-required">true</prop>





过了爱做梦的年纪s
关注
  • 1
    点赞
  • 踩
  • 5
    收藏
    觉得还不错? 一键收藏
  • 5
    评论
专栏目录
autoreconnect mysql true_autoReconnect=true设置无效 待解决
weixin_39825854的博客
01-14 2774
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last ...
Mysql 中的autoReconnect=true参数
河流(River)的专栏
12-21 1744
1. 即使在创建Mysql时url中加入了autoReconnect=true参数,一但这个连接两次访问数据库的时间超出了服务器端wait_timeout的时间限制,还是会CommunicationsException: The last packet successfully received from the server was xxx milliseconds ago. 2. 服务器端的...
JDBC连接断开，autoReconnect=true失效解决方案：做一个合格的回头客！
m0_72947486的博客
08-11 2095
autoReconnect=true失效， 数据库等待超时， JDBC， 线程
MySQL为什么莫名其妙的断开连接以及解决方案
热门推荐
月伴飞鱼
12-10 1万+
前言 最近遇到在将本地的项目部署到服务器上之后遇到的一个奇怪问题 在部署完成后，网站当时可以正常工作，但是第二天访问网站的时候却会遇到一个500 Server Error。 从日志中可以看出是MySQL数据库出现了异常 翻译: 最后一个数据包在 83827560 ms 之前被成功接收，最后一个数据包在83827560 ms 之前被成功发送。比服务的配置参数wait_timeout的值要长。 日志中给出的建议如下 翻译： 你应考虑在程序中进行数据库操作之前检验数据库连接的有效性或者将数据库的auto
mysql客户端断开重连实现
weixin_41953346的博客
10-31 2156
1、一条sql的故事 2、autoReconnect=true.实现原理
c3p0 mysql 自动重连_C3P0官方对于MySQL8小时问题的解决方案
weixin_39918248的博客
03-05 228
前一段时间在做一个发邮件的程序，程序是用定时器，每晚凌晨定时发邮件，邮件内容需要从数据库中获取，运行了一天就出问题了。问题信息如下com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was56588 milliseconds ag...
mysql auto reconnect_Mysql5的auto Reconnect异常
weixin_39618824的博客
01-19 417
mysql5的auto Reconnect错误最近在一个J2EE项目的开发过程中，遇到了这样的问题:在服务器上部署好这个Web系统后，这时访问系统是很正常的。当把服务器的时间(例如：2008-03-31)加一天或更多天(例如：2008-04-01，2008-04-02...)，这时再访问这个Web系统，报出如下的异常：com.mysql.jdbc.CommunicationsException:...
详解JDBC链接中的参数autoReconnect到底生效吗
Receptive2WE的博客
12-03 5654
JDBC链接中的参数autoReconnect到底生效吗？答案是肯定生效的，但是有一些注意事项如果没处理好就会导致不生效。并且即便生效了，也有一些小坑需要处理，所以官方意见是不推荐用这个参数的。
关于MySQL的wait-timeout连接超时问题报错解决方案.docx
07-12
3. 使用 Connector/J 连接属性 'autoReconnect=true'，避免连接超时的问题。 结论 MySQL 连接超时问题是常见的错误之一，解决该问题需要了解 wait_timeout 参数的重要性，并正确地使用 show variables 命令。同时...
关于MySQL的wait-timeout连接超时问题报错解决方案.pdf
07-12
4. 考虑使用 Connector/J 连接属性：在使用 Hibernate 进行数据库操作时，可以考虑使用 Connector/J 连接属性，例如 autoReconnect=true，来避免连接超时问题。 5. 及时释放连接：在使用完毕连接后，需要及时释放...
autoreconnect:简单的 Meteor 客户端自动重连包
05-31
AutoReconnect 是一个简单的 Meteor 包，用于将客户端重新连接到服务器。 主要适用于可能会遇到一些离线行为的 Meteor-Cordova / Web 应用程序。 添加包 $ meteor add nspangler:autoreconnect 用法 在客户端，只需...
irccloud-auto-reconnect:自动重新连接IRCCloud
05-22
自动重新连接自动重新连接 。 该脚本适用于非订户。 当您打开新的IRCCloud页面时，此脚本将重新连接到所需的断开连接的网络。 支持的浏览器：带有Firefox和带有Chrome
hibernate自动重新连接数据库proxool的使用
06-07
hibernate自动重新连接数据库proxool的使用及配置
mysql5 autoreconnect_Mysql5的auto Reconnect错误
weixin_30220707的博客
02-02 827
一、解决方案一最近在一个J2EE项目的开发过程中，遇到了这样的问题:在服务器上部署好这个Web系统后，这时访问系统是很正常的。当把服务器的时间(例如：2008-03-31)加一天或更多天(例如：2008-04-01，2008-04-02...)，这时再访问这个Web系统，报出如下的异常：QUOTE:com.mysql.jdbc.CommunicationsException: Communicat...
mysql 参数--关于wait_timeout和autoReconnect
weixin_41914251的博客
02-29 502
如果你的MySQL Server有大量的闲置连接，他们不仅会白白消耗内存，而且如果连接一直在累加而不断开，最终肯定会达到MySQL Server的连接上限数，这会报'too many connections'的错误。对于交互和非交互连接，说得直白一点就是，通过mysql客户端连接数据库是交互式连接，通过jdbc连接数据库是非交互式连接。MySQL的默认设置，当一个连接的空闲时间超过8小时后，MySQL就会断开该连接。：mysql在关闭一个非交互的连接之前所要等待的秒数。所以发现问题出在如果超过这个。
记录一次mysql数据库Broken pipe 报错的生产问题的处理
miniy
02-19 1641
mysql 数据库 Broken pipe 管道破裂问题处理
EntityFrameworkCore（efcore）在与 MySQL 连接使用中的问题
weixin_30741653的博客
07-09 467
请直接使用第三方驱动： Pomelo.EntityFrameworkCore.MySql（https://github.com/PomeloFoundation/Pomelo.EntityFrameworkCore.MySql） 代替官方的 EF 驱动，官方的驱动在类型转换上有 BUG（在建库时部分类型会导致：InvalidCastException，在查询时会导致：InvalidOperatio...
基于易支付二开的前端模板美化源码.zip
最新发布
06-17
基于易支付二开的前端模板美化源码
WARNING [tid:215057,Q:A238ACFUBhVQXEFuqWPf] Reset AutoCommit failed: coremail@jdbc:mysql://172.28.254.240:3308/cmxt_log?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true; url=jdbc:mysql://172.28.254.240:3308/cmxt_log?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true; username=coremail; exception=com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 55,856,315 milliseconds ago. The last packet sent successfully to the server was 55,856,316 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.; elapsedTime=0 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 55,856,315 milliseconds ago. The last packet sent successfully to the server was 55,856,316 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.
07-14
这是一个MySQL连接超时的错误。错误消息指示最后一次成功接收到服务器数据包的时间距离现在已经超过了服务器配置的'wait_timeout'值。建议您考虑以下几种解决方案： 1. 在使用连接之前，可以在应用程序中检查连接的有效性，确保连接仍然可用。您可以使用一些简单的查询或操作来测试连接，以确保连接处于活动状态。 2. 考虑增加服务器配置中客户端超时的值。通过增加'wait_timeout'的值，可以延长服务器等待连接空闲的时间。这样可以避免连接超时导致的问题。请注意，此方法可能会增加服务器资源的消耗。 3. 可以使用Connector/J连接属性'autoReconnect=true'来避免此问题。设置'autoReconnect=true'将使连接在断开后尝试自动重新连接到MySQL服务器。 根据您的具体情况选择适合您的解决方案，并根据需要进行相应的配置更改。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值