Transaction States

Transaction States

The following are the different states in transaction processing in a Database System.
Active
Partially Committed
Failed
Aborted
Committed

Active
This is the initial state. The transaction stay in this state while it is executing.

Partially Committed
This is the state after the final statement of the transaction is executed.

Failed
After the discovery that normal execution can no longer proceed.

Aborted
The state after the transaction has been rolled back and the database has been restored to its state prior to the start of the transaction.

Committed
The state after successful completion of the transaction.

We cannot abort or rollback a committed transaction.