[opencms-dev] OpenCms crashes, Timeout waiting for idle object / Exception Processing ErrorPage
Marc Johnen
opencms at johnen.biz
Mon Feb 23 12:21:54 CET 2009
Thank you Achim, I did so now. But I'll also dig into the documentation
of dbpc, because I want to understan it :-P
Greetings
Marc
Achim Westermann wrote:
>
> Hi Marc,
>
> you should comment that query in in case your users complain that every
> morning they have problems logging in and you find something like
> "broken pipe" in the opencms.log. Than you should enable eviction. You
> don't have to understand the SQL query. It will work anyway ;-)
>
> Kind Regards,
> Achim.
>
> -------------------
> Achim Westermann
>
> Alkacon Software GmbH - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
>
>
>
> Marc Johnen wrote:
>> Hello Achim,
>>
>> thank you for your fast answer!
>> I set the property to "grow" yesterday and so far, at least, had no new
>> crash.
>> I'm not familiar with commons-dbpc, I'm afraid, and could not find any
>> information
>> on the test query. Do you mean I should comment in the following line?
>> #db.pool.default.testQuery=SELECT STRUCTURE_ID FROM CMS_OFFLINE_STRUCTURE
>> WHERE RESOURCE_PATH = '/'
>> I understand that it's the validation query, testing whether a connection
>> should be evicted or not, but I don't understand it's syntax.
>>
>> Thank you and greetings
>> Marc Johnen
>>
>>
>>
>> Achim Westermann wrote:
>>
>>> Hi Marc,
>>>
>>> try to set the option:
>>>
>>> # action to take when the pool is exhausted {grow|block|fail}
>>> db.pool.default.whenExhaustedAction=block
>>>
>>> from "block" to "grow".
>>>
>>> I assume there is some potential deadlock - code in commons-dbpc when
>>> that option is set to "block".
>>>
>>> also try to turn on eviction by commenting in the test query in that
>>> file.
>>>
>>> Kind Regards,
>>> Achim.
>>>
>>> -------------------
>>> Achim Westermann
>>>
>>> Alkacon Software GmbH - The OpenCms Experts
>>> http://www.alkacon.com - http://www.opencms.org
>>>
>>>
>>> Marc Johnen schrieb:
>>>
>>>> For a while now OpenCms keeps crashing every day. What happens is that
>>>> the
>>>> maximum number of connections
>>>> is reached (db.pool.default.maxActive) and then no further connections
>>>> are
>>>> possible. I get a lot of
>>>> NoSuchElementException from all directions (see bottom for one
>>>> example).
>>>> After a restart everything works fine again
>>>> for a while. The connections are all to the opencms-database and are
>>>> not
>>>> coming from my code, I'm certain.
>>>> The load of the page is not overwhelmingly high.
>>>>
>>>> Configuration: Debian 4.0, MySql 5.0.51a, Apache 2.2.3, Tomcat 6.0.18.
>>>>
>>>> There is only one noticable Error occuring (you can find the message
>>>> below)
>>>> which still should not lead to the rising of connections, I think.
>>>>
>>>> Can anyone help me?
>>>> Thank you and greetings
>>>> Marc Johnen
>>>>
>>>>
>>>> 18.02.2009 17:40:52 org.apache.catalina.core.StandardHostValve custom
>>>> SEVERE: Exception Processing ErrorPage[errorCode=404,
>>>> location=/opencms/handle404]
>>>> org.apache.jasper.JasperException:
>>>> java.lang.ArrayIndexOutOfBoundsException:
>>>> -1
>>>> at
>>>> org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:522)
>>>> at
>>>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
>>>> at
>>>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
>>>> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
>>>> 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:630)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535)
>>>> at
>>>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472)
>>>> 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:1193)
>>>> 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:1227)
>>>> at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:1171)
>>>> at
>>>> org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:964)
>>>> at
>>>> org.opencms.main.OpenCmsServlet.openErrorHandler(OpenCmsServlet.java:317)
>>>> at org.opencms.main.OpenCmsServlet.handle(OpenCmsServlet.java:214)
>>>> at
>>>> org.opencms.main.OpenCmsServlet.invokeHandler(OpenCmsServlet.java:269)
>>>> at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:149)
>>>> 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:630)
>>>> 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:424)
>>>> at
>>>> org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java:343)
>>>> at
>>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:144)
>>>> 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:286)
>>>> at
>>>> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
>>>> at
>>>> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
>>>> at
>>>> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
>>>> at java.lang.Thread.run(Thread.java:619)
>>>> Caused by: java.lang.ArrayIndexOutOfBoundsException: -1
>>>> at
>>>> org.opencms.loader.CmsResourceManager.getLoader(CmsResourceManager.java:605)
>>>> at
>>>> org.opencms.loader.CmsResourceManager.getLoader(CmsResourceManager.java:594)
>>>> at
>>>> org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:403)
>>>> at
>>>> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
>>>> at
>>>> org.opencms.jsp.CmsJspTagInclude.includeActionWithCache(CmsJspTagInclude.java:364)
>>>> at
>>>> org.opencms.jsp.CmsJspTagInclude.includeTagAction(CmsJspTagInclude.java:241)
>>>> at
>>>> org.opencms.jsp.CmsJspTagInclude.doEndTag(CmsJspTagInclude.java:472)
>>>> at
>>>> org.apache.jsp.WEB_002dINF.jsp.online.system.modules.mysite.templates.standard_jsp._jspx_meth_cms_005finclude_005f0(standard_jsp.java:318)
>>>> at
>>>> org.apache.jsp.WEB_002dINF.jsp.online.system.modules.mysite.templates.standard_jsp._jspService(standard_jsp.java:215)
>>>> 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:374)
>>>> ... 38 more
>>>>
>>>> [..]
>>>>
>>>> 17.02.2009 12:21:18 org.apache.catalina.core.ApplicationDispatcher
>>>> invoke
>>>> SEVERE: 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:756)
>>>> at
>>>> org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
>>>> 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:1963)
>>>> at
>>>> org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6542)
>>>> at
>>>> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5850)
>>>> at
>>>> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:4035)
>>>> at org.opencms.file.CmsObject.readResource(CmsObject.java:3488)
>>>> at org.opencms.file.CmsObject.readResource(CmsObject.java:3455)
>>>> 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)
>>>> [...]
>>>>
>>> _______________________________________________
>>> This mail is sent to you from the opencms-dev mailing list
>>> To change your list options, or to unsubscribe from the list, please
>>> visit
>>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>>
>>>
>>>
>>
>>
>
>
> --
> Mailing list:
>
> Kind Regards,
> Achim.
>
> -------------------
> Achim Westermann
>
> Alkacon Software GmbH - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
>
>
> Gute Kunden:
>
> Achim Westermann
>
> -------------------
>
> Alkacon Software GmbH - The OpenCms Experts
> Achim Westermann
> An der Wachsfabrik 13
> 50996 Koeln, DE
>
> Tel: +49 (0)2236 3826-12
> Fax: +49 (0)2236 3826-20
> Email: a.westermann at alkacon.com
>
> http://www.alkacon.com
> http://www.opencms.org
> http://www.opencms-days.org
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
--
View this message in context: http://www.nabble.com/OpenCms-crashes%2C--Timeout-waiting-for-idle-object---Exception-Processing-ErrorPage-tp22084066p22159713.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
More information about the opencms-dev
mailing list