[
http://jira.codehaus.org/browse/CONTINUUM-1598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brett Porter closed CONTINUUM-1598.
-----------------------------------
Resolution: Duplicate
> 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-beta-2, 1.1-beta-3, 1.1-beta-4, 1.1
> 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
