[opencms-dev] OpenCms crashes, Timeout waiting for idle object / Exception Processing ErrorPage
Marc Johnen
opencms at johnen.biz
Thu Feb 26 15:00:44 CET 2009
I see, thanks again. Just to give you some feedback:
I implemented your suggestions and OpenCms has
been running stable for a week now.
Greetings
Marc Johnen
Achim Westermann wrote:
>
> Hi Marc,
>
> you are welcome.
> But save your time: The validation query syntax is not dbpc - specific.
> It is a (minimalistic) SQL Query that has been set up by us. It just
> accesses an OpenCms - specific table.
>
> Kind Regards,
>
> Achim.
>
> -------------------
> Achim Westermann
>
> Alkacon Software GmbH - The OpenCms Experts
> http://www.alkacon.com - http://www.opencms.org
>
>
>
>
>
> Marc Johnen wrote:
>> 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
>>>
>>>
>>>
>>
>>
>
>
>
> _______________________________________________
> 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-tp22084066p22224718.html
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
More information about the opencms-dev
mailing list