Uploaded image for project: 'Continuum'
  1. Continuum
  2. CONTINUUM-1813

deleting projects not working if build-results exist

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.1
    • 1.3.2 (Beta)
    • Database
    • None
    • MySQL-version is 5.0.32
      driver-version is mysql-connector-java-5.1.6-bin.jar

    Description

      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.

      Attachments

        Activity

          People

            evenisse Emmanuel Venisse
            axismundi Marc Lustig
            Votes:
            2 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: