You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Maria Odea Ching (JIRA)" <ji...@codehaus.org> on 2010/05/26 04:43:12 UTC
[jira] Created: (CONTINUUM-2528) FK constraint error in
ProjectDependency table when deleting a project in project group
FK constraint error in ProjectDependency table when deleting a project in project group
---------------------------------------------------------------------------------------
Key: CONTINUUM-2528
URL: http://jira.codehaus.org/browse/CONTINUUM-2528
Project: Continuum
Issue Type: Bug
Components: Database
Affects Versions: 1.3.6
Environment: Windows, Embedded Derby database
Reporter: Maria Odea Ching
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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Issue Comment Edited: (CONTINUUM-2528) FK constraint error
in ProjectDependency table when deleting a project in project group
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=222689#action_222689 ]
Maria Odea Ching edited comment on CONTINUUM-2528 at 5/25/10 10:10 PM:
-----------------------------------------------------------------------
We were able to delete the project in the group by doing the following:
# Set to null the PROJECTDEPENDENCY.DEPENDENCIES_ID_OWN column of all project dependencies referring to the ID of the deploy plugin project
# Set to null the PROJECT.PARENT_PROJECTDEPENDENCY_ID_OID column of the deploy plugin project
was (Author: oching):
We were able to delete the project in the group by doing the following:
1. Set to null the PROJECTDEPENDENCY.DEPENDENCIES_ID_OWN column of all project dependencies referring to the ID of the deploy plugin project
2. Set to null the PROJECT.PARENT_PROJECTDEPENDENCY_ID_OID column of the deploy plugin project
> FK constraint error in ProjectDependency table when deleting a project in project group
> ---------------------------------------------------------------------------------------
>
> Key: CONTINUUM-2528
> URL: http://jira.codehaus.org/browse/CONTINUUM-2528
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.3.6
> Environment: Windows, Embedded Derby database
> Reporter: Maria Odea Ching
>
> 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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Commented: (CONTINUUM-2528) FK constraint error in
ProjectDependency table when deleting a project in project group
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=222689#action_222689 ]
Maria Odea Ching commented on CONTINUUM-2528:
---------------------------------------------
We were able to delete the project in the group by doing the following:
1. Set to null the PROJECTDEPENDENCY.DEPENDENCIES_ID_OWN column of all project dependencies referring to the ID of the deploy plugin project
2. Set to null the PROJECT.PARENT_PROJECTDEPENDENCY_ID_OID column of the deploy plugin project
> FK constraint error in ProjectDependency table when deleting a project in project group
> ---------------------------------------------------------------------------------------
>
> Key: CONTINUUM-2528
> URL: http://jira.codehaus.org/browse/CONTINUUM-2528
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.3.6
> Environment: Windows, Embedded Derby database
> Reporter: Maria Odea Ching
>
> 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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] Updated: (CONTINUUM-2528) FK constraint error in
ProjectDependency table when deleting a project in project group
Posted by "Maria Odea Ching (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-2528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maria Odea Ching updated CONTINUUM-2528:
----------------------------------------
Fix Version/s: 1.4.1 (Beta)
> FK constraint error in ProjectDependency table when deleting a project in project group
> ---------------------------------------------------------------------------------------
>
> Key: CONTINUUM-2528
> URL: http://jira.codehaus.org/browse/CONTINUUM-2528
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.3.6
> Environment: Windows, Embedded Derby database
> Reporter: Maria Odea Ching
> Fix For: 1.4.1 (Beta)
>
>
> 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)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira