This happens occasionally in my DSpace, too. The database connection pool is full of connections (idle in transaction) and DSpace can't get a new one.
This should be fixed in code but it can be quite hard to find the leaks because it may require running DSpace for a long time. What you can do to resolve it is simply restart your database server when this happens. As an alternative, restarting DSpace would work, but the database server restarts much faster. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Thu, Feb 18, 2016 at 8:41 AM, Lewatle Johannes Phaladi <[email protected]> wrote: > Dear All, > > I am receiving the following messages from our dspace server, please share > with me steps to follow in resolving the following problem to keep on > happening. > > Regards, > Lewatle > > > > -----Original Message----- > Sent: 18 February 2016 09:35 AM > To: Lewatle Phaladi > Subject: DSpace: Internal Server Error > > > > An internal server error occurred on http://dspacesite: > > > > Date: 2016/02/18 9:35 AM > > Session ID: 537D048675BC829E0BC3B77A85791AF2 > > User: Anonymous > > IP address: 220.181.108.176 > > > > -- URL Was: > http://dspacesite/jspui/bitstream/10539/1567/3/03Selebi_Chapter1.pdf > > -- Method: GET > > -- Parameters were: > > > > > > Exception: > > org.postgresql.util.PSQLException: FATAL: remaining connection slots are > reserved for non-replication superuser connections > > at > org.postgresql.core.v3.ConnectionFactoryImpl.readStartupMessages(ConnectionFactoryImpl.java:471) > > at > org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:112) > > at > org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66) > > at > org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125) > > at > org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30) > > at > org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:22) > > at > org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:32) > > at > org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) > > at org.postgresql.Driver.makeConnection(Driver.java:393) > > at org.postgresql.Driver.connect(Driver.java:267) > > at > java.sql.DriverManager.getConnection(DriverManager.java:571) > > at > java.sql.DriverManager.getConnection(DriverManager.java:215) > > at > org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) > > at > org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) > > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974) > > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) > > at > org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.java:584) > > 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:98) > > 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:622) > > at > javax.servlet.http.HttpServlet.service(HttpServlet.java:729) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.dspace.utils.servlet.DSpaceWebappServletFilter.doFilter(DSpaceWebappServletFilter.java:78) > > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239) > > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) > > at > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106) > > at > org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502) > > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142) > > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) > > at > org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:617) > > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) > > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518) > > at > org.apache.coyote.ajp.AbstractAjpProcessor.process(AbstractAjpProcessor.java:844) > > at > org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:668) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1521) > > at > org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1478) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > > at > org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) > > at java.lang.Thread.run(Thread.java:745) > > > > > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-tech. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
