Francois, This sounds like you need to extend your Oracle table space.
--Dale --------------------------------------- Dale Poulter Automation Coordinator Library Information Technology Services Vanderbilt University Suite 700 110 21st Avenue South Nashville, TN 37240 (615)343-5388 (615)343-8834 (fax) (615)207-9705 (cell) [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of François Parmentier Sent: Wednesday, September 10, 2008 7:29 AM To: [email protected] Subject: Re: [Dspace-tech] re indexing error 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 ------------------------------------------------------------------------- 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
