I got a similar problem, but I did not know whether the no-creation of the
browse index was bound to the SQLException or not.
From what you sent, it seems that it did.
Here is what I got:
----8<----
> ./index-all
Creating browse index
Indexing all Items in DSpace....Error: Browse index NOT created
java.sql.SQLException: ORA-30036: unable to extend segment by 8 in undo
tablespace 'UNDO_SIGLE'
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:519)
at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:539)
at org.dspace.browse.Browse.indexRemoveAll(Browse.java:631)
at org.dspace.browse.Browse.indexAll(Browse.java:599)
at org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74)
Creating search index
----8<----
We will extend the tablespace, I hope it will fix my problem.
For yours, I suspect that you did not "downgrade" your database, as
itemsbyauthor is a table in 1.4.2 (and certainly in 1.4.1).
Maybe you should reinstall 1.4.2?
--
François Parmentier
INIST-CNRS
Chad Hansen wrote:
>
> I recently upgraded to the 1.5 alpha version of DSpace.
> Now, however, I would like to go back to my trusty 1.4.1 version (or 1.4.2
> would work too).
>
> I am having a problem with the reindexing process.
>
> When I run /dspace/bin/index-all, I get the following output:
>
> Creating browse index
> Indexing all Items in DSpace....Error: Browse index NOT created
> java.sql.SQLException: ERROR: relation "itemsbyauthor" does not exist
>
> at
> org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
> at
> org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:179)
> 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:519)
> at
> org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:539)
> at org.dspace.browse.Browse.indexRemoveAll(Browse.java:631)
> at org.dspace.browse.Browse.indexAll(Browse.java:599)
> at
> org.dspace.browse.InitializeBrowse.main(InitializeBrowse.java:74)
> Creating search index
> Done with indexing
>
> what do I do now?
>
> ----------
> Chad G.
>
> -------------------------------------------------------------------------
> 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
>
>
--
View this message in context:
http://www.nabble.com/reindexing-error-tp15069170p19370893.html
Sent from the DSpace - Tech mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
