[opencms-dev] Timeout waiting for idle object

Paul-Inge Flakstad flakstad at npolar.no
Tue Mar 9 14:20:37 CET 2010


Hi all

One of our production system routinely crashes every 10 days or so. The error seems to be related to OpenCms' communication with MySQL, one exception is "SQLNestedException: Cannot get a connection, pool error: Timeout waiting for idle object" - see below for a full stack trace. I'm not sure what action(s) to take in order to prevent this - I'm not even sure if it's a bug or a config issue (?).

(I found a previous thread describing the same problem [http://mail.opencms.org/pipermail/opencms-dev/2009q4/033319.html] but whether the given fix could itself become a problem over time is a question left unanswered.)

Any help will be appreciated.

Thanks,
Paul

---
System info: OpenCms 7.5.1 release / Tomcat 5.5 with Apache 2.2 in front / MySQL 5.0.77

Snippet from opencms.log:

09 Mar 2010 12:22:04,074 ERROR [ina.core.ApplicationDispatcher: 711] Servlet.service() for servlet jsp threw exception
java.util.NoSuchElementException: Timeout waiting for idle object
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
        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)
        at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6462)
        at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5854)
        at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4033)
        at org.opencms.file.CmsObject.readResource(CmsObject.java:3525)
        at org.opencms.file.CmsObject.readResource(CmsObject.java:3492)
        at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:157)
        at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:364)
        at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:241)
        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:54)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
        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:627)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

09 Mar 2010 12:22:04,075 ERROR [ina.core.ApplicationDispatcher: 711] Servlet.service() for servlet OpenCmsServletErrorHandler threw exception
java.util.NoSuchElementException: Timeout waiting for idle object
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
        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)
        at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6462)
        at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5854)
        at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4033)
 at org.opencms.file.CmsObject.readResource(CmsObject.java:3525)
        at org.opencms.file.CmsObject.readResource(CmsObject.java:3492)
        at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:157)
        at org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:364)
        at org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:241)
        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:54)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
        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:627)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
        at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
        at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399)
        at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
        at org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java:364)
        at org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:285)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)

09 Mar 2010 12:25:32,734 ERROR [rg.opencms.jsp.CmsJspLoginBean: 287] Failed login of user "OU_OUNAME/username": A database error occurred reading the user data. Request from IP ***.***.***.*** using uri "/system/login/index.html".
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
        at org.opencms.db.generic.CmsUserDriver.readUserInfos(CmsUserDriver.java:1485)
        at org.opencms.db.generic.CmsUserDriver.internalCreateUser(CmsUserDriver.java:2323)
        at org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:1409)
        at org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4700)
        at org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4733)
        at org.opencms.db.CmsSecurityManager.loginUser(CmsSecurityManager.java:2883)
        at org.opencms.file.CmsObject.loginUser(CmsObject.java:2263)
        at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:189)
        at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:169)
        at org.opencms.workplace.CmsLogin.displayDialog(CmsLogin.java:293)
        at org.apache.jsp.WEB_002dINF.jsp.online.system.login.index_html_jsp._jspService(index_html_jsp.java:48)
        at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
        at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
        at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
        at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
        at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
        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.OpenCmsCore.showResource(OpenCmsCore.java:1489)
        at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
        at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
        at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
        at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
        at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
        at java.lang.Thread.run(Thread.java:619)
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.CmsUserDriver.readUserInfos(CmsUserDriver.java:1445)
        ... 49 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
        at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958)
        at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
        ... 54 more
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100309/9972dc82/attachment.htm>


More information about the opencms-dev mailing list