Backfill ci_pending_builds for outdated stuck builds
Problem
It turns out StuckCiJobsWorker is not dropping builds which makes it not possible to enable data denormalization with our new queuing system.
gitlabhq_production=> SELECT COUNT(*) FROM ci_pending_builds WHERE created_at < '2021-08-20 14:30 UTC';
count
-------
480
(1 row)
Solution
In order to be able to rollout our denormalized data we need to fix data integrity by backfilling builds stucked with outdated data.
cc @grzesiek