continuum-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brett Porter (JIRA)" <j...@codehaus.org>
Subject [jira] Closed: (CONTINUUM-1598) upgrade from 1.0.3 to 1.1: data-management-cli crashes
Date Wed, 02 Apr 2008 05:29:58 GMT

     [ 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

        

Mime
View raw message