Patching CleanupBuildNameWorker to ignore imported builds

Max Fanrequested to merge
563058-ignoring-imported-builds-when-cleaning-buildnames into master

What does this MR do and why?

Patching CleanupBuildNameWorker to truncate partitions

The worker will now directly truncate partitions that are not the current partition or the directly previous partition

This will ensure a maximum of 2 months retention as we create a new partition each month on .com

References

Table truncation should be pretty fast

image.png

Screenshots or screen recordings

Before After

How to set up and validate locally

This is a bit complicated to test-out, but running CleanupBuildNameWorker will ONLY cleanup p_ci_build_name records older than 3 months

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #563058 (closed)

Edited by Max Fan

Merge request reports