Add indexes for the RemoteMirror.stuck query

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

  • Work on this issue
  • Close this issue

Currently we're using this query to mark all these mirrors as failed.

The query is always scoped to a project, so they're never more than a handful of rows to update.

But Ideally we'd have an index for project_id, last_update_started_at, last_update_at after https://gitlab.com/gitlab-org/gitlab-ce/merge_requests/31247 gets merged.

Edited Sep 22, 2025 by 🤖 GitLab Bot 🤖
Assignee Loading
Time tracking Loading