Continuum

deleting projects not working if build-results exist

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Fixed
  • Affects Version/s: 1.1
  • Fix Version/s: 1.3.2 (Beta)
  • Component/s: Database
  • Labels:
    None
  • Environment:
    MySQL-version is 5.0.32
    driver-version is mysql-connector-java-5.1.6-bin.jar
  • Complexity:
    Intermediate
  • Number of attachments :
    0

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.

Activity

Hide
Permalink
Emmanuel Venisse added a comment -

Already fixed.

Show
Emmanuel Venisse added a comment - Already fixed.

People

  • Assignee:
    Emmanuel Venisse
    Reporter:
    Marc Lustig
Vote (2)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: