Skip to content

Reschedule DropInvalidVulnerabilities and track jobs

What does this MR do?

After merging !60023 (merged) we found out that there were 1615 records left in the database, this could be related to recent database incident. After consulting with Database team it was suggested to reschedule the jobs with database tracking enabled

Related to #301141 (closed)

Migration details

I copied the details from the previous MR (!60023 (merged)) and updated them slightly with the new information.

Cold cache

Warm cache

Estimated execution time

Records in table: 8 079 579
Records to delete: 1615
Batch size: 10 000
Loops: 808
Delay: 120s

(4.728s + 0.693s + 120s) + 759 * (0.017s + 0.001s + 120s) ~= 96840 seconds
96840/3600 ~= 26.9 hours

Does this MR meet the acceptance criteria?

Conformity

Availability and Testing

Edited by Michał Zając

Merge request reports