Bug Report: ERS fails if PromoteReplica runs a write

[GuptaManan100]

Overview of the Issue

If there is a change in the metadata tables of Vitess that need to be applied when a new primary is promoted in ERS, then a DML query is run. But this gets blocked because none of the replicas are connected to the new primary.

Since the new primary can be a newer version of vttablet that has some updated version of the metadata tables, then the DML query being run in unavoidable. This is the reason that PRS runs PromoteReplica and SetReplicationSource in parallel.

Reproduction Steps

Change any of the metadata tables before running an ERS.

Binary Version

main

Operating System and Environment details

-

Log Fragments

No response