[CONTINUUM-2552] JDOException when deleting a project

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 1.4.0 (Beta)
• Component/s: Core system, Database
• Assignee: Unassigned
• Reporter: Maria Catherine R. Tan
• Created: 04/Aug/10 08:27
• Updated: 04/Jan/13 01:01
• Resolved: 30/Apr/12 00:57

Description

We already set the parent to null, cleared project dependency and modified dependencies of build result but there are times that Continuum is still throwing a JDOException when deleting a project.

Maybe setting the build result's project to null before removing the build result might help.

Error Occured
javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM `PROJECTDEPENDENCY` WHERE `PROJECTDEPENDENCY_ID`=? NestedThrowables: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`continuum107`.`PROJECT`, CONSTRAINT `PROJECT_FK1` FOREIGN KEY (`PARENT_PROJECTDEPENDENCY_ID_OID`) REFERENCES `PROJECTDEPENDENCY` (`PROJECTDEPENDENCY_ID`))
Show/hide Stack Trace

javax.jdo.JDOUserException: One or more instances could not be deleted
at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1541)
at org.jpox.AbstractPersistenceManager.deletePersistentAll(AbstractPersistenceManager.java:1514)
at org.jpox.store.rdbms.scostore.FKListStore.clear(FKListStore.java:1137)
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:1076)
at org.jpox.state.StateManagerImpl.deletePersistent(StateManagerImpl.java:4405)
at org.jpox.AbstractPersistenceManager.internalDeletePersistent(AbstractPersistenceManager.java:1489)
at org.jpox.AbstractPersistenceManager.deletePersistent(AbstractPersistenceManager.java:1505)
at org.codehaus.plexus.jdo.PlexusJdoUtils.removeObject(PlexusJdoUtils.java:121)
at org.apache.continuum.dao.AbstractDao.removeObject(AbstractDao.java:95)
at org.apache.continuum.dao.BuildResultDaoImpl.removeBuildResult(BuildResultDaoImpl.java:311)
at org.apache.maven.continuum.DefaultContinuum.removeBuildResult(DefaultContinuum.java:1108)
at org.apache.maven.continuum.DefaultContinuum.removeProject(DefaultContinuum.java:689)
at org.apache.maven.continuum.web.action.DeleteProjectAction.execute(DeleteProjectAction.java:83)