ActiveRecord::StatementInvalid: PG::OutOfMemory: ERROR: out of shared memory

Summary

Incident: gitlab-org/quality/engineering-productivity/master-broken-incidents#2538 (closed)

Job: https://gitlab.com/gitlab-org/gitlab/-/jobs/4327006286

The job above failed in a master pipeline today with the following error:

1st Try error in ./ee/spec/models/factories_spec.rb:105:
expected no Exception, got #<ActiveRecord::StatementInvalid: PG::OutOfMemory: ERROR:  out of shared memory
HINT:  You might need to increase max_locks_per_transaction.

Steps to reproduce

Not reproducible, and the pipeline passed after retry

Proposed Resolution