Hi Camilo, Could you provide us with more information about your setup? What version of PostgreSQL are you using? Are you using the XMLUI or JSPUI? Have you changed anything recently in your setup (e.g. upgraded Postgres, or maybe added a larger number of new Items) that could have affected this behavior?
It's difficult to narrow down the exact cause without a bit more information on your setup and any recent activities that might have affected your site. However, it is worth noting that the latest version of 5.x is now version 5.10, so 5.4 is a bit "old" for a 5.x release. There have been some performance fixes between 5.4 and 5.10 -- it's hard to say though if any could be what you are seeing. A few examples though include: * An XMLUI performance fix for Items with 100s of bitstreams attached: https://jira.duraspace.org/browse/DS-3883 * An update to the latest PostgreSQL driver (as old Postgres drivers could cause issues with a very new version of Postgres, like v10): https://jira.duraspace.org/browse/DS-3854 Additional bugs/performance issues that were fixed between 5.4 and 5.10 can be found in the 5.x Release Notes: https://wiki.duraspace.org/display/DSDOC5x/Release+Notes I'm not sure if this will help, but maybe it'll give you a few more clues on what to look at. If you can send more information to this mailing list it might help us to narrow down whether what you are seeing is a known bug (perhaps even one that has been fixed in a later 5.x release) or some sort of configuration issue, etc. Tim ________________________________ From: [email protected] <[email protected]> on behalf of Camilo Freire <[email protected]> Sent: Friday, August 23, 2019 1:42 PM To: [email protected] <[email protected]> Subject: [dspace-community] Fwd: dSpace cracks after some minutes Salud: since yesterday we are experimenting a serious problem with our dSpace installation (version 5.4). It seems that dspace has problems to perform the database queries which bring to the interface the bitstreams and logos (logos of collections are not shown, the same happens with bitstreams). After some minutes dspace interface shows an internal error message. This is the first time we experienced this problem after some years of running dSpace without any problem. When I list the processes related with dspace, a set of dspace-postgresql request idle processes is shown. The connection pool accepts up to 100 connections opened at the same time, but the list of idle dspace-postgres idle processes is not so big, it pills up to 10 processes around. It seems that the problems is related with the queries that bring the bitstreams because the tables locked by the idle processes are . bitstream bundle2bitstream bundle fileextension We tried to restart postgres, tomcat and the whole server but the problem persists. The log file shows this ERROR org.dspace.storage.rdbms.DatabaseManager @ SQL connection Error - 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:114) at org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:634) at org.dspace.core.Context.init(Context.java:121) at org.dspace.core.Context.<init>(Context.java:95) at org.dspace.app.webui.util.UIUtil.obtainContext(UIUtil.java:105) at org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.java:100) at org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:67) at javax.servlet.http.HttpServlet.service(HttpServlet.java:620) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.util.NoSuchElementException: Timeout waiting for idle object at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:958) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) ... 27 more Camilo Freire Biblioteca Nacional Uruguay -- 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 Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/CAMZv8nYgrk114GcjEeRLt3LhC_xSzWkvQfJMFtuUTkHf6La%3Dtg%40mail.gmail.com<https://groups.google.com/d/msgid/dspace-community/CAMZv8nYgrk114GcjEeRLt3LhC_xSzWkvQfJMFtuUTkHf6La%3Dtg%40mail.gmail.com?utm_medium=email&utm_source=footer>. -- 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 Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/DM5PR22MB0572C4EC4882CD389B0A7D33EDA10%40DM5PR22MB0572.namprd22.prod.outlook.com.
