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?