Diffs don't load on MR view
Problem
Several MRs needed for the 14.6 release post fail to render the diff view
MRs affected:
- Bug Fixes: gitlab-com/www-gitlab-com!94878 (merged)
- Usability improvements: gitlab-com/www-gitlab-com!94879 (merged)
- Performance improvements: gitlab-com/www-gitlab-com!94880 (merged)
This is critical for the %14.6 release post and the MRs will likely be opened/changed several times starting today until the 17th.
Context
Copied from https://gitlab.slack.com/archives/CETG54GQ0/p1639126927009400 :
https://gitlab.com/gitlab-com/www-gitlab-com/-/merge_requests/94878/diffs_batch.json?diff_head=true&view=inline&w=0&page=0&per_page=5 is timing out due to SQL
https://sentry.gitlab.net/gitlab/gitlabcom/issues/3091094/
/*application:web,correlation_id:01FPHTSG3BH1T1MCMYETTDJNCT,endpoint_id:Projects::MergeRequests::DiffsController#diffs_batch,db_config_name:main_replica*/ SELECT "environments".* FROM "environments" WHERE "environments"."project_id" = $1 AND ("environments"."state" IN ($2)) AND (EXISTS (SELECT "deployments".* FROM "deployments" WHERE (ref = $3 OR tag IS TRUE) AND (environment_id = environments.id))) ORDER BY (SELECT MAX("deployments"."id") FROM "deployments" WHERE "deployments"."environment_id" = "environments"."id") DESC NULLS LAST