Expire builds throws SQLIntegrityConstraintViolationException

XMLWordPrintable

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

              Assignee:
              Krystian Brazulewicz
              Reporter:
              Ulrich Kuhnhardt [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 12h
                  12h