在系统运行过程中出现 Timeout waiting for idle object 这个错误
详细信息大概如下:
org.apache.catalina.core.StandardHostValve custom
SEVERE: Exception Processing ErrorPage[errorCode=404, location=/cms-errorhandler/handle404]
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.opencms.db.CmsDbSqlException: 读取“/system/handler/template/handlertemplate”路径下所有资源时出错。
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:491)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:555)
at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)
at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:829)
at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:512)
at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1052)
at org.opencms.main.OpenCmsServlet.openErrorHandler(OpenCmsServlet.java:320)
at org.opencms.main.OpenCmsServlet.handle(OpenCmsServlet.java:219)
at org.opencms.main.OpenCmsServlet.invokeHandler(OpenCmsServlet.java:272)
at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:150)
at org.opencms.main.OpenCmsServletErrorHandler.doGet(OpenCmsServletErrorHandler.java:82)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:438)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:421)
at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:342)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
Caused by: javax.servlet.ServletException: javax.servlet.jsp.JspException: org.opencms.db.CmsDbSqlException: 读取“/system/handler/template/handlertemplate”路径下所有资源时出错。
at org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
at org.apache.jsp.WEB_002dINF.jsp.online.system.handler.handle404_html_jsp._jspService(handle404_html_jsp.java:124)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
... 39 more
Caused by: org.opencms.db.CmsDbSqlException: 读取“/system/handler/template/handlertemplate”路径下所有资源时出错。
at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:117)
at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4035)
at org.opencms.file.CmsObject.readResource(CmsObject.java:3525)
at org.opencms.file.CmsObject.readResource(CmsObject.java:3492)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:217)
at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:166)
at org.opencms.jsp.CmsJspActionElement.include(CmsJspActionElement.java:510)
at org.opencms.jsp.CmsJspActionElement.include(CmsJspActionElement.java:534)
at org.opencms.jsp.util.CmsJspStatusBean.includeTemplatePart(CmsJspStatusBean.java:335)
at org.opencms.jsp.util.CmsJspStatusBean.includeTemplatePart(CmsJspStatusBean.java:312)
at org.apache.jsp.WEB_002dINF.jsp.online.system.handler.handle404_html_jsp._jspService(handle404_html_jsp.java:65)
... 42 more
Caused by: org.opencms.db.CmsDbSqlException: 执行下列查询时产生一个SQL错误。
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1956)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6524)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5854)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4033)
... 51 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error: Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1931)
... 54 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
... 59 more
很可能是由于连接池没有被释放导致不能进行新的请求
可能最后严重导致系统宕机
解决方案:
修改 opencms.properties 中
# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=grow