failing test: CollisionTests.test_colliding_query_subscription

[ghost]

Steps to Reproduce

1. git remote update
2. git checkout origin/master -B master
3. pytest tests/sentry/backup/test_imports.py::CollisionTests::test_colliding_query_subscription

Expected Result

PASS

Actual Result

FAILED tests/sentry/backup/test_imports.py::CollisionTests::test_colliding_query_subscription
E   urllib3.exceptions.MaxRetryError: HTTPConnectionPool(host='127.0.0.1', port=1218): Max retries exceeded with url: /events/events/subscriptions (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x11d466790>: Failed to establish a new connection: [Errno 61] Connection refused'))

https://gist.github.com/bukzor-sentryio/05405bb26e06315180e4d2f97b227d43

https://github.com/getsentry/sentry/actions/runs/6498274609/job/17649270575?pr=57950

What I Tried

1. this seems to reproduce on my branch but also master branch
2. in CI it only occurs when SENTRY_USE_MONOLITH_DBS=1 is set, so I'm only xfailing it in that case.
3. locally it reproduces regardless of monolith-dbs setting

cc @azaslavsky

[ghost]

I set a conditional xfail for this, as part of getsentry/sentry#57950