Job timeout risk: ee/spec/models/preloaders/user_member_roles_in_projects_preloader_spec.rb ran much longer than expected

Why was this issue created?

ee/spec/models/preloaders/user_member_roles_in_projects_preloader_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/models/preloaders/user_member_roles_in_projects_preloader_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 4775391 created at 2025-10-24T22:48:44Z

Field	Value
Job URL	rspec-ee-unit-pg16-single-db-ci-connection-17-39
Job total RSpec suite run time	expected: 43 minutes 17.64 seconds, actual: 76 minutes 49.74 seconds
Spec file run time	expected: 5 minutes 23.03 seconds, actual: 13 minutes 11.07 seconds
Spec file weight	17.16% of total suite run time

• Reported from pipeline 4785215 created at 2025-10-28T10:06:23Z

Field	Value
Job URL	rspec-ee-unit-pg16-opensearch-latest-38-39
Job total RSpec suite run time	expected: 42 minutes 17.18 seconds, actual: 73 minutes 39.24 seconds
Spec file run time	expected: 6 minutes 41.4 seconds, actual: 12 minutes 39.33 seconds
Spec file weight	17.18% of total suite run time