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 wsmoak@gmail.com designates
 64.233.170.187 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=wmMdsk77HMlUY1VAA6y+8Lsbq5Vc5p4v9NJ984KaubHIH82bKVeW42QDGdzFud0Hoe
         32lAauhVJ+6sehJcTIOFmKN2x8sCZAUE1FfPJ3ojNwZsAKCHc9n7lOg9lObauoP5yiLV
         /tCKZAV85zPGuiErx0XH5bqEFpMqlClyWnFao=
MIME-Version: 1.0
Date: Fri, 6 Feb 2009 10:21:14 -0700
Message-ID: <adba96190902060921x68243984r261a9bf3edabfe98@mail.gmail.com>
Subject: Problems deleting things from Continuum
From: Wendy Smoak <wsmoak@gmail.com>
To: dev@continuum.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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