Multilevel transaction recovery in a database system which loss parent transaction undo operation upon commit of child transaction

• US 5,287,501 A
• Filed: 07/11/1991
• Issued: 02/15/1994
• Est. Priority Date: 07/11/1991
• Status: Expired due to Term

• Current Assignee: Hewlett-Packard Development Company, L.P. (HP Inc.)
• Original Assignee: Digital Equipment Corporation (HP Inc.)
• Inventors: Lomet, David B.
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): LINTZ, PAUL R
• Application Number:
  US07/728,661
• Time in Patent Office: 950 Days
• Field of Search: 364/DIG. 1, 364/DIG. 2, 395/650, 395/600, 395/425, 395/
• US Class Current: 707/648
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 2201/87 Monitoring of transactions
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

When a subtransaction (46) of a higher-level transaction (50) commits during the operation of a database (10), the database enters into its operation log a record (FIG. 6 ) that acts both as a commit record for the subtransaction (46) and as an update record for the higher-level transaction and includes a field (74) that identifies a higher-level "undo" transaction whereby the subtransaction can be undone without individually undoing its constituent operations. By logging operations in this manner, the database can handle multi-level recovery with very few restrictions on the timing of its updates and log entries.

Claims

1. In a database system that include transaction means for performing transactions, including both forward and compensation transactions, on database resources at different levels of abstraction, some transactions, called subtransactions, being constituent operations of other, higher-level, parent transactions;

logging means for maintaining a durable operation log into which, in response to loggable events in a transaction'"'"'s performance, including the commitment of the transaction, the logging means enters log records that include a transaction ID identifying that transaction; and

recovery means for recovering from an abort of a transaction by causing the transaction means to perform undo operations in accordance with the contents of log records that include that transaction'"'"'s ID, the improvement wherein;

A) the log record entered into the durable operation log in response to a forward substransaction'"'"'s commitment additionally includes that subtransaction'"'"'s parent transaction'"'"'s transaction ID and undo information identifying an undo-operation routine at the parent transaction'"'"'s level for undoing that subtransaction; and

B) the recovery means recovers from an aborted parent transaction by causing the transaction means to perform a compensation transaction at the parent transaction'"'"'s subtransaction'"'"'s level by executing the undo-operation routine identified by the undo information in a log record entered in response to the commitment of a subtransaction of that parent transaction.

2. A database system as defined in claim 1 wherein:

A) the compensation transaction at the subtransaction'"'"'s level comprises a plurality of constituent operations at that level; and

B) in response to performance of at least some of the compensation transaction'"'"'s constituent operations, the logging means enters log records that omit the aborted parent transaction'"'"'s transaction ID.

3. A database system as defined in claim 2 wherein:

A) the log records entered in response to at least some operations contain redo information identifying redo-operation routines for redoing those operations; and

B) in recovering from an aborted transaction, the recovery means;

i) first scans forward through the operation log and causes the transaction means to perform redo operations in accordance with redo information contained in log records encountered in the forward scan; and

ii) then, for each transaction level, performs a separate backward transaction-log scan associated therewith and causes the transaction means to perform undo operations in accordance with undo information in the log records entered in response to operations of aborted transactions at the associated level.

4. A database system as defined in claim 3 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

5. A database system as defined in claim 3 wherein the logging means enters log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

6. A database system as defined in claim 2 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

7. A database system as defined in claim 6 wherein:

A) in response to undo operations, the logging means enters log records whose contents distinguish them as compensation log records; and

B) the recovery means refrains from undoing the undo operations that the compensation log records document.

8. A database system as defined in claim 1 wherein:

A) the log records entered in response to at least some operations contain redo information identifying redo-operation routines for redoing those operations; and

B) in recovering from an aborted transaction, the recovery means;

i) first scans forward through the operation log and causes the transaction means to perform redo operations in accordance with redo information contained in lo records encountered in the forward scan; and

ii) then, for each transaction level, performs a separate backward transaction-log scan associated therewith and causes the transaction means to perform undo operations in accordance with undo information in the log records entered in response to operations of aborted transactions at the associated level.

9. A database system as defined in claim 8 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

10. A database system as defined in claim 9 wherein:

A) in response to undo operations, the logging means enters log records whose contents distinguish them as compensation log records; and

B) the recovery means refrains from undoing the undo operations that the compensation log records document.

11. A database system as defined in claim 8 wherein the logging means enters log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

12. A database system as defined in claim 1 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

