You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@maven.apache.org by "Florian Kleedorfer (JIRA)" <ji...@codehaus.org> on 2007/12/10 12:41:57 UTC
[jira] Created: (CONTINUUM-1598) upgrade from 1.0.3 to 1.1:
data-management-cli crashes
upgrade from 1.0.3 to 1.1: data-management-cli crashes
------------------------------------------------------
Key: CONTINUUM-1598
URL: http://jira.codehaus.org/browse/CONTINUUM-1598
Project: Continuum
Issue Type: Bug
Components: Data Management
Affects Versions: 1.1, 1.1-beta-4, 1.1-beta-3, 1.1-beta-2
Environment: Maven version: 2.0.7
Java version: 1.5.0_08
OS name: "linux" version: "2.6.8.1-5-386" arch: "i386"
continuum 1.0.3 standalone (using derby db)
Reporter: Florian Kleedorfer
I tried to migrate continuum as explained in http://maven.apache.org/continuum/documentation/1_1/installation/upgrade.html, but the first step (export of the old database) fails. I tried all available versions of the data-management-cli jar with and without the parameter '-databaseFormat CONTINUUM_103', with the same results.
I'm including the stacktraces for the 1.1 release version, with and without the -databaseFormat option
=== without -databaseFormat option ===
java -Xmx512m -jar data-management-cli-1.1-app.jar -buildsJdbcUrl jdbc:derby:/usr/local/continuum/apps/continuum/database -mode EXPORT -directory backups
...
13477 [main] ERROR JPOX.RDBMS - An exception was thrown while adding/validating class(es) : Constraint 'PROFILES_FK2' is invalid:
there is no unique or primary key constraint on table 'SA.INSTALLATION' that matches the number and types of the columns in the for
eign key.
ERROR X0Y44: Constraint 'PROFILES_FK2' is invalid: there is no unique or primary key constraint on table 'SA.INSTALLATION' that mat
ches the number and types of the columns in the foreign key.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.iapi.sql.dictionary.DDUtils.locateReferencedConstraint(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateConstraintConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.AlterTableConstantAction.execGuts(Unknown Source)
at org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:614)
at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:463)
at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:394)
at org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2875)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:3110)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3313)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2554)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2406)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:821)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:835)
at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1161)
at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1354)
at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2324)
at org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached(PlexusJdoUtils.java:358)
at org.apache.maven.continuum.store.JdoContinuumStore.getAllProjectGroupsWithTheLot(JdoContinuumStore.java:2052)
at org.apache.maven.continuum.management.JdoDataManagementTool.backupDatabase(JdoDataManagementTool.java:90)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:265)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
=== with -databaseFormat option ===
java -Xmx512m -jar data-management-cli-1.1-app.jar -buildsJdbcUrl jdbc:derby:/usr/local/continuum/apps/continuum/database -mode EXPORT -directory backups -databaseFormat CONTINUUM_103
7280 [main] ERROR JPOX.RDBMS - An exception was thrown while adding/validating class(es) : 'TEST_RESULT_TESTRESULT_ID_OID' is not
a column in table or VTI 'BUILDRESULT'.
ERROR 42X14: 'TEST_RESULT_TESTRESULT_ID_OID' is not a column in table or VTI 'BUILDRESULT'.
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateIndexConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.CreateConstraintConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.AlterTableConstantAction.execGuts(Unknown Source)
at org.apache.derby.impl.sql.execute.AlterTableConstantAction.executeConstantAction(Unknown Source)
at org.apache.derby.impl.sql.execute.MiscResultSet.open(Unknown Source)
at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
at org.jpox.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:561)
at org.jpox.store.rdbms.table.TableImpl.validateForeignKeys(TableImpl.java:465)
at org.jpox.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:396)
at org.jpox.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:2774)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:3050)
at org.jpox.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2540)
at org.jpox.store.rdbms.RDBMSManager$MgmtTransaction.execute(RDBMSManager.java:2397)
at org.jpox.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:603)
at org.jpox.store.rdbms.RDBMSManager.addClass(RDBMSManager.java:617)
at org.jpox.store.StoreManager.getDatastoreClass(StoreManager.java:1016)
at org.jpox.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1134)
at org.jpox.AbstractPersistenceManager.getExtent(AbstractPersistenceManager.java:2216)
at org.codehaus.plexus.jdo.PlexusJdoUtils.getAllObjectsDetached(PlexusJdoUtils.java:358)
at org.apache.maven.continuum.management.LegacyJdoDataManagementTool.retrieveAllProjectGroups(LegacyJdoDataManagementTool.j
ava:133)
at org.apache.maven.continuum.management.LegacyJdoDataManagementTool.backupDatabase(LegacyJdoDataManagementTool.java:97)
at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:265)
at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:170)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira