Requeue BackfillArchivedAndTraversalIdsToVulnerabilityStatistics
Why are we doing this work
We need to re run this BBM again after the completion of #544727 (closed) before we can add the constraint in #518683 (closed).
Relevant links
See !188170 (comment 2511814744)
Implementation plan
Create a post DB migration that re-enqueue BackfillArchivedAndTraversalIdsToVulnerabilityStatistics.
Verification steps
There should be no vulnerability_statistics such as traversal_ids is an empty array.
On postgres.ai the following queries should return no record at all.
explain select 1 from vulnerability_statistics
where traversal_ids = '{}'::bigint[]
and latest_pipeline_id is null;
explain select 1 from vulnerability_statistics
where traversal_ids = '{}'::bigint[]
and latest_pipeline_id is not null;
/cc @anarinesingh
Edited by 🤖 GitLab Bot 🤖