Hi David, I just did the same thing over the weekend - upgrade from 1.3.2 --> 1.7. Although I did not hit your specific issue, I had a few issues of my own. Maybe I can help here...
What OS are you running and what version of postgres are you using? Also, did you run the schema update command? Thanks, ----------------------------- Ron Kelley [email protected] On Aug 1, 2011, at 10:07 PM, David Schroeder wrote: > 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 ------------------------------------------------------------------------------ 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
