[opencms-dev] OpenCms crashes, Timeout waiting for idle object / Exception Processing ErrorPage
a.westermann at alkacon.com
a.westermann at alkacon.com
Mon Feb 23 17:34:08 CET 2009
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
>>
>>
>>
>
>
More information about the opencms-dev
mailing list