org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

Atlassian JIRA | Nithiyaa Ghanis [Atlassian] | 9 months ago
  1. 0

    h3. Summary Page Index macro in large space is bringing down Confluence h3. Environment * 6.0.0-OD-2016.08.1-0001 h3. Steps to Reproduce # Create a page in a large space (with > 2800 pages) # Insert _page index macro_ # It would take long to be generated. h3. Expected Results Confluence generates the index on the page the macro is inserted with no issues. h3. Actual Results Confluence keeps going down with this error: {noformat} 2016-02-22 12:29:53.789019500 Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) 2016-02-22 12:29:53.789025500 at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59) 2016-02-22 12:29:53.789025500 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292) 2016-02-22 12:29:53.789026500 ... 27 more 2016-02-22 12:29:53.789026500 Caused by: java.util.NoSuchElementException: Timeout waiting for idle object 2016-02-22 12:29:53.789028500 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1171) 2016-02-22 12:29:53.789028500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) 2016-02-22 12:29:53.789028500 ... 30 more {noformat} and {noformat} 2016-02-22 12:20:50.137789500 2016-02-22 12:20:50,060 DEBUG [http-bio-1991-exec-8] [atlassian.confluence.event.MonitorableCallerRunsPolicy] rejectedExecution Queue Overflow happened: QueueOverflowEvent{, runnableInfo='com.atlassian.confluence.event.ConfluenceEventDispatcher$$Lambda$390/16819635@1b8ac5a', threadPoolExecutorInfo='java.util.concurrent.ThreadPoolExecutor@a5ae24[Running, pool size = 1, active threads = 1, queued tasks = 192, completed tasks = 8656]'} {noformat} h3. Notes Error still happens even after the _pool size_ has been increased. h3.Workaround # Disable the *Advanced Macros* in Confluence # Remove the macro from the page that has the index macro.

    Atlassian JIRA | 9 months ago | Nithiyaa Ghanis [Atlassian]
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  2. 0

    h3. Summary Page Index macro in large space is bringing down Confluence h3. Environment * 6.0.0-OD-2016.08.1-0001, server 5.8.18 h3. Steps to Reproduce # Create a page in a large space (with > 2800 pages) # Insert _page index macro_ # It would take long to be generated. h3. Expected Results Confluence generates the index on the page the macro is inserted with no issues. h3. Actual Results Confluence keeps going down with this error: {noformat} 2016-02-22 12:29:53.789019500 Caused by: org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) 2016-02-22 12:29:53.789025500 at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59) 2016-02-22 12:29:53.789025500 at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292) 2016-02-22 12:29:53.789026500 ... 27 more 2016-02-22 12:29:53.789026500 Caused by: java.util.NoSuchElementException: Timeout waiting for idle object 2016-02-22 12:29:53.789028500 at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1171) 2016-02-22 12:29:53.789028500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) 2016-02-22 12:29:53.789028500 ... 30 more {noformat} and {noformat} 2016-02-22 12:20:50.137789500 2016-02-22 12:20:50,060 DEBUG [http-bio-1991-exec-8] [atlassian.confluence.event.MonitorableCallerRunsPolicy] rejectedExecution Queue Overflow happened: QueueOverflowEvent{, runnableInfo='com.atlassian.confluence.event.ConfluenceEventDispatcher$$Lambda$390/16819635@1b8ac5a', threadPoolExecutorInfo='java.util.concurrent.ThreadPoolExecutor@a5ae24[Running, pool size = 1, active threads = 1, queued tasks = 192, completed tasks = 8656]'} {noformat} h3. Notes Error still happens even after the _pool size_ has been increased. h4. Workaround 1 This is the Confluence Index Macro, which can be enabled/disabled via: # !https://s3.amazonaws.com/uploads.hipchat.com/10804/2041359/oZYNLidcDNI3S8o/Dashboard%20-%20Confluence%202015-05-13%2013-43-47.png! > *Add-ons* # Choose *System* from the drop-down # Expand *Advanced Macros* # Expand the *modules* on the right side # Locate the *index* macro and *Disable* it !disable_index_module.png|thumbnail! # Restart Confluence to release the existing threads h4. Workaround 2 # Search for: {{macroName:index}} and you will see all pages containing this macro. ** Note that your content indexing may need to be rebuilt for this search to work. # Delete the macro from the pages in the search results # Restart Confluence to release the existing threads If you prefer to search via the database for a list of pages, you can use this query: {code} SELECT c.contentid, s.spacekey, c.title, c.lastmoddate FROM CONTENT c JOIN BODYCONTENT bc ON c.contentid = bc.contentid JOIN SPACES s ON c.spaceid = s.spaceid WHERE c.prevver IS NULL AND bc.body LIKE '%ac:name="index"%'; {code}

    Atlassian JIRA | 9 months ago | Nithiyaa Ghanis [Atlassian]
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
  3. 0

    [Tomcat-users] Tomcat DBCP Connection pool issue - Grokbase

    grokbase.com | 1 year ago
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at indianads.getServicesTourDetail.doGet(getServicesTourDetail.java:106)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Tomcat - User - org.apache.tomcat.dbcp.dbcp.SQLNestedException : Cannot get a connection, pool error Timeout waiting for idle object

    nabble.com | 1 year ago
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, > > pool error Timeout waiting for idle object at > > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) at > > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
  6. 0

    Tomcat - User - org.apache.tomcat.dbcp.dbcp.SQLNestedException : Cannot get a connection, pool error Timeout waiting for idle object

    nabble.com | 1 year ago
    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, > pool error Timeout waiting for idle object at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) at > org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.tomcat.dbcp.dbcp.SQLNestedException

      Cannot get a connection, pool error Timeout waiting for idle object 2016-02-22 12:29:53.789021500 at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 2016-02-22 12:29:53.789024500 at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)

      at net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection()
    2. net.sf.hibernate
      BatcherImpl.openConnection
      1. net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
      2. net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
      2 frames