Ci::RetryBuildService causes CrossDatabaseModificationAcrossUnsupportedTablesError due to `deployments`
Per https://docs.gitlab.com/ee/development/database/multiple_databases.html#removing-cross-database-transactions we do not allow you to write to 2 different databases within the context of a single transaction. This problem occurs at https://gitlab.com/gitlab-org/gitlab/-/blob/ce2742230d134220abccfe87af78b3b864883799/app/services/ci/retry_build_service.rb#L45 which writes to ["ci_builds", "ci_builds_metadata", "deployments"]
in a single transaction.
Possible solutions
This is likely a similar problem with the same or similar fix as #345448 (closed) .
Validating a fix
This problem causes us to add (at least) ee/spec/services/ci/retry_build_service_spec.rb
to the cross modification allowlist and as such a fix should allow us to remove it from the allowlist. There may be some other cross-modification failures or false positives in the spec that we need to workaround to see and fix this failure.