Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@continuum.apache.org
Received-SPF: pass (athena.apache.org: local policy)
Message-ID: 
 <8820612.1233940699708.JavaMail.haus-jira@codehaus01.managed.contegix.com>
Date: Fri, 6 Feb 2009 11:18:19 -0600 (CST)
From: "Wendy Smoak (JIRA)" <jira@codehaus.org>
To: issues@continuum.apache.org
Subject: [jira] Updated: (CONTINUUM-1921) foreign key constraint violation
 when deleting projects
In-Reply-To: 
 <1348728.1223308328708.JavaMail.haus-jira@codehaus01.managed.contegix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit


     [ 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