13. A database system as defined in claim 12 wherein:

A) in response to undo operations, the logging means enters log records whose contents distinguish them as compensation log records; and

B) the recovery means refrains from undoing the undo operations that the compensation log records document.

14. A database system as defined in claim 12 wherein:

A) among the loggable events to which the logging means responds by entering a log record is the updating of a database resource with the results of an operation;

B) each log record includes a record-type field that identifies that log record'"'"'s type; and

C) the contents of the record-type field of a log record entered in response to updating a database resource with the results of a compensation transaction'"'"'s constituent operation when that compensation transaction has not aborted are the same as those of the record-type field of a log record entered in response to updating a database resource with the results of a constituent operation of a transaction that is not a compensation transaction when that compensation transaction has not aborted.

15. A database system as defined in claim 14 wherein:

A) in response to undo operations, the logging means enters log records whose contents distinguish them as compensation log records; and

B) the recovery means refrains from undoing the undo operations that the compensation log records document.

16. A database system as defined in claim 1 wherein the logging means enters log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

17. A database system as defined in claim 1 wherein:

A) among the loggable events to which the logging means responds by entering a log record is the updating of a database resource with the results of an operation;

B) each log record includes a record-type field that identifies the log record'"'"'s type; and

C) the contents of the record-type field of a log record entered in response to updating a database resource with the results of a compensation transaction'"'"'s constituent operation when that compensation transaction has not aborted are the same as those of the record-type field of a log record entered in response to updating a database resource with the results of a constituent operation of a transaction that is not a compensation transaction when that compensation transaction has not aborted.

18. A database system as defined in claim 1 wherein:

A) in response to undo operations, the logging means enters log records whose contents distinguish them as compensation log records; and

B) the recovery means refrains from undoing the undo operations that the compensation log records document.

19. A database system comprising:

A) transaction means for performing transactions, including compensation transactions, on database resources at different levels of abstraction, some transactions, called subtransactions, being constituent operations of other, higher-level, parent transactions;

B) logging means for maintaining a common durable operation log into which, in response to loggable events in a transaction'"'"'s performance, including the commitment of the transaction and the updating of a database resource with the results of a constituent operation in that transaction, the logging means enters log records that include a transaction ID identifying that transaction, a record-type field identifying the record type, and, in response to at least some operations, redo information identifying redo-operation routines for redoing those operations, the common operation log receiving log records in response to loggable events in the performance of transactions at all levels, which records are ordered in accordance with the occurrences of the events that they document, the log record entered into the durable operation log in response to a forward subtransaction'"'"'s commitment including that subtransaction'"'"'s parent transaction'"'"'s transaction ID and undo information identifying an undo-operation routine at the parent transaction'"'"'s level for undoing that subtransaction, the log record entered into the durable log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction including the transaction IDs both of the compensation transaction and of the parent transaction, the contents of the record-type field of a log record entered in response to updating a database resource with the results of a compensation transaction'"'"'s constituent operation when that compensation transaction has not aborted being the same as those of the record-type field of a log record entered in response to updating a database resource with the results of a constituent operation of a transaction that is not a compensation transaction when that compensation transaction has not aborted, the record-type field in a log record entered into the durable operation log in response to an undo operation distinguishing it as a compensation log record, the log record entered into the durable operation log in response to performance of at least some of a compensation transaction'"'"'s constituent operations omitting the aborted parent transaction'"'"'s transaction ID; and

C) recovery means for recovering from an abort of a transaction by, first, scanning forward through the operation log and causing the transaction means to perform redo operations in accordance with redo information contained in log records encountered in the forward scan, and then, for each transaction level, performing a separate backward transaction-log scan associated with that level and causing the transaction means to perform undo operations in accordance with the contents of log records encountered in the scan that include the transaction IDs of aborted transactions at the associated level but to refrain from undoing the undo operations that the compensation log records document.

20. A method of operating a database system comprising the steps of:

A) performing transactions on database resources at different levels of abstraction, some transactions, called subtransactions, being constituent operations of other, higher-level, parent transactions;

B) maintaining a durable operation log by responding to a loggable event in a transaction'"'"'s performance by entering into the operation log a log record that includes a transaction ID identifying that transaction and, when the loggable event is the commitment of a forward subtransaction, additionally includes that subtransaction'"'"'s parent transaction'"'"'s transaction ID and undo information identifying an undo-operation routine at the parent transaction'"'"'s level for undoing that subtransaction; and

