Hi Lewatle,
Here are the tweaks we use:
http://wiki.lib.sun.ac.za/index.php/SUNScholar/Optimisations
Regards
hg
*Hilton Gibson*
Ubuntu Linux Systems Administrator
Stellenbosch University Library
http://staff.lib.sun.ac.za/~hgibson/docs/cv/cv.html
On 13 July 2015 at 16:41, Shaun Donovan <sha...@teqcle.co.za> wrote:
> 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: lewatle.phal...@wits.ac.za [lewatle.phal...@wits.ac.za]
> > 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
> > DSpace-tech@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/dspace-tech
> > List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
>
>
>
> ------------------------------------------------------------------------------
> 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
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech
> List Etiquette:
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
------------------------------------------------------------------------------
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
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
