Mysql 设置超时重连 autoReconnect=true

最新推荐文章于 2023-07-24 16:42:19 发布
原创 最新推荐文章于 2023-07-24 16:42:19 发布 · 2.6w 阅读 · 5 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了在使用Spring+Hibernate框架部署web应用时遇到的MySQL连接超时问题，并提供了详细的错误日志分析及解决方案，包括如何配置MySQL的等待超时时间和启用自动重连。

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>





MySQL为什么莫名其妙的断开连接以及解决方案
月伴飞鱼
12-10 2万+
前言 最近遇到在将本地的项目部署到服务器上之后遇到的一个奇怪问题 在部署完成后，网站当时可以正常工作，但是第二天访问网站的时候却会遇到一个500 Server Error。 从日志中可以看出是MySQL数据库出现了异常 翻译: 最后一个数据包在 83827560 ms 之前被成功接收，最后一个数据包在83827560 ms 之前被成功发送。比服务的配置参数wait_timeout的值要长。 日志中给出的建议如下 翻译： 你应考虑在程序中进行数据库操作之前检验数据库连接的有效性或者将数据库的auto
Mysql-Druid连接池配置
皮皮皮的代码
10-20 3176
1. 背景 2. 介绍 （1）连接池大小配置 连接数 = ((核心数 * 2) + 有效磁盘数) 按照这个公式，如果说你的服务器 CPU 是 4核 i7 的，连接池大小应该为((4*2)+1)=9。取个整, 我们就设置为 10 吧。 （2） 3. 源码 4. 实战 假设数据库实例是4核8G spring: datasource: url: jdbc:mysql://127.0.0.1:3306/test?serverTimezone=Asia/Shanghai&u.
记录一次mysql数据库Broken pipe 报错的生产问题的处理
miniy
02-19 2230
mysql 数据库 Broken pipe 管道破裂问题处理
Mysql 中的autoReconnect=true参数
河流(River)的专栏
12-21 2028
1. 即使在创建Mysql时url中加入了autoReconnect=true参数,一但这个连接两次访问数据库的时间超出了服务器端wait_timeout的时间限制,还是会CommunicationsException: The last packet successfully received from the server was xxx milliseconds ago. 2. 服务器端的...
mybatis mysql autoreconnect=true_mysql 数据库连接超时的问题 autoReconnect=true
weixin_34568147的博客
01-27 1659
最近在使用spring-jdbc数据库连接管理时，出现一个奇怪问题，当天部署运行没问题，第二天再试就报以下异常问题org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL []; The last packet successfully received from the serve...
jdbc连接mysql数据库超时autoReconnect=true报错
10-11
当使用JDBC连接MySQL数据库并设置`autoReconnect=true`以允许自动重连时，如果连接尝试超过预设的超时时间仍然无法建立连接，可能会遇到错误。这是因为JDBC默认会等待一段时间然后断开连接并再次尝试，但这可能导致...
&autoReconnect=true&failOverReadOnly=false&maxReconnects=10
05-24
- **`autoReconnect=true`**: 开启自动重连功能，允许客户端在网络中断等情况发生时尝试重新建立到服务器端的通信链路[^4]。 - **`failOverReadOnly=false`**: 确保即使切换到了备用主机上执行查询操作也不会默认...
jdbc:mysql://10.0.0.26:3309/wtcp-ecrm?characterEncoding=utf8&connectTimeout=10000&socketTimeout=30000&autoReconnect=true&useUnicode=true&useSSL=false&serverTimezone=UTC&allowMultiQueries=true 解析
04-17
A1: MySQL 官方已弃用此参数，重连可能导致事务中断或状态丢失，建议通过 HikariCP 等连接池的 `connection-test-query` 维持活跃[^4]。 **Q2: `allowMultiQueries` 的应用场景？** A2: 批量执行 DDL/DML（如初始...
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连接超时的错误。错误消息指示最后一次成功接收到...设置'autoReconnect=true'将使连接在断开后尝试自动重新连接到MySQL服务器。 根据您的具体情况选择适合您的解决方案，并根据需要进行相应的配置更改。
Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@197f0880] was not registered for synchronization because synchronization is not active 2025-06-05 10:12:17.312 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42435 2025-06-05 10:12:17.313 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42443 2025-06-05 10:12:17.314 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42445 2025-06-05 10:12:17.314 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42451 2025-06-05 10:12:17.314 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42453 2025-06-05 10:12:17.316 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42461 2025-06-05 10:12:17.316 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42462 2025-06-05 10:12:17.317 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42465 2025-06-05 10:12:17.320 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42470 2025-06-05 10:12:17.321 ERROR 24008 --- [nio-8080-exec-6] c.a.druid.pool.DruidAbstractDataSource : discard long time none received connection. , jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, jdbcUrl : jdbc:mysql://localhost:3306/car?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8&autoReconnect=true, lastPacketReceivedIdleMillis : 42475 JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@59f7e6a3] will not be managed by Spring ==> Preparing: SELECT id,username,phone,license_plate,user_password,yn,create_time,update_time FROM tb_user WHERE (phone = ?) ==> Parameters: 18555522072(String) <== Columns: id, username, phone, license_plate, user_password, yn, create_time, update_time <== Row: 2, 李华, 18555522072, 1234, 1234, null, 2025-04-16 09:49:06, 2025-04-17 11:00:37 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@197f0880] 2025-06-05 10:12:17.461 INFO 24008 --- [nio-8080-exec-6] c.z.c.demo.aspect.OpenApiCatchAspect : 接口请求方法=AuthController login, 请求参数=[{"password":"03ac674216f3e15c761ee1a5e255f067953623c8b388b4459e13f978d7c846f4","phone":"18555522072"}], 返回={"success":true}, 用时=238ms Creating a new SqlSession SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c0ea46] was not registered for synchronization because synchronization is not active JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@59f7e6a3] will not be managed by Spring ==> Preparing: SELECT id,username,phone,license_plate,user_password,yn,create_time,update_time FROM tb_user WHERE (phone = ?) ==> Parameters: 18555522072(String) <== Columns: id, username, phone, license_plate, user_password, yn, create_time, update_time <== Row: 2, 李华, 18555522072, 1234, 1234, null, 2025-04-16 09:49:06, 2025-04-17 11:00:37 <== Total: 1 Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4c0ea46] 2025-06-05 10:12:18.087 INFO 24008 --- [nio-8080-exec-7] c.z.c.demo.aspect.OpenApiCatchAspect : 接口请求方法=AuthController login, 请求参数=[{"password":"03ac674216f3e15c761ee1a5e255f067953623c8b388b4459e13f978d7c846f4","phone":"18555522072"}], 返回={"success":true}, 用时=0ms
最新发布
06-07
Druid提供的连接对象是代理对象（`ConnectionProxyImpl`），需要Spring事务管理器的特殊支持-由于未开启事务，Spring不会接管该连接的生命周期（引用[2][3]）####3.**日志输出配置**-当MyBatis日志级别设置为DEBUG时...
autoreconnect mysql true_【IT专家】MySQL 参数autoReconnect=true 解决8小时连接失效(转)
weixin_29649047的博客
12-24 797
本文由我司收集整编，推荐下载，如有疑问，请与我司联系MySQL参数autoReconnect=true解决8小时连接失效(转)2017/07/19552纵然在创建Mysql时url中加入了autoReconnect=true参数,一但这个连接两次访问数据库的时间超出了服务器端wait_timeout的时间限制,还是会CommunicationsException:Thelastpacket...
mybatis mysql 批量_mysql使用mybatis批量更新问题
weixin_36484814的博客
01-18 407
一、好言在光芒万丈之前，我们都要欣然接受眼下的难堪和不易，接受一个人的孤独和偶尔的无助。二、背景其实这是在处理一个问题的时候，需要批量更新数据，结果这个批量更新数据是有问题的，所以改了顺便记载下。问题SQL: update t_user set user_name = ?, age = ?, login_token = ? where login_token = ? ; update t_user...
mybatis mysql autoreconnect=true_Mysql8.0主从搭建，shardingsphere+springboot+mybatis读写分离...
weixin_27977279的博客
02-17 966
cd /usr/local/mysqlmkdir mysql-fileschown mysql:mysql mysql-fileschmod 750 mysql-filesbin/mysqld --initialize --user=mysql，初始化数据库，注意此处随机生成的密码，第一次登陆mysql的时候要使用。bin/mysql_ssl_rsa_setup，安装ssl。cp support-...
autoreconnect mysql true_autoReconnect=true设置无效 待解决
weixin_39825854的博客
01-14 2960
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last ...
mysql连接失活_Mysql 参数autoReconnect=true 解决8小时连接失效
weixin_29810427的博客
02-07 2679
1. 即使在创建Mysql时url中加入了autoReconnect=true参数,一但这个连接两次访问数据库的时间超出了服务器端wait_timeout的时间限制,还是会CommunicationsException: The last packet successfully received from the server was xxx milliseconds ago.2. 服务器端的参数...
连接数据库超时设置autoReconnect=true，默认重试次数调整
热门推荐
灵台方寸山斜月三星洞
01-19 1万+
博客园-yafyr-连接数据库超时设置autoReconnect=true Table 6.12 High Availability and Clustering Properties maxReconnects：如果autoReconnect为true，则尝试重新连接的最大次数，默认为’3’。 initialTimeout：如果启用了autoReconnect，重新连接尝试之间的初始等待时间(以秒为单位，默认为’2’)。 ......
mysql: using the Connector/J connection property ‘autoReconnect=true‘ to avoid this problem
易的博客
07-24 1154
3：testWhileIdle必须设置为true，在获取到连接后，先检查testOnBorrow，然后再判定testwhileIdle，如果连接空闲时间大于timeBetweenEvictionRunsMillis，则会进行心跳检测。600秒，报错信息是：1,129,144毫秒之前，1129秒之前，在这1000秒之前连接已经过时了，你的连接池中，要是有多个连接，这个是偶然现象，因为有别的连接不一定过时。5：连接保存在数组里面，获取连接的时候，获取数组的最后一位。这里设置为1，避免线程较多的情况。
使用Hibernate + MYSQL数据库问题(Hibernate连接数据库超时设置autoReconnect=true)
紫竹blog
04-28 241
使用Hibernate + MYSQL数据库开发，链接超时问题： com.mysql.jdbc.CommunicationsException: The last packet successfully received from the server was58129 seconds ago.The last packet sent successfully to the server...
autoreconnect mysql true_为什么autoReconnect = true似乎不起作用？
weixin_26801149的博客
01-14 1627
I am using JDBC to connect to a MySQL server (no connection pooling I think). In the connection URL I have autoReconnect=trueBut my connection still times out. I've even checked conn.isClosed() and ...
评论 5
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值