C) recovering from an aborted parent transaction by performing a compensation transaction at the parent transaction'"'"'s subtransaction'"'"'s level by executing the undo-operation routine identified by the undo information in a log record entered in response to the commitment of a subtransaction of that parent transaction.

21. A method as recited in claim 20 wherein:

A) the compensation transaction at the subtransaction'"'"'s level comprises a plurality of constituent operations at that level; and

B) the step of maintaining a durable operation log includes entering, in response to performance of at least some of the compensation transaction'"'"'s constituent operations, log records that omit the aborted parent transaction'"'"'s transaction ID.

22. A method as recited in claim 21 wherein:

A) the log records entered in response to at least some operations contain redo information identifying redo-operation routines for redoing those operations; and

B) the recovery step comprises;

i) first scanning forward through the operation log and performing redo operations in accordance with redo information contained in log records encountered in the forward scan; and

ii) then, for each transaction level, performing a separate backward transaction-log scan associated therewith and performing undo operations in accordance with undo information in the log records entered in response to operations of aborted transactions at the associated level.

23. A method as defined in claim 22 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

24. A method as defined in claim 22 wherein the logging step comprises entering log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

25. A method as defined in claim 21 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

26. A method as defined in claim 25 wherein:

A) the logging step comprises responding to undo operations by entering log records whose contents distinguish them as compensation log records; and

B) the recovery step comprises refraining from undoing the undo operations that the compensation log records document.

27. A method as recited in claim 20 wherein:

A) the log records entered in response to at least some operations contain redo information identifying redo-operation routines for redoing those operations; and

B) the recovery step comprises;

i) first scanning forward through the operation log and performing redo operations in accordance with redo information contained in log records encountered in the forward scan; and

ii) then, for each transaction level, performing a separate backward transaction-log scan associated therewith and performing undo operations in accordance with undo information in the log records entered in response to operations of

aborted transactions at the associated level.

28. A method as defined in claim 27 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

29. A method as defined in claim 28 wherein:

A) the logging step comprises responding to undo operations by entering log records whose contents distinguish them as compensation log records; and

B) the recovery step comprises refraining from undoing the undo operations that the compensation log records document.

30. A method as defined in claim 27 wherein the logging step comprises entering log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

31. A method as defined in claim 20 wherein the log record entered into the durable operation log in response to the commitment of a compensation transaction performed to undo an aborted parent transaction'"'"'s committed subtransaction includes the transaction IDs both of the compensation transaction and of the parent transaction.

32. A method as defined in claim 31 wherein:

A) the logging step comprises responding to undo operations by entering log records whose contents distinguish them as compensation log records; and

B) the recovery step comprises refraining from undoing the undo operations that the compensation log records document.

33. A method as defined in claim 31 wherein:

A) the logging step includes entering a log record in response to the updating of a database resource with the results of an operation;

B) each log record includes a record-type field that identifies the log record'"'"'s type; and

C) in response to the updating of a database resource with the results of a compensation transaction'"'"'s constituent operation when that compensation transaction has not aborted, entering a log record whose record-type-field contents are the same as those of a log record entered in response to updating a database resource with the results of a constituent operation of a transaction that is not a compensation transaction when that compensation transaction has not aborted.

34. A method as defined in claim 33 wherein:

A) the logging step comprises responding to undo operations by entering log records whose contents distinguish them as compensation log records; and

B) the recovery step comprises refraining from undoing the undo operations that the compensation log records document.

35. A method as defined in claim 20 wherein the logging step comprises entering log records in response to loggable events in the performance of transactions at all levels in a common durable operation log in which the log records are ordered in accordance with the occurrences of the events that they document.

36. A method as defined in claim 20 wherein:

A) the logging step includes entering a log record in response to the updating of a database resource with the results of an operation;

B) each log record includes a record-type field;

C) the recovering step includes interpreting the remainder of a log record on the basis of its record-type field; and

D) in response to the updating of a database resource with the results of a compensation transaction'"'"'s constituent operation when that compensation transaction has not aborted, entering a log record whose record-type-field contents are the same as those of a log record entered in response to updating a database resource with the results of a constituent operation of a transaction that is not a compensation transaction when that compensation transaction has not aborted.

37. A method as defined in claim 20 wherein:

A) the logging step comprises responding to undo operations by entering log records whose contents distinguish them as compensation log records; and

B) the recovery step comprises refraining from undoing the undo operations that the compensation log records document.