From issues-return-2982-apmail-continuum-issues-archive=continuum.apache.org@continuum.apache.org Sat Mar 21 10:29:40 2009 Return-Path: Delivered-To: apmail-continuum-issues-archive@www.apache.org Received: (qmail 53320 invoked from network); 21 Mar 2009 10:29:40 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 Mar 2009 10:29:40 -0000 Received: (qmail 24274 invoked by uid 500); 21 Mar 2009 10:29:40 -0000 Delivered-To: apmail-continuum-issues-archive@continuum.apache.org Received: (qmail 24252 invoked by uid 500); 21 Mar 2009 10:29:40 -0000 Mailing-List: contact issues-help@continuum.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@continuum.apache.org Delivered-To: mailing list issues@continuum.apache.org Received: (qmail 24241 invoked by uid 99); 21 Mar 2009 10:29:40 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Mar 2009 03:29:40 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [63.246.2.115] (HELO codehaus01.managed.contegix.com) (63.246.2.115) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 21 Mar 2009 10:29:33 +0000 Received: from codehaus01.managed.contegix.com (localhost.localdomain [127.0.0.1]) by codehaus01.managed.contegix.com (Postfix) with ESMTP id 25F5014A8173 for ; Sat, 21 Mar 2009 05:29:13 -0500 (CDT) Message-ID: <27069130.1237631353153.JavaMail.haus-jira@codehaus01.managed.contegix.com> Date: Sat, 21 Mar 2009 05:29:13 -0500 (CDT) From: "Emmanuel Venisse (JIRA)" To: issues@continuum.apache.org Subject: [jira] Closed: (CONTINUUM-1813) deleting projects not working if build-results exist In-Reply-To: <28504096.1214834006818.JavaMail.haus-jira@codehaus01.managed.contegix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 4e90ceb663894a42f12c0e28abbab431 X-Virus-Checked: Checked by ClamAV on apache.org [ http://jira.codehaus.org/browse/CONTINUUM-1813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Emmanuel Venisse closed CONTINUUM-1813. --------------------------------------- Assignee: Emmanuel Venisse Resolution: Fixed Fix Version/s: (was: 1.3.x) 1.3.2 Already fixed. > deleting projects not working if build-results exist > ---------------------------------------------------- > > Key: CONTINUUM-1813 > URL: http://jira.codehaus.org/browse/CONTINUUM-1813 > Project: Continuum > Issue Type: Bug > Components: Database > Affects Versions: 1.1 > Environment: MySQL-version is 5.0.32 > driver-version is mysql-connector-java-5.1.6-bin.jar > Reporter: Marc Lustig > Assignee: Emmanuel Venisse > Fix For: 1.3.2 > > > If build-results (failure or success) exist, then the project doesn't get deleted. The following error's occur: > javax.jdo.JDODataStoreException: Delete request failed: DELETE FROM `PROJECT` WHERE `ID` = ? NestedThrowables: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`continuum/BUILDRESULT`, CONSTRAINT `BUILDRESULT_FK3` FOREIGN KEY (`PROJECT_ID_OID`) REFERENCES `PROJECT` (`ID`)) > or > javax.jdo.JDODataStoreException: Update request failed: UPDATE `BUILDRESULT` SET `BUILD_DEFINITION_ID_OID`=?, `BUILD_NUMBER`=?, `END_TIME`=?, `ERROR`=?, `EXIT_CODE`=?, `MODEL_ENCODING`=?, `PROJECT_ID_OID`=?, `START_TIME`=?, `RESULTSTATE`=?, `SUCCESS`=?, `RESULTTRIGGER`=? WHERE `ID`=? NestedThrowables: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction > After deleting all build-results, the project can be deleted. -- 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