Timeout waiting for idle object

在系統運行過程中出現 Timeout waiting for idle object 這個錯誤

詳細資料大概如下:

org.apache.catalina.core.StandardHostValve customSEVERE: 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 moreCaused 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 moreCaused 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 moreCaused 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 moreCaused 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