StuckImportJobsWorker query performance optimization (!22879) · Merge requests · GitLab.org / GitLab FOSS · GitLab

The 17.0 major release is coming on May 16, 2024! This version brings many exciting improvements to GitLab, but also removes some deprecated features. We are introducing three breaking change windows during which we expect breaking changes to be deployed to GitLab.com. You can read more about it on our blogpost . The first breaking change window begins 2024-04-22 09:00UTC and ends 2024-04-24 22:00UTC.

Tiago Botelho requested to merge fix-stuck-import-jobs-query-performance-issue into master Nov 07, 2018

What does this MR do?

Prevents a statement timeout in StuckImportJobsWorker (as mentioned in https://gitlab.com/gitlab-org/gitlab-ce/issues/49264 and https://gitlab.com/gitlab-com/gl-infra/production/issues/527#note_112993236) by improving the performance of the query that fetches the enqueued projects.

What are the relevant issue numbers?

https://gitlab.com/gitlab-com/gl-infra/production/issues/527 https://gitlab.com/gitlab-org/gitlab-ce/issues/49264

Does this MR meet the acceptance criteria?

Changelog entry added, if necessary
Documentation created/updated
Tests added for this feature/bug
Conforms to the code review guidelines
Conforms to the merge request performance guidelines
Conforms to the style guides
Conforms to the database guides
Link to e2e tests MR added if this MR has Requires e2e tests label. See the Test Planning Process.

Edited Nov 07, 2018 by Tiago Botelho