[CONTINUUM-2528] FK constraint error in ProjectDependency table when deleting a project in project group

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.3.6
• Component/s: Database
• Labels: backlog-to-cleanup
• Environment: Windows, Embedded Derby database
• Assignee: Unassigned
• Reporter: Maria Odea B. Ching
• Created: 25/May/10 21:42
• Updated: 20/Nov/12 01:09

Description

We encountered this when deleting the maven deploy plugin project in NPanday project group at the NPanday CI. Below is the error:

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: SQL Exception: DELETE on table 'PROJECTDEPENDENCY' caused a violation of foreign key constraint 'PROJECT_FK1' for key (49528). The statement has been rolled back.

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)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)
at org.apache.struts2.interceptor.MessageStoreInterceptor.intercept(MessageStoreInterceptor.java:195)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:48)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)