Bug Report: PRS getting stuck due to a momentary network glitch

[GuptaManan100]

Overview of the Issue

It has been observed that after a PRS started, if the last outstanding write on the current primary succeeds but the semi-sync ACKs for the write are lost due to a momentary glitch in the network, DemotePrimary gets blocked on trying to run set super_read_only=true because the last write is still waiting for semi-sync ACKs, even though both the replicas already have it.

This causes PRS to be blocked and eventually time out.

Reproduction Steps

1. Run PRS, and simulate a network error somehow

Binary Version

main

Operating System and Environment details

-

Log Fragments