continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Venisse <emman...@venisse.net>
Subject Re: from 1.1-beta3 to beta4
Date Mon, 12 Nov 2007 17:00:14 GMT
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
> 


Mime
View raw message