I have cleared the oracle database of everything I know of.
No tables in tabs, No user_constraints, No views, No sequences, No
user_objects, purged recyclebin. I did this by modifying the
clean_database.sql that came with 1.5.2, adding elements that were not in it.
I changed all the DROP TABLE statements to be DROP TABLE tablename CASCADE
CONSTRAINTS PURGE; and added a PURGE RECYCLEBIN; at the end. I checked them all
with appropriate queries.
Oracle 10.2.0.3, Solaris 10, ojdbc14 10.2.0.2, and ant 1.8.1
So now ant fresh_install fails with:
-bash-3.00$ ant fresh_install
Buildfile:
/dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml
init_installation:
init_configs:
test_database:
[java] 2010-08-31 12:41:21,199 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:21,238 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java]
[java] Attempting to connect to database:
[java] - URL: jdbc:oracle:thin:@//dumbbell:1521/dspace
[java] - Driver: oracle.jdbc.OracleDriver
[java] - Username: dspace
[java] - Password: dspace2009
[java] - Schema: dspace
[java]
[java] Testing connection...
[java] Connected succesfully!
[java]
setup_database:
[java] 2010-08-31 12:41:23,281 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:23,323 INFO
org.dspace.storage.rdbms.InitializeDatabase @ Initializing Database
[java] 2010-08-31 12:41:24,933 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:24,942 WARN
org.dspace.storage.rdbms.DatabaseManager @ Got SQL Exception:
java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] java.sql.SQLException: ORA-01408: such column list already indexed
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
[java] at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1687)
[java] at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1653)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
[java] at
org.dspace.storage.rdbms.DatabaseManager.loadSql(DatabaseManager.java:1067)
[java] at
org.dspace.storage.rdbms.InitializeDatabase.main(InitializeDatabase.java:100)
[java] 2010-08-31 12:41:30,946 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:30,998 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] 2010-08-31 12:41:33,249 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:33,263 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,512 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:897)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:35,520 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:898)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,160 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,168 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:906)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,522 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:941)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
[java] 2010-08-31 12:41:36,531 ERROR
org.dspace.browse.BrowseCreateDAOOracle @ caught exception:
[java] java.sql.SQLException: ORA-00942: table or view does not exist
[java]
[java] at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
[java] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
[java] at
oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
[java] at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
[java] at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3400)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
[java] at
org.dspace.storage.rdbms.DatabaseManager.updateQuery(DatabaseManager.java:460)
[java] at
org.dspace.browse.BrowseCreateDAOOracle.dropView(BrowseCreateDAOOracle.java:491)
[java] at
org.dspace.browse.IndexBrowse.dropItemTables(IndexBrowse.java:942)
[java] at
org.dspace.browse.IndexBrowse.clearDatabase(IndexBrowse.java:907)
[java] at
org.dspace.browse.IndexBrowse.prepTables(IndexBrowse.java:779)
[java] at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:742)
load_registries:
[java] 2010-08-31 12:41:40,025 INFO
org.dspace.core.ConfigurationManager @ Loading system provided config
property (-Ddspace.configuration): config/dspace.cfg
[java] 2010-08-31 12:41:40,093 INFO
org.dspace.core.ConfigurationManager @ Using default log4j provided
log configuration,if uninitended, check your dspace.cfg for
(log.init.config)
[java] Error:
[java] - null
[java] 2010-08-31 12:41:41,972 FATAL
org.dspace.administer.RegistryLoader @
anonymous::error_loading_registries:
[java] java.lang.NullPointerException
[java] at
org.dspace.storage.rdbms.TableRow.canonicalize(TableRow.java:674)
[java] at
org.dspace.storage.rdbms.TableRow.hasColumn(TableRow.java:110)
[java] at
org.dspace.storage.rdbms.TableRow.setColumn(TableRow.java:507)
[java] at
org.dspace.storage.rdbms.DatabaseManager.insert(DatabaseManager.java:713)
[java] at
org.dspace.storage.rdbms.DatabaseManager.create(DatabaseManager.java:490)
[java] at
org.dspace.content.BitstreamFormat.create(BitstreamFormat.java:419)
[java] at
org.dspace.administer.RegistryLoader.loadFormat(RegistryLoader.java:202)
[java] at
org.dspace.administer.RegistryLoader.loadBitstreamFormats(RegistryLoader.java:168)
[java] at
org.dspace.administer.RegistryLoader.main(RegistryLoader.java:105)
BUILD FAILED
/dspacehome/dspace-1.6.2-src-release/dspace/target/dspace-1.6.2-build.dir/build.xml:663:
Java returned: 1
Total time: 24 seconds
Any suggestions welcomed.
Marvin Weaver
Previous problem:
I finally found the problem! Solaris 10 comes with Sun's own screwed up
version of tar. It was truncating filenames at 21 characters. (I
thought they had abandoned it back with 5.8 and embraced gtar).
I updated jdk to 1.60_21, installed gtar from sunfreeware, ran mvn
-Udb.name=oracle package, and it built. Only one very strange thing I
noticed, gtar ended with "tar: A lone zero block at 44151" rather than a
clean exit.
Now, when trying ant fresh_install, I'm getting "index already
exists"...I'll wipe the database and try again.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
