Delete orphaned builds in production
Problem
Orphaned builds without pipelines due to broken ON DELETE CASCADE
constraint:
#483117 (closed) - An MR is merged to add a new ON DELETE CASCADE
constraint to replace the old one
Fix
Write a data migration to delete any builds that do not have pipeline associated with them. These builds will have a pipeline id to a pipeline that no longer exists.
Edited by Allison Browne