Transaction states

A transaction exists in one of these states at any point during its lifetime:

• Active
  Transaction processing is still in progress.

• Committed
  The transaction has been committed and the effects of the transaction have been made permanent.

• Committing
  The transaction is in the process of committing (that is, the transaction has started committing but has not completed the process).

• Marked Rollback
  The transaction is marked to be rolled back. The process of rolling back has not been started. The transaction is still active, but it cannot be committed.

• No Transaction
  The transaction does not exist.

• Prepared
  The transaction has been prepared but not completed.

• Prepare
  The transaction is in the process of being prepared (that is, the participants have started preparing the transaction but have not completed the process).

• Rolled Back
  The transaction has been rolled back.

• Rolling Back
  The transaction is in the process of rolling back (that is, the participants have started rolling back the transaction but have not completed the process).

• Unknown
  The status of the transaction is unknown.

During normal operations, transactions generally progress through these states:

1. No Transaction
2. Active
3. Prepare
4. Committing
5. Committed

Other transaction states usually indicate error conditions that might have caused the transaction to cancel.