CI Jobs page has error fetching the jobs for project
Summary
A handful of customers are receiving 503 responses from the GraphQL API endpoint on the Jobs page. This causes the page to report that There was an error fetching the jobs for your project. and it appears there are 0 jobs.
For context on overall scale in the past week there were 38 requests to this end point that had 503 errors and 126738 that did not.
Steps to reproduce
This seems to be specific to certain projects. As of yet, it is unclear what is different about these projects. This will require investigation.
Example Project
Originally reported as a comment on another issue which was determined to be separate: #362172 (comment 1143527270)
This is significantly impacting a 400 User Ultimate SaaS customer. It is also a key blocker to additional CI adoption. ZenDesk Case
What is the current bug behavior?
Error displayed, no jobs displayed
What is the expected correct behavior?
No error, jobs to be displayed.
Relevant logs and/or screenshots
Output of checks
This bug happens on GitLab.com
Possible fixes
Proposal: Abstract count from app/assets/javascripts/jobs/components/table/graphql/queries/get_jobs.query.graphql into a dedicated query. Refactor app/assets/javascripts/jobs/components/table/jobs_table_app.vue to use the new query and structure.