Thanks! On Nov 12, 2007 6:00 PM, Emmanuel Venisse <[EMAIL PROTECTED]> wrote: > 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 > > > >
-- http://www.somatik.be Microsoft gives you windows, Linux gives you the whole house.
