[opencms-dev] Cannot get a connection, pool error: Timeout waiting for idle object

[Lori Boes]

Hello,

All of a sudden in our opencms (7.0.1), our users weren't able to login.
Below is the error in the log file. Can anyone shed some light on why this
may have occurred? It looks like maybe opencms couldn't connect to mysql?
Thanks for any help.

 

-Lori

 

Here's the error from the log file

 

13 Mar 2008 09:24:54,728 ERROR [rg.opencms.jsp.CmsJspLoginBean: 290] Failed
login of user "user1": A database error occured reading the user data.
Request from IP  using uri "/sites/default/index.jsp".

org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: . 

      at
org.opencms.db.generic.CmsUserDriver.readUserInfos(CmsUserDriver.java:1480)

      at
org.opencms.db.generic.CmsUserDriver.internalCreateUser(CmsUserDriver.java:2
309)

      at
org.opencms.db.generic.CmsUserDriver.readUser(CmsUserDriver.java:1414)

      at
org.opencms.db.CmsDriverManager.loginUser(CmsDriverManager.java:4586)

      at
org.opencms.db.CmsSecurityManager.loginUser(CmsSecurityManager.java:2845)

      at org.opencms.file.CmsObject.loginUser(CmsObject.java:2234)

      at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:189)

      at org.opencms.jsp.CmsJspLoginBean.login(CmsJspLoginBean.java:169)

      at
org.apache.jsp.WEB_002dINF.jsp.online.sites.default_.index_jsp._jspService(i
ndex_jsp.java:89)

      at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

      at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:3
28)

      at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)

      at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)

      at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.
java:691)

      at
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatch
er.java:594)

      at
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher
.java:505)

      at
org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDisp
atcher.java:193)

      at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.j
ava:169)

      at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:996)

      at
org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRe
questDispatcher.java:422)

      at
org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.j
ava:173)

      at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:233)

      at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:575)

      at
org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:9
38)

      at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1485)

      at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:171)

      at org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:183)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

      at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)

      at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)

      at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:210)

      at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)

      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:151)

      at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)

      at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processC
onnection(Http11BaseProtocol.java:665)

      at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.jav
a:528)

      at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWo
rkerThread.java:81)

      at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:685)

      at java.lang.Thread.run(Thread.java:595)

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:525)

      at java.sql.DriverManager.getConnection(DriverManager.java:193)

      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:1452)

      ... 46 more

Caused by: java.util.NoSuchElementException: Timeout waiting for idle object

      at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPoo
l.java:825)

      at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)

      ... 51 more

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20080313/033a4c37/attachment.htm>