Draft: Detect stuck locks during rspec runs

What does this MR do and why?

This MR attempts to detect a scenario where database connections are stuck in a transaction between rspec files. I hypothesize that this can lead to statement timeouts in pipelines, as other connections compete with the stuck transaction for row locks on tables with unique indexes.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.