I have been running DSpace 5.5 with Tomcat 7 and Postgresql 9 in production for more than five years. A few weeks ago, the site started displaying Internal Server Error. The errors were coming up quite often, every couple of hours or so, and were going away after a tomcat restart. The logs were showing "Cannot get a connection, pool error Timeout waiting for idle object". I enabled the DEBUG level for logging, and every time before the connection pool was exhausted, I noticed this in the logs:
2021-01-13 03:36:34,379 DEBUG org.dspace.google.GoogleRecorderEventListener @ Usage event received bitstream:view 2021-01-13 03:36:34,380 DEBUG org.apache.http.client.protocol.RequestAddCookies @ CookieSpec selected: best-match 2021-01-13 03:36:34,380 DEBUG org.apache.http.client.protocol.RequestAuthCache @ Auth cache not set in the context 2021-01-13 03:36:34,380 DEBUG *org.apache.http.impl.conn.PoolingHttpClientConnectionManager @ **Connection request: [route: {s}->https://www.google-analytics.com:443][total kept alive: 0; rout**e allocated: 2 of 2; total allocated: 2 of 20]* 2021-01-13 03:36:41,422 ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL connection Error - 2021-01-13 03:36:41,423 WARN org.dspace.app.webui.servlet.DSpaceServlet @ anonymous:no_context:database_error:org.apache.commons.dbcp.SQLNestedException\colon; Cannot get a connection, pool error Timeout waiting for idle object Any help would be much appreciated, Gabriela -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/d654dc18-490b-41b8-8c0d-0a32a80de6e4n%40googlegroups.com.