CI/CD settings page may time out loading 1000+ runners
Status update: 2020-02-02
Bug is resolved with MR !45830 (merged)
Summary
When loading the CI/CD settings page, it may time out loading the list and status for all runners tied to a project if there are at a guess 1000+ runners.
Example Project
This was originally reported by a GitLab.com customer because their https://gitlab.com/group/project/-/settings/ci_cd page would take a long time to load, and sometimes time out altogether, throwing a 500.
Please see the internal issue for details.
What is the current bug behavior?
Very slow loading time or time out after 60s.
For the particular customer project,
it is performing 7,236 SQL queries on the page
What is the expected correct behavior?
Page should load "quickly".
for reference, we advise no more than 100
Output of checks
GitLab Enterprise Edition 12.9.0-pre 9429543d
Possible fixes
Paginate the list of runners.
Possible workaround
remove expired runners
Edited by Darren Eastman