Details
-
Bug
-
Resolution: Fixed
-
Medium
-
2.2
-
None
-
MySQL 4, MySQL 5, Oracle 10
Description
Recently for many customers build expiry did not work because of foreign key constraint violation:
mainly for table user_commit.
Hibernate operation: could not delete: com.atlassian.bamboo.resultsummary.BuildResultsSummaryImpl#11042858; SQL []; Cannot delete or update a parent row: a foreign key constraint fails (`bamboo/user_commit`, CONSTRAINT `FKF8936C2BA958B29F` FOREIGN KEY (`BUILDRESULTSUMMARY_ID`) REFERENCES `buildresultsummary ` (`BUILDRESULTSUMMARY_ID`)); nested exception is com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`bamboo/user_commit`, CONSTRAINT `FKF8936C2BA958B29F` FOREIGN KEY (`BUILDRESULTSUMMARY_ID`) REFERENCES `buildresultsummary` (`BUILDRESULTSUMMARY_ID`))