Flaky spec: Too many SQL queries were executed in Projects::MergeRequestsController#show

I've seen this a few times (I think in different specs). I'm not sure why exceeding the query limit would be flaky.

https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/252289788

1st Try error in ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62:
Too many SQL queries were executed in Projects::MergeRequestsController#show: a maximum of 100 is allowed but 101 SQL queries were executed

RSpec::Retry: 2nd try ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62
WARN: Screenshot could not be saved. `page.current_path` is empty.

2nd Try error in ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62:
Too many SQL queries were executed in Projects::MergeRequestsController#show: a maximum of 100 is allowed but 102 SQL queries were executed
RSpec::Retry: 3rd try ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62
WARN: Screenshot could not be saved. `page.current_path` is empty.

3rd Try error in ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62:
Too many SQL queries were executed in Projects::MergeRequestsController#show: a maximum of 100 is allowed but 101 SQL queries were executed
RSpec::Retry: 4th try ./spec/features/merge_request/user_reverts_merge_request_spec.rb:62
WARN: Screenshot could not be saved. `page.current_path` is empty.
  cannot revert a merge requests for an archived project (FAILED - 1)

added Create [DEPRECATED] failureflaky-test labels

More occurrences:

https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/252914008

https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/252897461

This doesn't happen in EE because we whitelist Projects::MergeRequestsController#show from the query limiting middleware

Setting gitlab-ce2278656 based on gitlab-ce9887531.

added Quality label

Another one: https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/265541836

added [deprecated] Accepting merge requests label

removed [deprecated] Accepting merge requests label

Happened again today https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/268098624

Another one today: https://gitlab.com/gitlab-org/gitlab-ce/-/jobs/281778393

added devopscreate label

added 1 deleted label

removed 1 deleted label

mentioned in issue gitlab-org/quality/triage-reports#155 (closed)

mentioned in issue gitlab-org/quality/triage-reports#182 (closed)

mentioned in issue gitlab-org/quality/triage-reports#191 (closed)

mentioned in issue gitlab-org/quality/triage-reports#223 (closed)

mentioned in issue gitlab-org/quality/triage-reports#254 (closed)

added groupsource code severity3 labels and removed Create [DEPRECATED] label

mentioned in issue gitlab-org/quality/triage-reports#259 (closed)

mentioned in issue gitlab-org/quality/triage-reports#284 (closed)

mentioned in issue gitlab-org/quality/triage-reports#292 (closed)

mentioned in issue gitlab-org/quality/triage-reports#323 (closed)

added sectiondev label

mentioned in issue gitlab-org/quality/triage-reports#332 (closed)

mentioned in issue gitlab-org/quality/triage-reports#349 (closed)

mentioned in issue gitlab-org/quality/triage-reports#361 (closed)

mentioned in issue gitlab-org/quality/triage-reports#372 (closed)

mentioned in issue gitlab-org/quality/triage-reports#381 (closed)

added test label

mentioned in issue gitlab-org/quality/triage-reports#392 (closed)

mentioned in issue gitlab-org/quality/triage-reports#412 (closed)

mentioned in issue gitlab-org/quality/triage-reports#421 (closed)

mentioned in issue gitlab-org/quality/triage-reports#457 (closed)

Setting label(s) Category:Source Code Management based on groupsource code.

added Category:Source Code Management label

I have this same problem when running bundle exec rspec ./spec/features/merge_request/user_assigns_themselves_spec.rb:18 locally. Context: trying to understand the rspec failures in an MR pipeline.

Can that limit of 100 be increased? Watching #333845 (comment 604157549) to find out ;-)

@katrinleinweber the limit was bumped for the specific spec https://gitlab.com/gitlab-org/gitlab/blob/master/ee/spec/requests/api/graphql/mutations/issues/promote_to_epic_spec.rb#L55-L55

mentioned in issue #333845 (closed)

changed milestone to %Backlog

added typeignore label

added [deprecated] Accepting merge requests label

closed