I'm reading the description of PREPARE TRANSACTION, and I see this:
"...its state is fully stored on disk, and there is a very high
probability that it can be committed successfully..."
What corner case reduces 2pc from "guaranteed" to "very high probability"?
Is the worry if somebody leaves transactions in a prepared state for
weeks, only to find that deadlock issues has arrisen at final commit time?