You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@continuum.apache.org by "Lustig, Marc (Allianz Deutschland, externer Mitarbeiter)" <EX...@ALLIANZ.DE> on 2008/06/30 14:44:18 UTC

trying to delete project: JDO error

We are trying to delete a project by pressing the 'delete' button in the project group overview.
It takes about 2 minutes and then the following message is displayed:
 
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
 
is it a known bug?

AW: trying to delete project: JDO error

Posted by "Lustig, Marc (Allianz Deutschland, externer Mitarbeiter)" <EX...@allianz.de>.
I deleted all schedules (except the default) and notifiers and tried again to delete the project itself. Result:

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`))


MySQL-version is 5.0.32
driver-version is mysql-connector-java-5.1.6-bin.jar

somebody experienced that too ?