continuum-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emmanuel Venisse <emman...@venisse.net>
Subject Re: Migration from beta-3 to beta-4 problem
Date Fri, 02 Nov 2007 15:07:14 GMT
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 <emmanuel@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 <emmanuel@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)
>>>>>
>>>>>
>>>
>>
> 
> 


Mime
View raw message