2.17.1 Failure Modes

For Transactions to be atomic and durable, need to examine failures
  1. Transaction-local failures, detected by the application which calls abort eg insufficient funds. No info loss, need to undo changes made.
  2. Transaction-local failures , not detected by application, but by system as whole, eg divide by zero. System calls abort.
  3. System failures affecting transactions in progress but not media eg CPU failure. Loss of volatile store and possibly all transactions in progress. On recovery, special recovery manager undoes effects of all transactions in progress at failure.
  4. Media failures affecting database eg head crash. No way of protecting against this.

Ian Wakeman 2005-02-22