Hi,
I am in the process of upgrading a dspace installation from version 1.4.2 ->
1.7.2 and have hit a problem.
As one of final steps to the upgrade procedure for 1.4.2 -> 1.5.0 I have run
index-init and get the following error -
Exception in thread "main" org.dspace.browse.BrowseException:
org.postgresql.util.PSQLException: ERROR: relation "bi_item_seq" already exists
at
org.dspace.browse.BrowseCreateDAOPostgres.createSequence(BrowseCreateDAOPostgres.java:387)
at org.dspace.browse.IndexBrowse.createItemTables(IndexBrowse.java:952)
at org.dspace.browse.IndexBrowse.createItemTables(IndexBrowse.java:921)
at org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:739)
at org.dspace.browse.IndexBrowse.initBrowse(IndexBrowse.java:1045)
at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:707)
Caused by: org.postgresql.util.PSQLException: ERROR: relation "bi_item_seq"
already exists
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:300)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:354)
at
org.dspace.browse.BrowseCreateDAOPostgres.createSequence(BrowseCreateDAOPostgres.java:380)
... 5 more
The result is I can browse the communities and collections but date, author,
title or subject produce an Internal System Error.
I can't find any reference to this error anywhere so I assume it must be
something in our local setup causing it.
Any advice on fixing this would be appreciated.
--
David Schroeder
Infrastructure Services
Flinders University
Adelaide, Australia
Ph: +61 8 8201 2689
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Dspace-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-general
