Uploaded image for project: 'Continuum'
  1. Continuum
  2. CONTINUUM-1598

upgrade from 1.0.3 to 1.1: data-management-cli crashes

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.1-beta-2, 1.1-beta-3, 1.1-beta-4, 1.1
    • None
    • Data Management
    • None
    • 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)

    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)

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              phlow Florian Kleedorfer
              Votes:
              2 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: