[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