Transaction state changes from active to aborted - Database

Discussion

• Nirja Shah   -Posted on 30 Oct 15
  There are different transaction state:
  Active
  - This is the initial state.
  - The transaction stays in this state while it is executing.
  
  Partially committed
  - We come in this state after the final statement has been executed.
  
  Failed
  - This state occurs after the discovery that normal execution can no longer proceed.
  
  Aborted
  - After the transaction is rolled back and the database restored to its state prior to the start of the transaction.
  - There are two options after it has been aborted:
  
  Restart the transaction - Only if no internal logical error but hardware or software failure.
  
  Kill the transaction - Once the internal logical error occurs like incorrect data input.
  
  Committed
  - It happens after the successful completion.
  - The transaction is terminated once it is aborted or committed.

➨ Post your comment / Share knowledge