Mailing-List: contact dev-help@continuum.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@continuum.apache.org
Received-SPF: pass (athena.apache.org: domain of emmanuel.venisse@gmail.com
 designates 209.85.220.16 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=lJjSFoENV0U7cR8dSvf+ERHO5oEebz6lDwsgBH6NQLJn3oJdRH5A9xcXw5TnsvimbG
         m0hpeRpJz/z7FBDcwk326Q3SmRHgVonlqkIOAasQ8BqsmfaAezcimR5Uw7Cg1tnzA0RP
         fTF6nJ6trzMvxlkUsmv8CyOdyD+kRgLZsnO3A=
MIME-Version: 1.0
In-Reply-To: <adba96190902060921x68243984r261a9bf3edabfe98@mail.gmail.com>
References: <adba96190902060921x68243984r261a9bf3edabfe98@mail.gmail.com>
Date: Fri, 6 Feb 2009 21:20:46 +0100
Message-ID: <f345f3480902061220g1eb6030fl196ed68b56107244@mail.gmail.com>
Subject: Re: Problems deleting things from Continuum
From: Emmanuel Venisse <emmanuel.venisse@gmail.com>
To: dev@continuum.apache.org
Content-Type: multipart/alternative; boundary=001636c5b84d8b711c046245c1b4

--001636c5b84d8b711c046245c1b4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Is it with a fresh 1.3.x fresh db or an updated db?

Emmanuel

On Fri, Feb 6, 2009 at 6:21 PM, Wendy Smoak <wsmoak@gmail.com> wrote:

> I'm having more and more trouble with foreign key constraint
> violations when trying to delete things from Continuum.
>
> For example, when trying to delete a project group:
>
> javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM
> SCMRESULT WHERE SCMRESULT_ID=? NestedThrowables: SQL Exception: DELETE
> on table 'SCMRESULT' caused a violation of foreign key constraint
> 'PROJECT_FK2' for key (5). The statement has been rolled back.
>
> I went into the group and tried to delete the build results from the
> project, then tried to delete the project from the group -- same
> error.
>
> A quick look in JIRA [1] turned up:
> CONTINUUM-1787           cannot delete a project, constraint violation
> CONTINUUM-1972           Error attempting to delete project group
> CONTINUUM-1905           I can't delete a project - Exception
> CONTINUUM-1813           deleting projects not working if build-results
> exist  (old -- opened against 1.1)
> CONTINUUM-1626           Unable to delete build definition with already
> executed builds
> CONTINUUM-1921           foreign key constraint violation
>
> I'm getting failures on this Selenium IDE test when it tries to clean
> up after itself:
>
> http://svn.apache.org/repos/asf/continuum/trunk/continuum-webapp-test/src/test/selenium-ide/add_and_build_project.html
>
> Does anyone have an idea what's going on?
>
> [1]
> http://jira.codehaus.org/secure/IssueNavigator.jspa?reset=true&&query=delet*&summary=true&description=true&pid=10540&resolution=-1
>
> --
> Wendy
>

--001636c5b84d8b711c046245c1b4--