Situation 1: Coordinator issues a commit and all participants report heuristic rollbacks
The coordinator gathers all responses
from participants. If every participant reports a heuristic rollback,
the following events occur as a consequence:
- The coordinator writes the following message to its own database-server
message log:
Transaction heuristically rolled back.
- The coordinator sends a message to all participants to end the transaction.
- Each participant writes an ENDTRANS record in its logical-log buffer. (The transaction entry is removed from the transaction table.)
- The coordinator returns error -699 to the application, as follows:
-699 Transaction heuristically rolled back.
- In this situation, all databases remain consistent.