Thanks for the input,
I deleted my data , dspace install and dspace-source folders then
recreated database and re-installed dspace this time the system works as
expected.
Nigel
From: Mark Diggory [mailto:[EMAIL PROTECTED] On Behalf Of Mark Diggory
Sent: Tuesday, September 30, 2008 10:57 PM
To: Nigel Pegus
Cc: dspace-tech@lists.sourceforge.net
Subject: Re: [Dspace-tech] database error dspace 1.5
Sounds like the database was not properly created when you ran ant
fresh_install, do you have a listing of the tables in your database?
-Mark
On Sep 30, 2008, at 11:37 AM, Nigel Pegus wrote:
Hello,
Ive recently installed dspace 1.5 on RHL enterprise v3 update 6. I am
unable to move past the basic install as the system generates an
internal server error.
My dspace log file indicates :
2008-09-30 10:21:29,989 WARN org.dspace.jsp @
anonymous:session_id=444B5F767AF01373ABBDA3109F9FF881:ip_addr=127.0.0.1:
database_error:org.postgresql.util.PSQLException: ERROR: relation
community does not exist
org.postgresql.util.PSQLException: ERROR: relation community does not
exist
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecu
torImpl.java:1531)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImp
l.java:1313)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:258)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:93)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Delegat
ingPreparedStatement.java:93)
at
org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java
:169)
at org.dspace.content.Community.findAllTop(Community.java:286)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:104)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.ja
va:384)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:228)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:175)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:128)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:104)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:2
16)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:84
4)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(
Http11Protocol.java:634)
at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Thread.java:619)
and the postgres log file contains:
LOG: received smart shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2008-09-30 10:19:57 AST
LOG: checkpoint record is at 0/42D064
LOG: redo record is at 0/42D064; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 0/606; next OID: 16386
LOG: next MultiXactId: 1; next MultiXactOffset: 0
LOG: database system is ready
ERROR: relation community does not exist
STATEMENT: SELECT * FROM community WHERE NOT community_id IN (SELECT
child_comm_id FROM community2community) ORDER BY name
I have tried
-removing the data folder and recreating it along with the database
-ensure dspace.cfg file includes proper entries
-ensuring postgres.conf listen_address=localhost entry is uncommented
-pg_hba.conf has dspace entry added
-adding another jdbc driver to lib folder
(/.../dspace-1.5.1-src-release/dspace/target/dspace-1.5.1-build.dir/lib)
I am assuming this is some sort of database setup error. Is there
something I have overlooked?
Thanks for any input
Nigel
Nigel Pegus
Systems Unit
The Main Library
The University of the West Indies
6622002x2241