We are experiencing poor response time in DSpace 1.4.2 with postgreSQL
7.3.4. We are also getting a frequent error that says:
2008-02-27 14:47:15,429 WARN org.dspace.app.webui.servlet.DSpaceServlet
@ anonymous:no_context:database_error:Backend start-up failed: FATAL:
Non-superuser connection limit exceeded
Backend start-up failed: FATAL: Non-superuser connection limit exceeded
at
org.postgresql.jdbc1.AbstractJdbc1Connection.openConnection(AbstractJdbc
1Connection.java:306)
at org.postgresql.Driver.connect(Driver.java:122)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:171)
at
org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(
DriverManagerConnectionFactory.java:48)
at
org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableCon
nectionFactory.java:290)
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjec
tPool.java:840)
at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:175)
at
java.sql.DriverManager.getConnection(DriverManager.java:525)
at
java.sql.DriverManager.getConnection(DriverManager.java:193)
at
org.dspace.storage.rdbms.DatabaseManager.getConnection(DatabaseManager.j
ava:717)
at org.dspace.core.Context.<init>(Context.java:105)
at
org.dspace.app.webui.util.UIUtil.obtainContext(UIUtil.java:112)
at
org.dspace.app.webui.servlet.DSpaceServlet.processRequest(DSpaceServlet.
java:132)
at
org.dspace.app.webui.servlet.DSpaceServlet.doGet(DSpaceServlet.java:99)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:796)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:917)
at
org.apache.catalina.core.ApplicationFilterChain.servletService(Applicati
onFilterChain.java:391)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:272)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
textValve.java:241)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:182)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
71)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:160)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
71)
at
com.sun.webserver.connector.nsapi.NSAPIProcessor.process(NSAPIProcessor.
java:149)
at
com.sun.webserver.connector.nsapi.NSAPIConnector.service(NSAPIConnector.
java:995)
Can someone give me some ideas on how to improve performance *and* get
rid of this error?
Thanks,
Sue
Sue Walker-Thornton
ConITS Contract
NASA Langley Research Center
</></>Integrated Library Systems Application Administrator/DBA
130 Research Drive
Hampton, VA 23666
Office: (757) 224-4074
Fax: (757) 224-4001
Pager: (757) 988-2547
Email: [EMAIL PROTECTED]
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
