[Building Sakai] Cannot get a connection, pool error Timeout waiting for idle object
Jehan
jeehaaan at gmail.com
Tue Jan 3 02:11:50 PST 2012
Dear all
I have developed a simple tool in sakai using JSP, through which I am
executing database queries.
I am getting Connection object using dataSource.getConnection();
but after executing 5,6, queries sakai stucks,
following is log, why I am facing that problem.
I am using sakai 2.8.0
MySql database
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at Sprang.Staff.WS.getConnection(WS.java:264)
at Sprang.Staff.WS.executeUpdate(WS.java:162)
at org.apache.jsp.SynchRights1_jsp._jspService(SynchRights1_jsp.java:92)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at
uk.ac.cam.caret.sakai.WebappToolServlet.service(WebappToolServlet.java:56)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:598)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:359)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at
org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:511)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1429)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:204)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 49 more
connection is null, get connection object2012-01-03 14:46:49,550 WARN
org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$d41c5418
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,CONTEXT,SESSION_SERVER
from SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSION_ID =
SAKAI_SESSION.SESSION_ID) and (EVENT_ID > ?) 1098
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:609)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:47:01,762 WARN http-8080-2
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED
from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID =
SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = ? and
SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and
SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by
SAKAI_SITE.TITLE ASC admin
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.util.BaseDbFlatStorage.getSelectedResources(BaseDbFlatStorage.java:470)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.getSites(DbSiteService.java:803)
at
org.sakaiproject.site.impl.BaseSiteService.getSites(BaseSiteService.java:1623)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getAllSites(SiteNeighbourhoodServiceImpl.java:128)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSitesAtNode(SiteNeighbourhoodServiceImpl.java:96)
at
org.sakaiproject.portal.charon.site.AbstractSiteViewImpl.<init>(AbstractSiteViewImpl.java:95)
at
org.sakaiproject.portal.charon.site.DefaultSiteViewImpl.<init>(DefaultSiteViewImpl.java:61)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSitesView(PortalSiteHelperImpl.java:1166)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeTabs(SiteHandler.java:586)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeSiteNav(SiteHandler.java:374)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:238)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:117)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 34 more
2012-01-03 14:47:09,227 ERROR
QuartzScheduler_QuartzScheduler-localhost_MisfireHandler
org.quartz.impl.jdbcjobstore.JobStoreTX - MisfireHandler: Error handling
misfires: Failed to obtain DB connection from data source 'myDS':
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
org.quartz.JobPersistenceException: Failed to obtain DB connection from
data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Cannot get
a connection, pool error Timeout waiting for idle object [See nested
exception: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:689)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3108)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3874)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3894)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.component.app.scheduler.ConnectionProviderDelegate.getConnection(ConnectionProviderDelegate.java:53)
at
org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:686)
... 4 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 8 more
2012-01-03 14:47:13,651 ERROR QuartzScheduler_QuartzSchedulerThread
org.quartz.core.ErrorLogger - An error occured while scanning for the next
trigger to fire.
org.quartz.JobPersistenceException: Failed to obtain DB connection from
data source 'myDS': org.apache.commons.dbcp.SQLNestedException: Cannot get
a connection, pool error Timeout waiting for idle object [See nested
exception: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object]
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:689)
at
org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3744)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2729)
at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:266)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.component.app.scheduler.ConnectionProviderDelegate.getConnection(ConnectionProviderDelegate.java:53)
at
org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
at
org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:686)
... 4 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 8 more
2012-01-03 14:47:19,373 WARN SakaiPresenceService.Maintenance
org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 0
sql: delete from SAKAI_PRESENCE where ( SESSION_ID = ? and LOCATION_ID = ?)
binds: ec0cdd07-17b3-4f88-8cc0-888ecce0e25d
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1200)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1122)
at
org.sakaiproject.presence.impl.ClusterPresenceService$ClusterStorage.removePresence(ClusterPresenceService.java:144)
at
org.sakaiproject.presence.impl.BasePresenceService$Presence.valueUnbound(BasePresenceService.java:681)
at
org.sakaiproject.tool.impl.MyLittleSession.unBind(MyLittleSession.java:331)
at
org.sakaiproject.tool.impl.MyLittleSession.removeAttribute(MyLittleSession.java:254)
at
org.sakaiproject.presence.impl.BasePresenceService.checkAllPresenceForExpiration(BasePresenceService.java:553)
at
org.sakaiproject.presence.impl.BasePresenceService$Maintenance.run(BasePresenceService.java:778)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 11 more
2012-01-03 14:47:19,373 WARN SakaiPresenceService.Maintenance
org.sakaiproject.presence.impl.BasePresenceService - exception checking for
expired presence:
java.lang.RuntimeException: SqlService.dbWrite failure
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1267)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1122)
at
org.sakaiproject.presence.impl.ClusterPresenceService$ClusterStorage.removePresence(ClusterPresenceService.java:144)
at
org.sakaiproject.presence.impl.BasePresenceService$Presence.valueUnbound(BasePresenceService.java:681)
at
org.sakaiproject.tool.impl.MyLittleSession.unBind(MyLittleSession.java:331)
at
org.sakaiproject.tool.impl.MyLittleSession.removeAttribute(MyLittleSession.java:254)
at
org.sakaiproject.presence.impl.BasePresenceService.checkAllPresenceForExpiration(BasePresenceService.java:553)
at
org.sakaiproject.presence.impl.BasePresenceService$Maintenance.run(BasePresenceService.java:778)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1200)
... 8 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 11 more
2012-01-03 14:47:20,531 WARN http-8080-5
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_ALIAS.ALIAS_ID,SAKAI_ALIAS.TARGET,SAKAI_ALIAS.CREATEDBY,SAKAI_ALIAS.MODIFIEDBY,SAKAI_ALIAS.CREATEDON,SAKAI_ALIAS.MODIFIEDON
from SAKAI_ALIAS where ( ALIAS_ID = ? ) null
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:340)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:320)
at
org.sakaiproject.alias.impl.DbAliasService$DbStorage.get(DbAliasService.java:234)
at
org.sakaiproject.alias.impl.BaseAliasService.getTarget(BaseAliasService.java:587)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.parseSiteAlias(SiteNeighbourhoodServiceImpl.java:584)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSiteVisit(PortalSiteHelperImpl.java:946)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.includePortal(SkinnableCharonPortal.java:450)
at
org.sakaiproject.portal.charon.handlers.TimeoutDialogHandler.doGet(TimeoutDialogHandler.java:103)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 29 more
2012-01-03 14:47:34,473 WARN SakaiClusterService.Maintenance
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SERVER_ID from SAKAI_CLUSTER where SERVER_ID = ? localhost-1325583468559
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.cluster.impl.SakaiClusterService$Maintenance.run(SakaiClusterService.java:377)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:47:34,473 WARN SakaiClusterService.Maintenance
org.sakaiproject.cluster.impl.SakaiClusterService - run(): server has been
closed in cluster table, reopened: localhost-1325583468559
2012-01-03 14:49:14,170 WARN Timer-1
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select XML from
SAKAI_DIGEST
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:449)
at
org.sakaiproject.util.BaseDbSingleStorage.getAllResources(BaseDbSingleStorage.java:334)
at
org.sakaiproject.email.impl.DbDigestService$DbStorage.getAll(DbDigestService.java:177)
at
org.sakaiproject.email.impl.BaseDigestService.getDigests(BaseDigestService.java:717)
at
org.sakaiproject.email.impl.BaseDigestService.sendDigests(BaseDigestService.java:290)
at
org.sakaiproject.email.impl.BaseDigestService$DigestTimerTask.run(BaseDigestService.java:670)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 12 more
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at Sprang.Staff.WS.execute(WS.java:196)
at Sprang.Staff.WS.executeUpdate(WS.java:162)
at org.apache.jsp.SynchRights1_jsp._jspService(SynchRights1_jsp.java:92)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:369)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:308)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:259)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:395)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at
uk.ac.cam.caret.sakai.WebappToolServlet.service(WebappToolServlet.java:56)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:598)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:659)
at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:457)
at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:359)
at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:311)
at
org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:511)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1429)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:204)
at
org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 49 more
2012-01-03 14:51:54,552 WARN
org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$d41c5418
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,CONTEXT,SESSION_SERVER
from SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSION_ID =
SAKAI_SESSION.SESSION_ID) and (EVENT_ID > ?) 1098
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:609)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:52:01,763 WARN http-8080-2
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED
from SAKAI_SITE where ( SITE_ID = ? ) ~admin
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:340)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:320)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.get(DbSiteService.java:234)
at
org.sakaiproject.site.impl.BaseSiteService.getDefinedSite(BaseSiteService.java:586)
at
org.sakaiproject.site.impl.BaseSiteService.getSite(BaseSiteService.java:672)
at
org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:750)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSiteVisit(SiteNeighbourhoodServiceImpl.java:440)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getMyWorkspace(SiteNeighbourhoodServiceImpl.java:361)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getAllSites(SiteNeighbourhoodServiceImpl.java:167)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSitesAtNode(SiteNeighbourhoodServiceImpl.java:96)
at
org.sakaiproject.portal.charon.site.AbstractSiteViewImpl.<init>(AbstractSiteViewImpl.java:95)
at
org.sakaiproject.portal.charon.site.DefaultSiteViewImpl.<init>(DefaultSiteViewImpl.java:61)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSitesView(PortalSiteHelperImpl.java:1166)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeTabs(SiteHandler.java:586)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeSiteNav(SiteHandler.java:374)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:238)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:117)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 38 more
2012-01-03 14:52:20,538 WARN http-8080-5
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED
from SAKAI_SITE,SAKAI_SITE_USER where SAKAI_SITE.SITE_ID =
SAKAI_SITE_USER.SITE_ID and SAKAI_SITE_USER.USER_ID = ? and
SAKAI_SITE.IS_USER = '0' and SAKAI_SITE.IS_SPECIAL = '0' and
SAKAI_SITE_USER.PERMISSION <= SAKAI_SITE.PUBLISHED order by
SAKAI_SITE.TITLE ASC admin
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.util.BaseDbFlatStorage.getSelectedResources(BaseDbFlatStorage.java:470)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.getSites(DbSiteService.java:803)
at
org.sakaiproject.site.impl.BaseSiteService.getSites(BaseSiteService.java:1623)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getAllSites(SiteNeighbourhoodServiceImpl.java:128)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSitesAtNode(SiteNeighbourhoodServiceImpl.java:96)
at
org.sakaiproject.portal.charon.site.AbstractSiteViewImpl.<init>(AbstractSiteViewImpl.java:95)
at
org.sakaiproject.portal.charon.site.AllSitesViewImpl.<init>(AllSitesViewImpl.java:45)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSitesView(PortalSiteHelperImpl.java:1162)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.includePortal(SkinnableCharonPortal.java:547)
at
org.sakaiproject.portal.charon.handlers.TimeoutDialogHandler.doGet(TimeoutDialogHandler.java:103)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 32 more
2012-01-03 14:52:34,473 WARN SakaiClusterService.Maintenance
org.sakaiproject.db.impl.BasicSqlService - Sql.dbWrite(): error code: 0
sql: insert into SAKAI_CLUSTER (SERVER_ID,UPDATE_TIME) values (?,
CURRENT_TIMESTAMP()) binds: localhost-1325583468559
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1200)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1059)
at
org.sakaiproject.cluster.impl.SakaiClusterService$Maintenance.run(SakaiClusterService.java:384)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:52:34,475 WARN SakaiClusterService.Maintenance
org.sakaiproject.cluster.impl.SakaiClusterService - exception:
java.lang.RuntimeException: SqlService.dbWrite failure
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1267)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1059)
at
org.sakaiproject.cluster.impl.SakaiClusterService$Maintenance.run(SakaiClusterService.java:384)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at
org.sakaiproject.db.impl.BasicSqlService.dbWrite(BasicSqlService.java:1200)
... 3 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:56:59,554 WARN
org.sakaiproject.event.impl.ClusterEventTracking$$EnhancerByCGLIB$$d41c5418
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
EVENT_ID,EVENT_DATE,EVENT,REF,SAKAI_EVENT.SESSION_ID,EVENT_CODE,CONTEXT,SESSION_SERVER
from SAKAI_EVENT,SAKAI_SESSION where (SAKAI_EVENT.SESSION_ID =
SAKAI_SESSION.SESSION_ID) and (EVENT_ID > ?) 1098
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.event.impl.ClusterEventTracking.run(ClusterEventTracking.java:609)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:57:01,765 WARN http-8080-2
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_USER.USER_ID,SAKAI_USER.EMAIL,SAKAI_USER.EMAIL_LC,SAKAI_USER.FIRST_NAME,SAKAI_USER.LAST_NAME,SAKAI_USER.TYPE,
SAKAI_USER.PW,SAKAI_USER.CREATEDBY,SAKAI_USER.MODIFIEDBY,SAKAI_USER.CREATEDON,SAKAI_USER.MODIFIEDON
from SAKAI_USER where ( USER_ID = ? ) admin
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:340)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:320)
at
org.sakaiproject.user.impl.DbUserService$DbStorage.getById(DbUserService.java:254)
at
org.sakaiproject.user.impl.BaseUserDirectoryService.getUser(BaseUserDirectoryService.java:700)
at
org.sakaiproject.site.impl.BaseSiteService.getSite(BaseSiteService.java:683)
at
org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:750)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSiteVisit(SiteNeighbourhoodServiceImpl.java:440)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getMyWorkspace(SiteNeighbourhoodServiceImpl.java:361)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getAllSites(SiteNeighbourhoodServiceImpl.java:167)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSitesAtNode(SiteNeighbourhoodServiceImpl.java:96)
at
org.sakaiproject.portal.charon.site.AbstractSiteViewImpl.<init>(AbstractSiteViewImpl.java:95)
at
org.sakaiproject.portal.charon.site.DefaultSiteViewImpl.<init>(DefaultSiteViewImpl.java:61)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSitesView(PortalSiteHelperImpl.java:1166)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeTabs(SiteHandler.java:586)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.includeSiteNav(SiteHandler.java:374)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doSite(SiteHandler.java:238)
at
org.sakaiproject.portal.charon.handlers.SiteHandler.doGet(SiteHandler.java:117)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 38 more
2012-01-03 14:57:20,539 WARN http-8080-5
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SAKAI_SITE.SITE_ID,SAKAI_SITE.TITLE,SAKAI_SITE.TYPE,SAKAI_SITE.SHORT_DESC,SAKAI_SITE.DESCRIPTION,SAKAI_SITE.ICON_URL,SAKAI_SITE.INFO_URL,SAKAI_SITE.SKIN,SAKAI_SITE.PUBLISHED,SAKAI_SITE.JOINABLE,SAKAI_SITE.PUBVIEW,SAKAI_SITE.JOIN_ROLE,SAKAI_SITE.IS_SPECIAL,SAKAI_SITE.IS_USER,SAKAI_SITE.CREATEDBY,SAKAI_SITE.MODIFIEDBY,SAKAI_SITE.CREATEDON,SAKAI_SITE.MODIFIEDON,SAKAI_SITE.CUSTOM_PAGE_ORDERED
from SAKAI_SITE where ( SITE_ID = ? ) ~admin
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:340)
at
org.sakaiproject.util.BaseDbFlatStorage.getResource(BaseDbFlatStorage.java:320)
at
org.sakaiproject.site.impl.DbSiteService$DbStorage.get(DbSiteService.java:234)
at
org.sakaiproject.site.impl.BaseSiteService.getDefinedSite(BaseSiteService.java:586)
at
org.sakaiproject.site.impl.BaseSiteService.getSite(BaseSiteService.java:672)
at
org.sakaiproject.site.impl.BaseSiteService.getSiteVisit(BaseSiteService.java:750)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSiteVisit(SiteNeighbourhoodServiceImpl.java:440)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getMyWorkspace(SiteNeighbourhoodServiceImpl.java:361)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getAllSites(SiteNeighbourhoodServiceImpl.java:167)
at
org.sakaiproject.portal.service.SiteNeighbourhoodServiceImpl.getSitesAtNode(SiteNeighbourhoodServiceImpl.java:96)
at
org.sakaiproject.portal.charon.site.AbstractSiteViewImpl.<init>(AbstractSiteViewImpl.java:95)
at
org.sakaiproject.portal.charon.site.AllSitesViewImpl.<init>(AllSitesViewImpl.java:45)
at
org.sakaiproject.portal.charon.site.PortalSiteHelperImpl.getSitesView(PortalSiteHelperImpl.java:1162)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.includePortal(SkinnableCharonPortal.java:547)
at
org.sakaiproject.portal.charon.handlers.TimeoutDialogHandler.doGet(TimeoutDialogHandler.java:103)
at
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:862)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:659)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
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:174)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:843)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:679)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1293)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 36 more
2012-01-03 14:58:34,476 WARN SakaiClusterService.Maintenance
org.sakaiproject.db.impl.BasicSqlService - Sql.dbRead: sql: select
SERVER_ID from SAKAI_CLUSTER where SERVER_ID = ? localhost-1325583468559
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool
error Timeout waiting for idle object
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at
org.sakaiproject.db.impl.BasicSqlService.borrowConnection(BasicSqlService.java:260)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:540)
at org.sakaiproject.db.impl.BasicSqlService.dbRead(BasicSqlService.java:471)
at
org.sakaiproject.cluster.impl.SakaiClusterService$Maintenance.run(SakaiClusterService.java:377)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134)
at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
... 6 more
2012-01-03 14:58:34,476 WARN SakaiClusterService.Maintenance
org.sakaiproject.cluster.impl.SakaiClusterService - run(): server has been
closed in cluster table, reopened: localhost-1325583468559
2012-01-03 15:01:32,393 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.apache.catalina.startup.HostConfig - Undeploying context
[/jb_group_manager]
2012-01-03 15:01:32,416 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jb_group_manager]
- Closing Spring root WebApplicationContext
2012-01-03 15:01:32,417 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.sakaiproject.util.ContextLoaderListener - Destroying Components in
slate-jbgroupmanager
2012-01-03 15:01:32,502 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.apache.catalina.startup.HostConfig - Deploying web application archive
jb_group_manager.war
2012-01-03 15:01:33,330 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.sakaiproject.util.ToolListener - registering tools from resource:
/tools/slate.jbgroupmanager.xml
2012-01-03 15:01:33,335 INFO
ContainerBackgroundProcessor[StandardEngine[Catalina]]
org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jb_group_manager]
- Initializing Spring root WebApplicationContext
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120103/a625a123/attachment.html
More information about the sakai-dev
mailing list