[opencms-dev] SQL Error ???

Olivier Camus olivier.camus at steria.com
Wed Nov 28 09:04:00 CET 2007


Thank's, the problem is solved.
In opencms.properties, set :

# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=block

To 

# action to take when the pool is exhausted {grow|block|fail}
db.pool.default.whenExhaustedAction=grow


Olivier
-------------- next part --------------
Hello Olivier,

On 11/27/07, Olivier Camus <olivier.camus at steria.com> wrote:
>
> Hi list!
>
> Is anybody has an idea of why the following error is raised ?
>
>
> 26 Nov 2007 22:53:46,033 ERROR [.opencms.db.CmsSecurityManager:2488] An
> SQL error occurred when executing the following query: .
>         ... 46 more
>         at org.apache.commons.dbcp.PoolingDriver.connect(
> PoolingDriver.java:176)
>         at
> org.apache.commons.pool.impl.GenericObjectPool.borrowObject(
> GenericObjectPool.java:825)
> Caused by: java.util.NoSuchElementException: Timeout waiting for idle
> object



It seems a database connection problem. Are you sure your database is up and
running? Can you connect to it from the command line use the same
credential?

Best

- RuiXian

        ... 41 more
>         at org.opencms.db.generic.CmsVfsDriver.readResource(
> CmsVfsDriver.java:1880)
>         at
> org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
>         at org.opencms.db.CmsSqlManager.getConnectionByUrl(
> CmsSqlManager.java:104)
>         at java.sql.DriverManager.getConnection(DriverManager.java:193)
>         at java.sql.DriverManager.getConnection(DriverManager.java:525)
>         at org.apache.commons.dbcp.PoolingDriver.connect(
> PoolingDriver.java:184)
> Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
> connection, pool error: Timeout waiting for idle object
>         ... 39 more
>         at
> org.opencms.db.generic.CmsUserDriver.getResourcesForOrganizationalUnit(
> CmsUserDriver.java:857)
>         at org.opencms.db.CmsDriverManager.readResource(
> CmsDriverManager.java:6370)
>         at org.opencms.db.generic.CmsVfsDriver.readResource(
> CmsVfsDriver.java:1897)
> Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when
> executing the following query: .
>         at java.lang.Thread.run(Thread.java:595)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:689)
>         at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:81)
>         at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:528)
>         at
>
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:665)
>         at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
>         at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java
> :151)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:108)
>         at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:544)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
> :117)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
> :137)
>         at
> org.apache.catalina.core.StandardHostValve.status(StandardHostValve.java
> :285)
>         at
> org.apache.catalina.core.StandardHostValve.custom(StandardHostValve.java
> :364)
>         at
> org.apache.catalina.core.ApplicationDispatcher.forward(
> ApplicationDispatcher.java:301)
>         at
> org.apache.catalina.core.ApplicationDispatcher.doForward(
> ApplicationDispatcher.java:403)
>         at
> org.apache.catalina.core.ApplicationDispatcher.processRequest(
> ApplicationDispatcher.java:471)
>         at
> org.apache.catalina.core.ApplicationDispatcher.invoke(
> ApplicationDispatcher.java:691)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:188)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:269)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
>         at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:183)
>         at
> org.opencms.main.OpenCmsServletErrorHandler.doGet(
> OpenCmsServletErrorHandler.java:81)
>         at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)
>         at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java
> :1487)
>         at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java
> :2064)
>         at
> org.opencms.main.OpenCmsCore.initCmsObjectFromSession(OpenCmsCore.java
> :895)
>         at org.opencms.main.OpenCmsCore.initCmsObject(OpenCmsCore.java
> :2013)
>         at org.opencms.i18n.CmsLocaleManager.getI18nInfo(
> CmsLocaleManager.java:767)
>         at
> org.opencms.i18n.CmsDefaultLocaleHandler.getI18nInfo(
> CmsDefaultLocaleHandler.java:103)
>         at org.opencms.file.CmsObject.readResource(CmsObject.java:3435)
>         at org.opencms.file.CmsObject.readResource(CmsObject.java:3468)
>         at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java
> :3960)
>         at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java
> :5765)
>         at
> org.opencms.db.CmsSecurityManager.checkPermissions(CmsSecurityManager.java
> :5337)
>         at
> org.opencms.db.CmsSecurityManager.hasPermissions(CmsSecurityManager.java
> :5585)
>         at
> org.opencms.security.CmsDefaultPermissionHandler.hasPermissions(
> CmsDefaultPermissionHandler.java:87)
>         at
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20071128/e7753425/attachment.html>
-------------- next part --------------

_______________________________________________
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