Add semver column to ci_runners table
What does this MR do and why?
Describe in detail what your merge request does and why.
This MR is part of a sequence of MRs that will ultimately result in being able to efficiently count the number of out-of-date CI runners in a given scope (instance/namespace/project). Please refer to the table below for more details:
Sequence | MR | notes |
---|---|---|
1 |
Add semver column to ci_runners table (!89023 - merged) | Adds a migration to add indexed machine-readable semver version text column (major.minor.patch) on top of the existing ci_runners.version column. |
2 | Store Runner semver value on version update (!89024 - merged) | Ensures that semver column is kept up-to-date based on version value |
3 | Backfill runner semver column (!89054 - merged) | Adds batched background migration to backfill semver column from version values. |
Screenshots or screen recordings
These are strongly recommended to assist reviewers and reduce the time to merge your change.
How to set up and validate locally
Numbered steps to set up and validate the change are strongly suggested.
MR acceptance checklist
This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.
-
I have evaluated the MR acceptance checklist for this MR.
Part of #339523 (closed)
Edited by Pedro Pombeiro