It's a known issue (CONTINUUM-1540). the workaround is to remove the continuum database and add ";create=true" on the jdbc url you use for the import
Emmanuel Francis De Brabandere a écrit :
Hi all, I'm trying to upgrade from beta3 to beta4 but no succes. I have been following the migration page instructions: http://maven.apache.org/continuum/documentation/1_1/installation/upgrade.html but I get the following exception when importing the builds database: 9660 [main] INFO JPOX.RDBMS - Validated 2 foreign key(s) for table PROJECTGROUP_NOTIFIERS 9698 [main] INFO JPOX.RDBMS - Validated 3 index(es) for table PROJECTGROUP_NOTIFIERS Exception in thread "main" javax.jdo.JDOUserException: One or more instances could not be deleted at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1525) at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:687) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444) at org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase(JdoContinuumStore.java:1961) at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:127) at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:254) at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:158) NestedThrowablesStackTrace: javax.jdo.JDOUserException: One or more instances could not be deleted at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1525) at org.jpox.store.rdbms.scostore.ElementContainerStore.clear(ElementContainerStore.java:659) at org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:334) at org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2651) at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:1019) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4332) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473) at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1516) at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:687) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444) at org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase(JdoContinuumStore.java:1961) at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:127) at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:254) at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:158) NestedThrowablesStackTrace: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:288) at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611) at org.jpox.store.StoreManager.delete(StoreManager.java:981) at org.jpox.state.StateManagerImpl.internalDeletePersistent(StateManagerImpl.java:4395) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4350) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473) at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1516) at org.jpox.store.rdbms.scostore.ElementContainerStore.clear(ElementContainerStore.java:659) at org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:334) at org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2651) at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:1019) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4332) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473) at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1516) at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:687) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444) at org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase(JdoContinuumStore.java:1961) at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:127) at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:254) at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:158) NestedThrowablesStackTrace: ERROR 23503: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDDEFINITCE_FK2' for key (3). The statement has been rolled back. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.execute.ReferencedKeyRIChecker.doCheck(Unknown Source) at org.apache.derby.impl.sql.execute.RISetChecker.doPKCheck(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteResultSet.collectAffectedRows(Unknown Source) at org.apache.derby.impl.sql.execute.DeleteResultSet.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.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.jpox.store.rdbms.RDBMSManager.executeStatementUpdate(RDBMSManager.java:572) at org.jpox.store.rdbms.request.DeleteRequest.execute(DeleteRequest.java:274) at org.jpox.store.rdbms.table.ClassTable.delete(ClassTable.java:2611) at org.jpox.store.StoreManager.delete(StoreManager.java:981) at org.jpox.state.StateManagerImpl.internalDeletePersistent(StateManagerImpl.java:4395) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4350) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473) at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1516) at org.jpox.store.rdbms.scostore.ElementContainerStore.clear(ElementContainerStore.java:659) at org.jpox.store.mapping.CollectionMapping.deleteDependent(CollectionMapping.java:334) at org.jpox.store.rdbms.table.ClassTable.deleteDependent(ClassTable.java:2651) at org.jpox.store.StoreManager.deleteDependent(StoreManager.java:1019) at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4332) at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1473) at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1516) at org.jpox.store.rdbms.query.JDOQLQuery.performDeletePersistentAll(JDOQLQuery.java:687) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1120) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1075) at org.jpox.store.query.Query.deletePersistentAll(Query.java:1049) at org.codehaus.plexus.jdo.PlexusJdoUtils.removeAll(PlexusJdoUtils.java:444) at org.apache.maven.continuum.store.JdoContinuumStore.eraseDatabase(JdoContinuumStore.java:1961) at org.apache.maven.continuum.management.JdoDataManagementTool.eraseDatabase(JdoDataManagementTool.java:127) at org.apache.maven.continuum.management.DataManagementCli.processDatabase(DataManagementCli.java:254) at org.apache.maven.continuum.management.DataManagementCli.main(DataManagementCli.java:158) Any suggestions? I'm also seeing a big exception when starting continuum1.1 beta4 for the first time but I suppose that is nothing I should care about?) ERROR 42Y07: Schema 'SA' does not exist ERROR 42Y55: 'DROP FUNCTION' cannot be performed on 'JPOX_MATCHES' because it does not exist. Thanks in advance, Francis
