You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@continuum.apache.org by "Aleksey (JIRA)" <ji...@codehaus.org> on 2008/10/06 17:52:08 UTC
[jira] Created: (CONTINUUM-1921) foreign key constraint violation
foreign key constraint violation
--------------------------------
Key: CONTINUUM-1921
URL: http://jira.codehaus.org/browse/CONTINUUM-1921
Project: Continuum
Issue Type: Bug
Components: Database
Affects Versions: 1.2
Environment: MS Windows XP SP3, java 1.6.0_02
Reporter: Aleksey
Hi, I found a bug looks like [CONTINUUM-1385|http://jira.codehaus.org/browse/CONTINUUM-1385]
I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. I think there should be a delete cascade, not a contstraint.
{noformat}
javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK2' for key (10). The statement has been rolled back.
{noformat}
Continuum 1.2 Build Number: 697023
--
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-1921) foreign key constraint violation
when deleting projects
Posted by "Wendy Smoak (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wendy Smoak updated CONTINUUM-1921:
-----------------------------------
Summary: foreign key constraint violation when deleting projects (was: foreign key constraint violation)
> foreign key constraint violation when deleting projects
> -------------------------------------------------------
>
> Key: CONTINUUM-1921
> URL: http://jira.codehaus.org/browse/CONTINUUM-1921
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.2
> Environment: MS Windows XP SP3, java 1.6.0_02
> Reporter: Aleksey
>
> Hi, I found a bug looks like [CONTINUUM-1385|http://jira.codehaus.org/browse/CONTINUUM-1385]
> I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. I think there should be a delete cascade, not a contstraint.
> {noformat}
> javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK2' for key (10). The statement has been rolled back.
> {noformat}
> Continuum 1.2 Build Number: 697023
--
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] Closed: (CONTINUUM-1921) foreign key constraint violation
when deleting projects
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Porter closed CONTINUUM-1921.
-----------------------------------
Resolution: Duplicate
Fix Version/s: (was: Backlog)
Assignee: Brett Porter
> foreign key constraint violation when deleting projects
> -------------------------------------------------------
>
> Key: CONTINUUM-1921
> URL: http://jira.codehaus.org/browse/CONTINUUM-1921
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.2
> Environment: MS Windows XP SP3, java 1.6.0_02
> Reporter: Aleksey
> Assignee: Brett Porter
>
> Hi, I found a bug looks like [CONTINUUM-1385|http://jira.codehaus.org/browse/CONTINUUM-1385]
> I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. I think there should be a delete cascade, not a contstraint.
> {noformat}
> javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK2' for key (10). The statement has been rolled back.
> {noformat}
> Continuum 1.2 Build Number: 697023
--
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-1921) foreign key constraint violation
when deleting projects
Posted by "Brett Porter (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Brett Porter updated CONTINUUM-1921:
------------------------------------
Fix Version/s: 1.x
> foreign key constraint violation when deleting projects
> -------------------------------------------------------
>
> Key: CONTINUUM-1921
> URL: http://jira.codehaus.org/browse/CONTINUUM-1921
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.2
> Environment: MS Windows XP SP3, java 1.6.0_02
> Reporter: Aleksey
> Fix For: 1.x
>
>
> Hi, I found a bug looks like [CONTINUUM-1385|http://jira.codehaus.org/browse/CONTINUUM-1385]
> I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. I think there should be a delete cascade, not a contstraint.
> {noformat}
> javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK2' for key (10). The statement has been rolled back.
> {noformat}
> Continuum 1.2 Build Number: 697023
--
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-1921) foreign key constraint violation
Posted by "Eddie Lau (JIRA)" <ji...@codehaus.org>.
[ http://jira.codehaus.org/browse/CONTINUUM-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=150748#action_150748 ]
Eddie Lau commented on CONTINUUM-1921:
--------------------------------------
I saw the same error message when i *delete a project group* directly.
but in my case,
after i saw the message,
all the *build history has already gone*.
i have to manually remove all the non-default build definition,
before i can remove the project group successfully.
> foreign key constraint violation
> --------------------------------
>
> Key: CONTINUUM-1921
> URL: http://jira.codehaus.org/browse/CONTINUUM-1921
> Project: Continuum
> Issue Type: Bug
> Components: Database
> Affects Versions: 1.2
> Environment: MS Windows XP SP3, java 1.6.0_02
> Reporter: Aleksey
>
> Hi, I found a bug looks like [CONTINUUM-1385|http://jira.codehaus.org/browse/CONTINUUM-1385]
> I tried to delete an ant project from a group and get the following message (see below). Removing all the build results helped. I think there should be a delete cascade, not a contstraint.
> {noformat}
> javax.jdo.JDOUserException: One or more instances could not be deleted NestedThrowables: javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM BUILDDEFINITION WHERE ID = ? NestedThrowables: SQL Exception: DELETE on table 'BUILDDEFINITION' caused a violation of foreign key constraint 'BUILDRESULT_FK2' for key (10). The statement has been rolled back.
> {noformat}
> Continuum 1.2 Build Number: 697023
--
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