SYSTEM AND METHOD FOR TRANSACTION RECOVERY IN A MULTITENANT APPLICATION SERVER ENVIRONMENT

• US 20160092319A1
• Filed: 09/25/2015
• Published: 03/31/2016
• Est. Priority Date: 09/26/2014
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Parkinson, Paul, Kato, Hiromu, Desai, Arjav
• Granted Patent: US 11,188,427 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 2201/87 Monitoring of transactions
• CPC Class Codes: G06F 9/466 Transaction processing

Abstract

In accordance with an embodiment, described herein is a system and method for transaction recovery in a multitenant application server environment. At least one resource manager associated with a partition can be designated as a determiner resource for that partition only, in order to support eliminating transaction logs (TLOG) in processing a two-phase commit transaction. A transaction manager can prepare all other resource managers in the mid-tier transactional system before the determiner resource. Furthermore, the transaction manager can rely on the list of outstanding transactions to be committed that is provided by the determiner resource for recovering the transaction. The transaction manager can commit an in-doubt transaction returned from a resource manager that matches the list of in-doubt transactions returned from the determiner resource. Otherwise, the transaction manager can roll back the in-doubt transaction.

Claims

1. A system for transaction recovery in a multitenant application server environment, comprising:

one or more computers, including an application server environment executing thereon, together with

a plurality of deployable resources which can be used within the application server environment,

one or more resource group templates, which define groupings of deployable resources within a domain, and

one or more partitions, wherein each partition provides an administrative and runtime subdivision of the domain, that can be associated with a tenant;

a transaction manager operating in the application server environment;

a determiner resource manager, the determiner resource manager being associated with one of the one or more partitions, the determiner resource manager being used in a transaction; and

a plurality of resource managers, the plurality of resource managers being used in the transaction;

wherein the transaction manager is configured to process the transaction by,

sending a prepare message to the determiner resource manager only after receiving acknowledgement of successful prepare actions on the plurality of resource managers,

sending a commit message to the determiner resource manager only after receiving acknowledgement of successful commit actions on the plurality of resource managers; and

upon a failure,

retrieving a list of in-doubt transactions from each of the plurality of resource managers and the determiner resource manager, and

recovering all in-doubt transactions without using a transaction log.

2. The system of claim 1, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.

3. The system of claim 1, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager.

4. The system of claim 1, wherein the determiner resource manager is designated as the determiner resource manager by the one partition of the one or more partitions.

5. The system of claim 4, wherein the transaction manager persists the designation of the determiner resource manager in a configuration file.

6. The system of claim 1, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality of resource managers with the list of in-doubt transactions retrieved from the determiner resource manager;

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.

7. The system of claim 1, wherein, upon the failure, the system is configured to commit transactions which appear in the list of in-doubt transactions retrieved from the determiner resource manager after recovering all other resource managers in the plurality of resource managers.

8. A method for transaction recovery in a multitenant application server environment, comprising:

providing, at one or more computers, including an application server environment executing thereon,

a plurality of deployable resources which can be used within the application server environment,

one or more resource group templates, which define groupings of deployable resources within a domain, and

one or more partitions, wherein each partition provides an administrative and runtime subdivision of the domain, that can be associated with a tenant;

operating a transaction manager within the application server environment; and

associating a determiner resource manager with one of the one or more partitions, the determiner resource manager being used in a transaction; and

providing a plurality of resource managers, the plurality of resource managers being used in the transaction;

wherein the transaction manager is configured to process the transaction by,

sending a prepare message to the determiner resource manager only after receiving acknowledgement of successful prepare actions on the plurality of resource managers, and

sending a commit message to the determiner resource manager only after receiving acknowledgement of successful commit actions on the plurality of resource managers; and

upon a failure,

retrieving a list of in-doubt transactions from each of the plurality of resource managers and the determiner resource manager, and

recovering all in-doubt transactions without using a transaction log.

9. The method of claim 8, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.

10. The method of claim 8, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager.

11. The method of claim 8, wherein the determiner resource manager is designated as the determiner resource manager by the one partition of the one or more partitions.

12. The method of claim 11, wherein the transaction manager persists the designation of the determiner resource manager in a configuration file.

13. The method of claim 8, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality of resource managers with the list of in-doubt transactions retrieved from the determiner resource manager;

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.

14. The method of claim 13, further comprising,

upon the failure, committing transactions which appear in the list of in-doubt transactions retrieved from the determiner resource manager after recovering all other resource managers in the plurality of resource managers.

15. A non-transitory computer readable storage medium, including instructions stored thereon for transaction recovery in a multitenant application server environment which when read and executed by one or more computers cause the one or more computers to perform steps comprising:

providing, at one or more computers, including an application server environment executing thereon,

a plurality of deployable resources which can be used within the application server environment,

one or more resource group templates, which define groupings of deployable resources within a domain, and

one or more partitions, wherein each partition provides an administrative and runtime subdivision of the domain, that can be associated with a tenant;

operating a transaction manager within the application server environment; and

associating a determiner resource manager with one of the one or more partitions, the determiner resource manager being used in a transaction; and

providing a plurality of resource managers, the plurality of resource managers being used in the transaction;

wherein the transaction manager is configured to process the transaction by,

sending a prepare message to the determiner resource manager only after receiving acknowledgement of successful prepare actions on the plurality of resource managers, and

sending a commit message to the determiner resource manager only after receiving acknowledgement of successful commit actions on the plurality of resource managers; and

upon a failure,

retrieving a list of in-doubt transactions from each of the plurality of resource managers and the determiner resource manager, and

recovering all in-doubt transactions without using a transaction log.

16. The non-transitory computer readable storage medium of claim 15, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.

17. The non-transitory computer readable storage medium of claim 15, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality resource managers with the list of in-doubt transactions retrieved from the determiner resource manager; and

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager.

18. The non-transitory computer readable storage medium of claim 15, wherein the determiner resource manager is designated as the determiner resource manager by the one partition of the one or more partitions.

19. The non-transitory computer readable storage medium of claim 18, wherein the transaction manager persists the designation of the determiner resource manager in a configuration file.

20. The non-transitory computer readable storage medium of claim 15, wherein recovering all in-doubt transactions without using a transaction log comprises:

comparing the list of in-doubt transactions retrieved from each of the plurality of resource managers with the list of in-doubt transactions retrieved from the determiner resource manager;

committing one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality of resource managers and which also appear in the list of in-doubt transactions retrieved from the determiner resource manager; and

rolling back one or more in-doubt transactions which appear in the list of in-doubt transactions retrieved from each of the plurality resource managers but do not appear in the list of in-doubt transactions retrieved from the determiner resource manager.