数据库睡眠并导致异常 [英] Database sleeping and causing exception

问题描述

当我没有做任何数据库查询一段时间，我认为它必须睡觉 - 如果你然后调用它抛出一个异常;

  java.sql.SQLNonTransientConnectionException：无法读取resultset：意外的结束流，从4 
读取0bytes从org.mariadb.jdbc.internal.SQLExceptionMapper.get（SQLExceptionMapper.java:136）
 at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException（SQLExceptionMapper.java:106）
 at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog（MySQLStatement.java:264）
 at org.mariadb .jdbc.MySQLStatement.execute（MySQLStatement.java:288）
 at org.mariadb.jdbc.MySQLStatement.executeUpdate（MySQLStatement.java:317）
 at org.mariadb.jdbc.MySQLPreparedStatement.executeUpdate（MySQLPreparedStatement .java：156）
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate（DelegatingPreparedStatement.java:105）
 at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate（DelegatingPreparedStatement.java:105 ）
 at com.swifte.database.DBFactory.updateTimeForUser（DBFactory.java:302）
 at com.swifte.database.DBFactory.addInsertToDB（DBFactory.java:275）
 at com。 swifte.service.ExposedFunctions.login（ExposedFunctions.java:135）
在sun.reflect.NativeMethodAccessorImpl.invoke0（本地方法）
在sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
 at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
 at java.lang.reflect.Method.invoke（Method.java:483）
 at org.jboss.resteasy。 core.MethodInjectorImpl.invoke（MethodInjectorImpl.java:167）
在org.jboss.resteasy.core.ResourceMethod.invokeOnTarget（ResourceMethod.java:269）
在org.jboss.resteasy.core.ResourceMethod。 invoke（ResourceMethod.java:227）
在org.jboss.resteasy.core.ResourceMethod.invoke（ResourceMethod.java:216）
在org.jboss.resteasy.core.SynchronousDispatcher.getResponse（SynchronousDispatcher。 java：542）
 at org.jboss.resteasy.core.SynchronousDispatcher.invoke（SynchronousDispatcher.java:524）
 at org.jboss.resteasy.core.SynchronousDispatcher.invoke（SynchronousDispatcher.java:126） 
 at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service（ServletContainerDispatcher.java:208）
 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service（HttpServletDispatcher。 java：55）
 at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service（HttpServletDispatcher.java:50）
在javax.servlet.http.HttpServlet.service（HttpServlet.java： 847）
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter（ApplicationFilterChain.java:295）
 at org.apache.catalina.core.ApplicationFilterChain.doFilter（ApplicationFilterChain.java:214）
 at org.apache.catalina.core.StandardWrapperValve.invoke（StandardWrapperValve.java:231）
 at org.apache.catalina.core.StandardContextValve.invoke（StandardContextValve.java:149）
在org .jboss.as.web.security.SecurityContextAssociationValve.invoke（SecurityContextAssociationValve.java:169）
 at org.apache.catalina.core.StandardHostValve.invoke（StandardHostValve.java:145）
 at org.apache .catalina.valves.ErrorReportValve.invoke（ErrorReportValve.java:97）
 at org.apache.catalina.core.StandardEngineValve.invoke（StandardEngineValve.java:102）
 at org.apache.catalina.connector .CoyoteAdapter.service（CoyoteAdapter.java:344）
 at org.apache.coyote.http11.Http11Processor.process（Http11Processor.java:856）
 at org.apache.coyote.http11.Http11Protocol $ Http11ConnectionHandler .process（Http11Protocol.java:653）
在org.apache.tomcat.util.net.JIoEndpoint $ Worker.run（JIoEndpoint.java:926）
在java.lang.Thread.run .java：745）
  

有没有人知道如何阻止这种情况发生 -

解决方案

p>这可能会延长记忆，但

一段时间

已经超过8小时？如果是，可能是 MySQL不活动超时，在28800秒后断开连接。我最近遇到这个问题，并发现了一些SO的问题 - this answer < a>包含了解决问题的最好的简单块。简而言之，建议添加 SELECT 并设置 testOnBorrow = true code>在DBCP连接池属性中。

When I don't make any database queries for some time I think it must sleep - if you then call it an exception is thrown;

java.sql.SQLNonTransientConnectionException: Could not read resultset: unexpected end of stream, read 0bytes from 4
        at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:136)
        at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106)
        at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:264)
        at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:288)
        at org.mariadb.jdbc.MySQLStatement.executeUpdate(MySQLStatement.java:317)
        at org.mariadb.jdbc.MySQLPreparedStatement.executeUpdate(MySQLPreparedStatement.java:156)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at com.swifte.database.DBFactory.updateTimeForUser(DBFactory.java:302)
        at com.swifte.database.DBFactory.addInsertToDB(DBFactory.java:275)
        at com.swifte.service.ExposedFunctions.login(ExposedFunctions.java:135)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:483)
        at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)
        at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
        at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
        at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
        at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524)
        at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126)
        at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
        at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
        at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
        at java.lang.Thread.run(Thread.java:745)

Does anyone know how to stop this from happening - I have tried adding the auto connect property to the URL but it still seems to occur

Thanks

解决方案

This may be stretching your memory but could

for some time

have been 8+ hours? If so, likely to be the MySQL inactivity timeout, which disconnects after 28800 seconds. I hit this problem recently and found a few SO questions about it - this answer contained the best simple nuggets for solving the problem. In short, would suggest adding a validationQuery of SELECT 1 and setting testOnBorrow = true in the DBCP connection pool properties.

这篇关于数据库睡眠并导致异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！