Change ReactiveCaching::LowUrgencyWorker to sticky

What does this MR do and why?

Change ReactiveCaching::LowUrgencyWorker to sticky

Changes the ReactiveCaching::LowUrgencyWorker to sticky data_consistency to move queries to replicas.

This worker runs a lot of queries without partition pruning against the CI primary as part of Security::MergeRequestSecurityReportGenerationService, contributing to 2026-03-16: Database lock contention causing sl... (gitlab-com/gl-infra/production#21562)

Moving the work to a replica should distribute the load.

References

gitlab-com/gl-infra/production#21562

How to set up and validate locally

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.

Edited by Simon Tomlinson

Merge request reports

Loading