You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by Thomas Recloux <th...@gmail.com> on 2007/11/01 09:42:07 UTC
Migration from beta-3 to beta-4 problem
Hi,
I have got the following error during the builds import with the migration
tool.
It looks like the migration tool tries to delete 'BUILDDEFINITION' entries
but a child entry blocks the statement.
If you give me the child table, I could delete it manually.
I do not undestand why the BUILDDEFINITION table is not empty.
Thanks, Thomas
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)
--
Thomas Recloux
Re: Migration from beta-3 to beta-4 problem
Posted by Emmanuel Venisse <em...@venisse.net>.
Maybe you can delete all datas in the DB with some sql requests.
Emmanuel
Thomas Recloux a écrit :
> Yes, it has just been initialized by the first start.
>
>
> 2007/11/2, Emmanuel Venisse <em...@venisse.net>:
>> ok, but the jdbc url for the import use a clean db?
>>
>> Emmanuel
>>
>> Thomas Recloux a écrit :
>>> No, I exported from a beta-3 to a new beta-4
>>>
>>> 2007/11/1, Emmanuel Venisse <em...@venisse.net>:
>>>> Do you run Export and Import on the same database?
>>>>
>>>> Emmanuel
>>>>
>>>> Thomas Recloux a écrit :
>>>>> Hi,
>>>>>
>>>>> I have got the following error during the builds import with the
>>>> migration
>>>>> tool.
>>>>>
>>>>> It looks like the migration tool tries to delete 'BUILDDEFINITION'
>>>> entries
>>>>> but a child entry blocks the statement.
>>>>> If you give me the child table, I could delete it manually.
>>>>>
>>>>> I do not undestand why the BUILDDEFINITION table is not empty.
>>>>>
>>>>> Thanks, Thomas
>>>>>
>>>>> 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)
>>>>>
>>>>>
>>>
>>
>
>
Re: Migration from beta-3 to beta-4 problem
Posted by Thomas Recloux <th...@gmail.com>.
Yes, it has just been initialized by the first start.
2007/11/2, Emmanuel Venisse <em...@venisse.net>:
>
> ok, but the jdbc url for the import use a clean db?
>
> Emmanuel
>
> Thomas Recloux a écrit :
> > No, I exported from a beta-3 to a new beta-4
> >
> > 2007/11/1, Emmanuel Venisse <em...@venisse.net>:
> >> Do you run Export and Import on the same database?
> >>
> >> Emmanuel
> >>
> >> Thomas Recloux a écrit :
> >>> Hi,
> >>>
> >>> I have got the following error during the builds import with the
> >> migration
> >>> tool.
> >>>
> >>> It looks like the migration tool tries to delete 'BUILDDEFINITION'
> >> entries
> >>> but a child entry blocks the statement.
> >>> If you give me the child table, I could delete it manually.
> >>>
> >>> I do not undestand why the BUILDDEFINITION table is not empty.
> >>>
> >>> Thanks, Thomas
> >>>
> >>> 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)
> >>>
> >>>
> >>
> >
> >
>
>
--
Thomas Recloux
Re: Migration from beta-3 to beta-4 problem
Posted by Emmanuel Venisse <em...@venisse.net>.
ok, but the jdbc url for the import use a clean db?
Emmanuel
Thomas Recloux a écrit :
> No, I exported from a beta-3 to a new beta-4
>
> 2007/11/1, Emmanuel Venisse <em...@venisse.net>:
>> Do you run Export and Import on the same database?
>>
>> Emmanuel
>>
>> Thomas Recloux a écrit :
>>> Hi,
>>>
>>> I have got the following error during the builds import with the
>> migration
>>> tool.
>>>
>>> It looks like the migration tool tries to delete 'BUILDDEFINITION'
>> entries
>>> but a child entry blocks the statement.
>>> If you give me the child table, I could delete it manually.
>>>
>>> I do not undestand why the BUILDDEFINITION table is not empty.
>>>
>>> Thanks, Thomas
>>>
>>> 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)
>>>
>>>
>>
>
>
Re: Migration from beta-3 to beta-4 problem
Posted by Thomas Recloux <th...@gmail.com>.
No, I exported from a beta-3 to a new beta-4
2007/11/1, Emmanuel Venisse <em...@venisse.net>:
>
> Do you run Export and Import on the same database?
>
> Emmanuel
>
> Thomas Recloux a écrit :
> > Hi,
> >
> > I have got the following error during the builds import with the
> migration
> > tool.
> >
> > It looks like the migration tool tries to delete 'BUILDDEFINITION'
> entries
> > but a child entry blocks the statement.
> > If you give me the child table, I could delete it manually.
> >
> > I do not undestand why the BUILDDEFINITION table is not empty.
> >
> > Thanks, Thomas
> >
> > 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)
> >
> >
>
>
--
Thomas Recloux
Re: Migration from beta-3 to beta-4 problem
Posted by Emmanuel Venisse <em...@venisse.net>.
Do you run Export and Import on the same database?
Emmanuel
Thomas Recloux a écrit :
> Hi,
>
> I have got the following error during the builds import with the migration
> tool.
>
> It looks like the migration tool tries to delete 'BUILDDEFINITION' entries
> but a child entry blocks the statement.
> If you give me the child table, I could delete it manually.
>
> I do not undestand why the BUILDDEFINITION table is not empty.
>
> Thanks, Thomas
>
> 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)
>
>
Re: Migration from beta-3 to beta-4 problem
Posted by Dennis Lundberg <de...@apache.org>.
I ran into this as well. I think that this has been reported into JIRA as:
http://jira.codehaus.org/browse/CONTINUUM-1540
Thomas Recloux wrote:
> Hi,
>
> I have got the following error during the builds import with the migration
> tool.
>
> It looks like the migration tool tries to delete 'BUILDDEFINITION' entries
> but a child entry blocks the statement.
> If you give me the child table, I could delete it manually.
>
> I do not undestand why the BUILDDEFINITION table is not empty.
>
> Thanks, Thomas
>
> 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)
>
>
--
Dennis Lundberg