Uploaded image for project: 'Continuum'
  1. Continuum
  2. CONTINUUM-2528

FK constraint error in ProjectDependency table when deleting a project in project group

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.3.6
    • Fix Version/s: None
    • Component/s: Database
    • Environment:
      Windows, Embedded Derby database

      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)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              oching Maria Odea B. Ching
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: