Hi Shaun, Thanks for the idea we will definitely try this steps.
Regards, Lewatle -----Original Message----- From: Shaun Donovan [mailto:[email protected]] Sent: 13 July 2015 04:42 PM To: Lewatle Phaladi; [email protected] Subject: Re: [Dspace-tech] FW: DSpace: Internal Server Error Hi Lewatle. Be careful when increasing the number of available database connections. Postgres should also be tuned when doing this. I am no expert at tuning postgres, but the following worked for me for large repositories. First, check the size of the database. You do this by using the du command on your postgres's data directory. On Red Hat, it is "du -sh /var/lib/pgsql/9.4/data/base". Once you have this, you need to make "shared buffers" a bit bigger than this in the postgres configuration file. Mine is set to 400M. My max connections in postgres is set to 150, and db.maxconnections is set to 100. These settings greatly affect the amount of memory used by postgres, so do not simply set them higher than necessary, as this will take memory away from tomcat. Another issue that I have found to cause this problem is the number of file handles available to tomcat. This should be adjusted according to your operating system, and configured in tomcat's startup scripts. On 13/07/2015 11:37, Lewatle Phaladi wrote: > ________________________________________ > Hi All, > > The following is the error message I am getting from dspace system. > > Regards, > Lewatle > > From: [email protected] [[email protected]] > Sent: Monday, July 13, 2015 10:21 AM > To: Lewatle Phaladi > Subject: DSpace: Internal Server Error > > An internal server error occurred on http://dspacedev.wits.ac.za: > > Date: 2015/07/13 10:21 AM > Session ID: C79D5CF194AF1E720BE0863AF3F3F60A > User: Anonymous > IP address: 123.125.71.29 > > -- URL Was: http://dspacedev.wits.ac.za/jspui/handle/10539/16266 > -- 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: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: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.rdf.negotiation.NegotiationFilter.doFilter(NegotiationFilter.java:50) > 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) > > > = > <table width="100%" border="0" cellspacing="0" cellpadding="0" > style="width:100%;"> <tr> <td align="left" > style="text-align:justify;"><font face="arial,sans-serif" size="1" > color="#999999"><span style="font-size:11px;">This communication is > intended for the addressee only. It is confidential. If you have > received this communication in error, please notify us immediately and > destroy the original message. You may not copy or disseminate this > communication without the permission of the University. Only > authorised signatories are competent to enter into agreements on > behalf of the University and recipients are thus advised that the > content of this message may not be legally binding on the University > and may contain the personal views and opinions of the author, which > are not necessarily the views and opinions of The University of the > Witwatersrand, Johannesburg. All agreements between the University and > outsiders are subject to South African Law unless the University > agrees in writing to the contrary. </span></font></td> </tr> </table > > > ---------------------------------------------------------------------- > -------- Don't Limit Your Business. Reach for the Cloud. > GigeNET's Cloud Solutions provide you with the tools and support that > you need to offload your IT needs and focus on growing your business. > Configured For All Businesses. Start Your Cloud Today. > https://www.gigenetcloud.com/ > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette <table width="100%" border="0" cellspacing="0" cellpadding="0" style="width:100%;"> <tr> <td align="left" style="text-align:justify;"><font face="arial,sans-serif" size="1" color="#999999"><span style="font-size:11px;">This communication is intended for the addressee only. It is confidential. If you have received this communication in error, please notify us immediately and destroy the original message. You may not copy or disseminate this communication without the permission of the University. Only authorised signatories are competent to enter into agreements on behalf of the University and recipients are thus advised that the content of this message may not be legally binding on the University and may contain the personal views and opinions of the author, which are not necessarily the views and opinions of The University of the Witwatersrand, Johannesburg. All agreements between the University and outsiders are subject to South African Law unless the University agrees in writing to the contrary. </span></font></td> </tr> </table ------------------------------------------------------------------------------ Don't Limit Your Business. Reach for the Cloud. GigeNET's Cloud Solutions provide you with the tools and support that you need to offload your IT needs and focus on growing your business. Configured For All Businesses. Start Your Cloud Today. https://www.gigenetcloud.com/ _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
