Job timeout risk: ee/spec/services/ee/search/project_service_merge_requests_visibility_spec.rb ran much longer than expected

Why was this issue created?

ee/spec/services/ee/search/project_service_merge_requests_visibility_spec.rb was reported to have:

1. exceeded Knapsack's expected runtime by at least 50%, and
2. been identified as a notable pipeline bottleneck and a job timeout risk

Suggested steps for investigation

1. To reproduce in CI by running test files in the same order, you can follow the steps listed here.
2. Identify if a specific test case is stalling the run time. Hint: You can search the job's log for Starting example group ee/spec/services/ee/search/project_service_merge_requests_visibility_spec.rb and view the elapsed time after each test case in the proceeding lines starting with [RSpecRunTime].
3. If the test file is large, consider refactoring it into multiple files to allow better test parallelization across runners.
4. If the run time cannot be fixed in time, consider quarantine the spec(s) to restore performance.

Run time details

• Reported from pipeline 4754759 created at 2025-10-20T19:33:44Z

Field	Value
Job URL	rspec-ee-unit-pg16-30-39
Job total RSpec suite run time	expected: 43 minutes 57.65 seconds, actual: 78 minutes 6.6 seconds
Spec file run time	expected: 5 minutes 56.33 seconds, actual: 12 minutes 17.88 seconds
Spec file weight	15.74% of total suite run time

• Reported from pipeline 4758354 created at 2025-10-21T11:30:43Z

Field	Value
Job URL	rspec-ee-unit-pg16-36-39
Job total RSpec suite run time	expected: 43 minutes 46.93 seconds, actual: 79 minutes 40.12 seconds
Spec file run time	expected: 6 minutes 23.71 seconds, actual: 18 minutes 6.45 seconds
Spec file weight	22.73% of total suite run time

• Reported from pipeline 4759449 created at 2025-10-21T15:27:00Z

Field	Value
Job URL	rspec-ee-unit-pg16-36-39
Job total RSpec suite run time	expected: 43 minutes 46.92 seconds, actual: 76 minutes 25.69 seconds
Spec file run time	expected: 6 minutes 23.71 seconds, actual: 11 minutes 33.2 seconds
Spec file weight	15.12% of total suite run time

• Reported from pipeline 4760693 created at 2025-10-21T19:24:36Z

Field	Value
Job URL	rspec-ee-unit-pg16-37-39
Job total RSpec suite run time	expected: 44 minutes 26.12 seconds, actual: 73 minutes 7.15 seconds
Spec file run time	expected: 6 minutes 39.97 seconds, actual: 11 minutes 52.48 seconds
Spec file weight	16.24% of total suite run time

• Reported from pipeline 4771532 created at 2025-10-23T23:38:30Z

Field	Value
Job URL	rspec-ee-unit-pg16-34-39
Job total RSpec suite run time	expected: 43 minutes 15.41 seconds, actual: 79 minutes 37.29 seconds
Spec file run time	expected: 6 minutes 42.06 seconds, actual: 14 minutes 12.11 seconds
Spec file weight	17.84% of total suite run time