[CONTINUUM-1598] upgrade from 1.0.3 to 1.1: data-management-cli crashes

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.1-beta-2, 1.1-beta-3, 1.1-beta-4, 1.1
• Component/s: Data Management
• 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)
• Assignee: Unassigned
• Reporter: Florian Kleedorfer
• Created: 10/Dec/07 05:41
• Updated: 02/Apr/08 00:28
• Resolved: 02/Apr/08 00:28

Description

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)

Issue Links

• duplicates: CONTINUUM-1599 Migration tool for continuum 1.0.3