WO2022199229A1

WO2022199229A1 - Suspended transaction inspection method and apparatus, electronic device and storage medium

Info

Publication number: WO2022199229A1
Application number: PCT/CN2022/072050
Authority: WO
Inventors: 张健
Original assignee: 北京金山云网络技术有限公司
Priority date: 2021-03-25
Filing date: 2022-01-14
Publication date: 2022-09-29
Also published as: CN112711466A; CN112711466B

Abstract

Provided in the present application are a suspended transaction inspection method and apparatus, an electronic device and a storage medium. The method comprises: receiving target topological information by means of a target database, wherein the target topological information is topological information between a target global transaction and a plurality of target branch transactions which correspond to the target global transaction; storing the target topological information in a target storage object, wherein the target storage object is used for recording topological information between each of a plurality of global transactions and a plurality of branch transactions which correspond to each global transaction, and the target database is used for processing one of the plurality of branch transactions which correspond to each global transaction; and according to the topological information recorded in the target storage object, performing suspended transaction inspection on each global transaction by means of the target database. By means of the present application, the problem of a suspended transaction control manner having low suspended transaction processing efficiency due to a larger number of global transactions and branch transactions managed by a manager is solved.

Description

Suspended transaction inspection method and device, electronic device and storage medium

This application claims the priority of the Chinese patent application filed on March 25, 2021 with the application number 202110317349.8 and the invention titled "Hanging affairs inspection method and device, electronic equipment and storage medium", the entire content of which is approved by Reference is incorporated in this application.

technical field

The present application relates to the field of data processing, and in particular, to a method and device for inspection of suspended affairs, an electronic device and a storage medium.

Background technique

As the core ability of the database to ensure the atomicity of data, transaction is also a point that needs to be paid attention to in the design of distributed database. A distributed database can have various architectures, for example, a sharding architecture based on middleware routing, and a distributed architecture based on spanner (a database system). In a distributed database architecture, a distributed transaction mechanism can be introduced to ensure the atomic property of modifying data across multiple nodes to achieve the ACID property of the database.

When dealing with distributed transactions, suspending transaction inspections can be used to be compatible with local faults (such as node downtime, network failure, etc.) in a distributed environment. Here, suspending transactions refer to the initiator (master node) of the global transaction Failure before the global transaction is committed, resulting in the failure of the global transaction and its corresponding branch transaction to proceed. In the related art, the suspension transaction inspection generally adopts the suspension transaction management mechanism based on the global transaction manager.

The suspended transaction management mechanism (scheme) based on the global transaction manager can realize the automatic inspection of suspended transactions and promote the commit and rollback of transactions according to the set strategy through centralized global transaction state management. However, when the scale of the cluster is large and the data is scattered and multi-sharded, the number of global transactions and branch transactions managed by the global transaction manager will increase significantly, resulting in the problem of low efficiency of suspending transactions.

SUMMARY OF THE INVENTION

Embodiments of the present application provide a method and apparatus for inspecting suspended transactions, an electronic device, and a storage medium, so as to at least solve the problem in the control mode of suspended transactions in the related art that due to the large number of global transactions and branch transactions managed by the manager The hanging transaction processing inefficiency problem.

According to an aspect of the embodiments of the present application, there is provided a method for inspecting suspended transactions, including: receiving target topology information through a target database, where the target topology information is a target global transaction and a multiplicity of data corresponding to the target global transaction topology information between target branch transactions; save the target topology information into a target storage object, wherein the target storage object is used to record each global transaction in multiple global transactions and the relationship with each global transaction. topology information between multiple branch transactions corresponding to a transaction, the target database is used to process one branch transaction in the multiple branch transactions corresponding to each global transaction; according to the data recorded in the target storage object topology information, and each global transaction is separately inspected for suspended transactions through the target database.

In one embodiment, receiving the target topology information through the target database includes: receiving, through the target database, a target transaction message sent by a target server, wherein the target server is a transaction coordinator of the target global transaction, The target transaction message carries the target topology information and the pending branch transaction information corresponding to the target database, and the pending branch transaction information is used to indicate that among the multiple target branch transactions, the target Branch transactions handled by the database.

In one embodiment, according to the topology information recorded in the target storage object, respectively performing a suspended transaction inspection on the global transactions through the target database includes: according to the target topology recorded in the target storage object. information, first state information corresponding to the target global transaction is determined through the target database; if it is determined according to the first state information that the target global transaction is abnormal before submission, the target global transaction is The transaction is determined to be a pending transaction.

In an embodiment, according to the target topology information recorded in the target storage object, determining the first state information corresponding to the target global transaction by using the target database includes: according to the target topology information, The target heartbeat information is detected by the target database, wherein the first state information includes the target heartbeat information, and the target heartbeat information is the heartbeat information between the target database and the target server, and the target server is the same as the target server. The transaction coordinator corresponding to the target global transaction; after detecting the target heartbeat information through the target database according to the target topology information, the method further includes: after detecting that the target heartbeat information stops updating Next, it is determined that an exception occurs before the target global transaction is committed.

In one embodiment, after performing the suspended transaction inspection on each of the global transactions through the target database according to the topology information recorded in the target storage object, the method further includes: In the case where the transaction is determined to be a suspended transaction, obtain second state information corresponding to each target branch transaction in the plurality of target branch transactions; Each branch transaction executes a target transaction operation, wherein the target transaction operation includes one of the following: transaction commit and transaction rollback.

In one embodiment, controlling the execution of the target transaction operation on the respective branch transactions according to the second state information corresponding to the respective target branch transactions includes: When it is determined from the second state information that each target branch transaction has been pre-committed successfully, control to perform transaction submission on each target branch transaction; according to the second state information corresponding to each target branch transaction When it is determined that there is a branch transaction that fails to pre-commit, the control is to perform transaction rollback on each target branch transaction.

In one embodiment, after performing the suspended transaction inspection on each global transaction through the target database according to the topology information recorded in the target storage object, the method further includes: in the target global transaction If the submission is successful, the target topology information is deleted from the target storage object.

According to another aspect of the embodiments of the present application, there is also provided a suspended transaction inspection device, including: a receiving unit configured to receive target topology information through a target database, wherein the target topology information is the target global transaction and the the topology information between the multiple target branch transactions corresponding to the target global transaction; the storage unit is configured to save the target topology information into the target storage object, wherein the target storage object is used to record the multiple global transactions. topology information between each global transaction of the A branch transaction; an inspection unit, configured to perform inspection of suspended transactions on each global transaction through the target database according to the topology information recorded in the target storage object.

In one embodiment, the receiving unit includes: a receiving module configured to receive, through the target database, a target transaction message sent by a target server, wherein the target server is the transaction coordinator of the target global transaction, and the target server is the transaction coordinator of the target global transaction. The target transaction message carries the target topology information and to-be-processed branch transaction information corresponding to the target database, and the to-be-processed branch transaction information is used to indicate that among the multiple target branch transactions, to be processed by the target database branch transaction.

In one embodiment, the inspection unit includes: a first determination module, configured to determine, through the target database, the first determination module corresponding to the target global transaction according to the target topology information recorded in the target storage object. a state information; a second determination module configured to determine the target global transaction as a suspended transaction when it is determined according to the first state information that an exception occurs before the target global transaction is committed.

In one embodiment, the first determining module includes: a determining sub-module, and the apparatus further includes: a determining unit, wherein the determining sub-module is configured to detect through the target database according to the target topology information Target heartbeat information, wherein the first state information includes the target heartbeat information, the target heartbeat information is the heartbeat information between the target database and the target server, and the target server corresponds to the target global transaction The transaction coordinator; the determining unit is configured to, after detecting the target heartbeat information through the target database according to the target topology information, when it is detected that the target heartbeat information stops updating, determine the target heartbeat information. An exception occurred before the target global transaction was committed.

In one embodiment, the device further includes: an acquisition unit, configured to perform a suspended transaction inspection on each global transaction through the target database according to the topology information recorded in the target storage object, and then perform a pending transaction inspection on the global transactions respectively. In the case where the target global transaction is determined to be a suspending transaction, obtain second state information corresponding to each target branch transaction in the plurality of target branch transactions; the control unit is set to correspond to each target branch transaction according to the The second state information controls the execution of target transaction operations on the respective branch transactions, wherein the target transaction operations include one of the following: transaction commit and transaction rollback.

In one embodiment, the control unit includes: a first control module, configured to determine, according to the second state information corresponding to the respective target branch transactions, that each target branch transaction has been pre-committed successfully. In this case, control the transaction submission of each target branch transaction; the second control module is configured to determine that there is a branch transaction that fails to pre-commit according to the second state information corresponding to each target branch transaction. Next, control the transaction rollback of each target branch transaction.

In one embodiment, the device further includes: a deletion unit, configured to perform a suspended transaction inspection on each global transaction through the target database according to the topology information recorded in the target storage object, and then delete the transaction in the target database. If the target global transaction is successfully submitted, the target topology information is deleted from the target storage object.

According to another aspect of the embodiments of the present application, an electronic device is also provided, including a processor, a communication interface, a memory, and a communication bus, wherein the processor, the communication interface, and the memory communicate with each other through the communication bus; wherein, a memory for storing a computer program; and a processor for executing the method steps in any of the foregoing embodiments by running the computer program stored in the memory.

According to yet another aspect of the embodiments of the present application, a computer-readable storage medium is also provided, where a computer program is stored in the storage medium, wherein the computer program is configured to execute the method in any of the foregoing embodiments when running step.

In the embodiment of the present application, the method of suspending transaction management performed by the participants of the transaction is adopted, and the target topology information is received through the target database, wherein the target topology information is the target global transaction and the multiple target global transactions corresponding to the target global transaction. topology information between target branch transactions; save the target topology information into a target storage object, wherein the target storage object is used to record each global transaction in multiple global transactions and the relationship with each global transaction topology information between corresponding multiple branch transactions, the target database is used to process one branch transaction among the multiple branch transactions corresponding to each global transaction; according to the topology recorded in the target storage object information, through the target database, the suspended transaction inspection is carried out for the various global transactions. Since the database instance (database node) saves the topology information associated with the database instance through the system table, each global transaction and its corresponding branch transaction It can be registered in at least one associated database instance, and different global transactions and their corresponding branch transactions are registered in different database instances, instead of unified global transaction management by the global transaction manager, which can realize distributed global transactions and The purpose of branch transaction registration management achieves the technical effect of reducing the processing pressure of the manager and improving the processing efficiency of suspended transactions, thereby solving the existence of the suspension transaction control method in the related art due to the number of global transactions and branch transactions managed by the manager The problem of low efficiency of hanging transaction processing caused by more.

Description of drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the application and together with the description serve to explain the principles of the application.

In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the accompanying drawings required for describing the embodiments or related technologies will be briefly introduced below. Obviously, for those skilled in the art, On the premise of no creative labor, other drawings can also be obtained from these drawings.

1 is a schematic diagram of a hardware environment of a method for inspecting a suspended transaction according to an embodiment of the present application;

2 is a schematic flowchart of a method for inspecting a suspended transaction according to an embodiment of the present application;

3 is a schematic diagram of a method for inspecting a suspension transaction according to an embodiment of the present application;

4 is a schematic flowchart of another method for inspecting a suspended transaction according to an embodiment of the present application;

FIG. 5 is a schematic flowchart of another method for inspecting a suspended transaction according to an embodiment of the present application;

FIG. 6 is a structural block diagram of a device for inspecting suspended affairs according to an embodiment of the present application;

FIG. 7 is a structural block diagram of an electronic device according to an embodiment of the present application.

Detailed ways

In order to make those skilled in the art better understand the solutions of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present application. Obviously, the described embodiments are only The embodiments are part of the present application, but not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those of ordinary skill in the art without creative work shall fall within the scope of protection of the present application.

It should be noted that the terms "first", "second", etc. in the description and claims of the present application and the above drawings are used to distinguish similar objects, and are not necessarily used to describe a specific sequence or sequence. It is to be understood that data so used may be interchanged under appropriate circumstances so that the embodiments of the application described herein can be practiced in sequences other than those illustrated or described herein. Furthermore, the terms "comprising" and "having" and any variations thereof, are intended to cover non-exclusive inclusion, for example, a process, method, system, product or device comprising a series of steps or units is not necessarily limited to those expressly listed Rather, those steps or units may include other steps or units not expressly listed or inherent to these processes, methods, products or devices.

First of all, some nouns or terms that appear in the process of describing the embodiments of the present application are suitable for the following explanations:

1. ACID characteristics refer to the following four characteristics: Atomicity, Consistency, Isolation, Durability;

2. Global transaction refers to the master control transaction that initiates data modification;

3. Branch transaction refers to a transaction in which the data modified by the global transaction is distributed to several nodes, and the data modification on each node is encapsulated into a transaction.

According to an aspect of the embodiments of the present application, a method for inspecting a suspended transaction is provided. In one embodiment, in this embodiment, the above-mentioned method for inspecting suspended transactions may be applied to a distributed storage system including a plurality of nodes (eg, database servers) as shown in FIG. 1 , for example, including the first node 102 . and the hardware environment of the second node 104 . As shown in FIG. 1 , the first node 102 is connected with the second node 104 through a network, and can be used to provide services (eg, transaction processing services, etc.) for the terminal or the client installed on the terminal. When performing transaction processing, the first node 102 may be the coordinator of the transaction processing and may be used to process the global transaction, and the second node 104 may be a participant of the transaction processing and may be used to process the branch transaction.

The above network may include, but is not limited to, at least one of the following: wired network, wireless network. The above wired network may include, but is not limited to, at least one of the following: a wide area network, a metropolitan area network, and a local area network, and the above wireless network may include but not limited to at least one of the following: WIFI (Wireless Fidelity, wireless fidelity), Bluetooth. The terminal 102 may not be limited to a PC, a mobile phone, a tablet computer, or the like.

The suspended transaction inspection method in this embodiment of the present application may be executed by the first node 102 , may also be executed by the second node 104 , or may be executed jointly by the first node 102 and the second node 104 . Wherein, the first node 102 and/or the second node 104 may execute the suspended transaction inspection method according to the embodiment of the present application, and may also be executed by a client installed thereon.

Taking the second node 104 to execute the method for inspecting suspended transactions in this embodiment as an example, FIG. 2 is a schematic flowchart of a method for inspecting suspended transactions according to an embodiment of the present application. As shown in FIG. The process can include the following steps:

Step S202, receiving target topology information through the target database, wherein the target topology information is the topology information between the target global transaction and multiple target branch transactions corresponding to the target global transaction.

The suspended transaction inspection method in the embodiment of the present application may be applied to the scenario of suspended transaction inspection in a distributed storage system. The distributed storage system may include: a client APP (Application), a master node (coordinator), and a data node (participant), wherein the master node may be a distributed database agent DS (Data Server, data server). ), the data node can be DB (Data Base, database, database instance). Clients can be connected to the master node through the network, different clients can be connected to the same or different master nodes, and the same master node can be connected to multiple clients. The master node can be connected to the data nodes through the network, different data nodes can be connected to the same or different master nodes, and the same master node can be connected to multiple data nodes.

When there is a data modification requirement or other requirements, the client can initiate a global transaction to the DS, that is, initiate a general control transaction for data modification. For example, for a target client, the target client may send a target global transaction to the target server (DS), which is used to perform the target processing operation on the target object.

The target server can determine multiple target branch transactions corresponding to the target global transaction, that is, determine the database nodes where the data modified by the above target processing operations are scattered, and encapsulate the data modification on each database node into a corresponding target branch transaction, get multiple target branch transactions. After obtaining the multiple target branch transactions, the target server may send each target branch transaction among the multiple target branch transactions to the corresponding database node.

In order to avoid the failure of the initiator of the global transaction before the global transaction is committed, the global transaction and its corresponding branch transaction cannot continue to advance, and at the same time to avoid the hanging transaction processing efficiency caused by the large number of global transactions and branch transactions managed by the manager Low, an implementation scheme is: reuse the transaction timeout automatic commit/rollback strategy of the database itself. This scheme relies on the database kernel to autonomously detect the overtime pending branch transaction, and commit/rollback according to the branch transaction characteristics, which cannot guarantee the global ACID characteristics of transactions, and less efficient.

In one embodiment, in the embodiment of the present application, the global transaction and the branch transaction are registered in the database instance in a decentralized manner, and a global transaction and the corresponding branch transaction can be registered in a certain database instance that processes the branch transaction, or, the processing branch Multiple database instances of transactions to enable global transaction and branch transaction state self-management.

For a target global transaction, the target server can generate target topology information corresponding to the target global transaction, and the above target topology information is the topology information between the target global transaction and multiple target branch transactions corresponding to the target global transaction, and can be used to represent Topological relationship between the target global transaction and multiple target branch transactions corresponding to the target global transaction, for example, the corresponding relationship between the target global transaction and the target server processing the target global transaction, each target branch transaction and processing each target branch transaction The corresponding relationship between the database nodes. The target topology information may also include other information, for example, the initiation time of the target global transaction, etc., which is not limited in this embodiment of the present application.

The target server can also select the target database from the database nodes that process each target branch transaction, that is, the database node to which the target global transaction and multiple target branch transactions are to be registered, and send the target topology information to the selected target database. . The number of target databases may be one or more, and the selection method may be: random selection, or according to the order of target branch transactions, or other selection methods, which are not limited in this embodiment.

For a target database, the target database may be a database node that processes a branch transaction of a plurality of target branch transactions. In addition to receiving the target branch transaction to be processed by this database, the target database can also receive target topology information sent by the target database.

Step S204, save the target topology information in the target storage object, wherein the target storage object is used to record the topology information between each global transaction in the multiple global transactions and the multiple branch transactions corresponding to each global transaction, The target database is used to process one of the branch transactions corresponding to each global transaction.

A storage object can be stored in each database instance, and the storage object can be used to record the topological relationship between the global transaction registered in this database instance and the corresponding branch transaction, and can also be used to record the global transaction registered in this database instance. status information. For example, a system table may be added to each database instance, and the system table may be used to record the topology relationship and state information of the global transaction registered in the database instance and the corresponding branch transaction.

For the target database, the target database may save a target storage object (eg, target system table), and the target storage object may be used to record each of multiple global transactions (multiple global transactions registered with the target database, including the target global transaction) The topology information between each global transaction and multiple branch transactions corresponding to each global transaction can also be used to record the state information of each global transaction.

After receiving the target topology information, the target database can save the target topology information to the target storage object, and the saving method can be: save the target topology information to the target storage object in the order of reception, for example, save it to the end of the target storage object.

It should be noted that the above-mentioned storage object is a storage unit/storage module used to record the topology information between the global transaction registered in this database instance and the multiple branch transactions corresponding to the global transaction. The specific form of the storage object is not limited.

In step S206, according to the topology information recorded in the target storage object, each global transaction is inspected by the target database for suspending transactions.

According to each topology information recorded in the target storage object, the target database can perform suspension transaction inspection on each global transaction. The inspection method can be as follows: according to each topology information recorded in the target storage object, determine whether the master control node corresponding to each global transaction is faulty, if a fault occurs, determine that the global transaction is a suspended transaction; if no fault occurs, Then it is determined that the global transaction is not a dangling transaction.

For example, for the target topology information, the target database can train the target global transaction with suspending transactions, determine whether the target server fails, if a failure occurs, determine that the target global transaction is a suspending transaction, and if no failure occurs, determine that the target global transaction is not Suspended business.

For each global transaction, if the corresponding master node does not fail, then each transaction can be processed based on the submission process in the related technology. The coordinator feeds back the pre-commit results; the coordinator determines to commit or roll back the transaction based on the pre-commit results: if the branch transactions of each participant have been pre-committed successfully, each participant will be controlled to formally commit the branch transaction. If the branch transaction pre-commit fails, each participant is controlled to roll back the branch transaction.

Through the above steps S202 to S206, the target topology information is received through the target database, wherein the target topology information is the topology information between the target global transaction and multiple target branch transactions corresponding to the target global transaction; The target topology information is stored in the target storage object, wherein the target storage object is used to record the topology information between each global transaction in the multiple global transactions and the multiple branch transactions corresponding to the each global transaction, The target database is used to process one branch transaction in the plurality of branch transactions corresponding to each global transaction; according to the topology information recorded in the target storage object, each global transaction is processed by the target database. Transactions are inspected separately for suspending transactions, which solves the problem of low suspending transaction processing efficiency caused by the large number of global transactions and branch transactions managed by the manager in the suspending transaction control method in the related art, and reduces the processing of the manager. pressure and improve the efficiency of suspension transaction processing.

In one embodiment, receiving the target topology information through the target database includes:

S11, receiving a target transaction message sent by the target server through the target database, wherein the target server is the transaction coordinator of the target global transaction, and the target transaction message carries the target topology information and the pending branch transaction information corresponding to the target database. The branch transaction information is used to indicate a branch transaction to be processed by the target database among the multiple target branch transactions.

For the target database, the target server may separately send the branch transaction and target topology information to be processed by the target database. For example, the target server may first send to the target database the branch transaction information to be processed corresponding to the target database, and the to-be-processed branch transaction information may be used to indicate the branch transaction to be processed by the target database among the multiple target branch transactions; then, the target server may Send target topology information to the target database.

In one embodiment, in order to simplify the data transmission process and improve the utilization efficiency of system resources, the target server can send the target topology information and the branch transaction information to be processed to the target database together, for example, send the two together to the target database through the target transaction message. target database.

The target database can receive the above-mentioned target transaction message sent by the target server, extract the branch transaction information to be processed and the target topology information respectively, save the target topology information in the target storage object, and execute the branch indicated by the above-mentioned branch transaction information to be processed. The pre-commit, commit, etc. of the transaction are not limited in this embodiment of the present application.

With this embodiment, by sending topology information and transaction information to the database instance together, the data transmission process can be simplified and the utilization efficiency of system resources can be improved.

In one embodiment, according to the topology information recorded in the target storage object, the suspension transaction inspection of each global transaction through the target database includes:

S21, according to the target topology information recorded in the target storage object, determine the first state information corresponding to the target global transaction through the target database;

S22 , in the case where it is determined according to the first state information that the target global transaction is abnormal before committing, determine the target global transaction as a suspended transaction.

When inspecting the suspended transaction, for the target global transaction, the target database can determine the first state information corresponding to the target global transaction according to the target topology information, and the first state information can be used to represent the current state of the target global transaction, for example , normal state, abnormal state. The first state information may be determined periodically, for example, according to the target topology information, the target database may periodically/timely determine the first state information corresponding to the target global transaction.

It should be noted that the first state information corresponding to the target global transaction can be used to indicate the running state of the target server that processes the target global transaction. If the target server is running normally, the first state information is used to indicate that the target global transaction is in normal state. state, if the target server operates abnormally (for example, fails), the first state information is used to indicate that the target global transaction is in an abnormal state.

If it is determined according to the first state information that the target global transaction is abnormal before committing, for example, the target server fails before the target global transaction is committed, then the target global transaction will not be able to complete the commit. Therefore, the target database can transfer the target global transaction Determined as a pending transaction.

Through the embodiments of the present application, the status information of the global transaction is acquired according to the topology information, and whether the global transaction is abnormal before being submitted is determined based on the status information, which can improve the efficiency of the inspection of the suspended transaction.

In one embodiment, according to the target topology information recorded in the target storage object, determining the first state information corresponding to the target global transaction through the target database includes:

S31, according to the target topology information, detect the target heartbeat information through the target database, wherein the first state information includes the target heartbeat information, the target heartbeat information is the heartbeat information between the target database and the target server, and the target server is corresponding to the target global transaction. transaction coordinator;

After detecting the target heartbeat information through the target database according to the target topology information, the above method further includes:

S32 , when it is detected that the target heartbeat information stops updating, it is determined that an exception occurs before the target global transaction is committed.

The state information of the global transaction may include heartbeat information between the database instance and the data server. Heartbeat information can be added to each global transaction and branch transaction. For example, the data server can periodically send heartbeat packets to all or part of the database instances connected to it. The database instance can update the saved heartbeat information according to the received heartbeat packets. The heartbeat information can be Including the time of the heartbeat packet. The suspended transaction inspection module in the database instance can automatically detect global transactions with abnormal heartbeats.

Under normal circumstances, the heartbeat information of the global transaction (and/or branch transaction) will be updated in real time. In abnormal cases, the heartbeat information of the global transaction (and/or branch transaction) will stop updating. Therefore, according to whether the heartbeat information is updated, the global transaction can be determined. Whether the transaction (or branch transaction) is normal.

For the target global transaction, the target server may periodically send heartbeat packets to the target database, where the target server may be a distributed database agent DS, which is the transaction coordinator corresponding to the target global transaction. The target database can update the heartbeat information between the target database and the target server according to the received heartbeat packet, that is, the target heartbeat information.

According to the target topology information, the target database can detect the target heartbeat information. If it is detected that the target heartbeat information has not been updated within a period of time, it indicates that the heartbeat packet sent by the target server has not been received within a period of time, and the target server has failed. The target database can determine that the target global transaction is abnormal before committing.

In order to ensure the accuracy of the exception determination, the target server may send a commit completion message to the target database after the target global transaction is committed to indicate that the target global transaction of the target database has completed the commit. Correspondingly, when it is detected that the target heartbeat information stops updating and the commit completion message sent by the target server is not received, it is determined that the target global transaction is abnormal before the commit, and the commit completion message is used to indicate that the target global transaction has been submitted. .

Through the embodiment of the present application, it is determined whether the server corresponding to the global transaction is faulty according to the heartbeat information, which can ensure the accuracy of the abnormal determination of the global transaction, and at the same time, can reduce the occupation of network resources (the data volume of the heartbeat packet is small).

In one embodiment, after performing the suspended transaction inspection on each global transaction through the target database according to the topology information recorded in the target storage object, the above method further includes:

S41, in the case where the target global transaction is determined to be a suspended transaction, obtain second state information corresponding to each target branch transaction in the multiple target branch transactions;

S42 , executing the target transaction operation on each branch transaction according to the second state information corresponding to each target branch transaction, wherein the target transaction operation includes one of the following: transaction commit and transaction rollback.

If the global transaction registered with the target database becomes a suspended transaction, the target database can take over the suspended transaction, and can push the suspended transaction to commit or roll back according to the status of all branch transactions corresponding to the suspended transaction. In one embodiment, if the state of all branch transactions corresponding to the global transaction is pre-submitted/committed/submitted, the global transaction can be pushed to continue to complete the subsequent process of submitting; otherwise, all branch transactions corresponding to the global transaction are pushed to roll back. operate.

For the target global transaction, if the target global transaction is determined to be a suspended transaction, the target database can obtain the second state information corresponding to each target branch transaction among the multiple target branch transactions, that is, the target database can correspond to each target branch transaction The database instance interacts with each other to determine the current processing status of each target branch transaction, for example, pre-commit success, pre-commit failure, commit success, commit failure, and so on.

According to the second state information corresponding to each target branch transaction, the target database can control to perform subsequent transaction operations on each branch transaction, such as transaction commit and transaction rollback.

Through the embodiments of the present application, the target database to which each global transaction is registered takes over the submission task of the suspended transaction, which can improve the efficiency of transaction processing.

In one embodiment, controlling the execution of the target transaction operation on each branch transaction according to the second state information corresponding to each target branch transaction includes:

S51, when it is determined that each target branch transaction has been pre-committed successfully according to the second state information corresponding to each target branch transaction, control the transaction submission of each target branch transaction;

S52, if it is determined according to the second state information corresponding to each target branch transaction that there is a branch transaction that fails to pre-commit, control to perform transaction rollback on each target branch transaction.

When taking over the submission task of the target global transaction, regardless of whether the target server recovers from the exception, the target database can control the forward execution of the suspended transaction, which can ensure the timeliness of transaction processing while ensuring the ACID property of the global transaction.

If it is determined according to the second state information corresponding to each target branch transaction that each target branch transaction has been pre-committed successfully, then the target database can control the transaction submission of each target branch transaction, for example, to the database corresponding to each target branch transaction Nodes send commit instructions, instructing to formally commit each branch transaction.

If it is determined according to the second state information corresponding to each target branch transaction that there is a branch transaction that fails to pre-commit, the target database can control the transaction rollback of each target branch transaction, for example, send back to the database instance corresponding to each target branch transaction. Rollback instructions, instructing each target branch transaction to roll back.

Through the embodiment of the present application, the database instance controls the branch transaction corresponding to the suspended transaction to commit or roll back according to the processing state of each branch transaction, which can ensure the timeliness of transaction processing.

S61, in the case that the target global transaction is successfully submitted, delete the target topology information from the target storage object.

In order to ensure the reasonable utilization of the storage space in the database instance, for the global transaction that has been successfully submitted, the database instance can delete its corresponding topology information from the target storage object. If the target global transaction commits successfully, the target database can delete the target topology information from the target storage object. The deletion of topology information may be triggered when the target global transaction is successfully submitted, or may be triggered by a background process of periodically clearing expired topology information in the target storage object, which is not limited in this embodiment of the present application.

There are various timings for deleting the target topology information, and the trigger conditions for deletion can be configured according to whether the target server is abnormal or not.

If no exception occurs on the target server, that is, the target database has not taken over the target global transaction, when the target global transaction is successfully submitted, the target server can send a delete message to the target database to instruct the target database to delete the target topology information. According to the delete message, The target database deletes the target topology information in the target storage object; or, the target database can also delete the target topology information in the target storage object after all branch transactions corresponding to the global transaction are successfully submitted.

If an exception occurs on the target server, that is, the target database takes over the target global transaction, then, when the target global transaction is successfully submitted, the target database deletes the target topology information in the target storage object; or, after instructing other database instances to submit the corresponding After the target branch transaction, the target database deletes the target topology information in the target storage object, and the other database instances are database instances other than the target database among the multiple database instances that process multiple target branch transactions.

Through the embodiment of the present application, after the global transaction is successfully submitted, the topology information corresponding to the global transaction stored in the database instance to which the global transaction is registered is deleted, which can reduce the occupation of the storage space of the database instance and improve the utilization of storage space. rationality.

The method for inspecting a suspension transaction in the embodiment of the present application will be explained below with reference to an example. In this example, the storage object is a relational table.

The suspended transaction inspection method in this example can be applied to the network architecture shown in FIG. 3 , the network architecture includes: an application end, a distributed database agent, and a database instance, wherein,

The application side is used for transaction submission;

Distributed database agent, which can be used as the coordinator of the transaction to receive the global transaction initiated by the application and send the branch transaction to the corresponding database instance;

The database instance can be used as a participant in the transaction to process the corresponding branch transaction.

This example provides a distributed database suspension transaction inspection optimization solution, which adopts the mechanism of global transaction and branch transaction status self-management: the global transaction and branch transaction are distributed in the database instance, and a new one is added to each database instance. The system table is used to record the topological relationship and status information of global transactions and branch transactions; heartbeat information is added to each global transaction and branch transaction. Under normal circumstances, the heartbeat information of global transactions and branch transactions will be updated in real time. Or the heartbeat information of the branch transaction will stop updating; the suspended transaction inspection module in the database instance automatically detects the global transaction with abnormal heartbeat, and promotes the commit/rollback of the branch transaction corresponding to the global transaction.

With reference to Figures 3 and 4, the flow of the method for inspecting suspended transactions in this example may include the following steps:

Step S402, the application terminal 1 connects to the distributed database agent 1, and initiates a global transaction 1.

Step S404, the distributed database agent 1 sends the branch transaction 1 and the branch transaction 2 corresponding to the global transaction 1 to the database instance 1 and the database instance 2, respectively.

The distributed database agent 1 can determine the branch transaction 1 and the branch transaction 2 corresponding to the global transaction 1, send the branch transaction 1 to the database instance 1, and send the branch transaction 2 to the database instance 2.

Step S406, the distributed database agent 1 records the topology information of the global transaction 1 and its branch transaction 1 and branch transaction 2 in the system table of the database instance 1, and updates the heartbeat information of the global transaction 1 recorded by the database instance 1 in real time.

Exemplarily, the topology information and heartbeat information recorded in the system table of database instance 1 may include:

The distributed database agent 1 can also determine the topology information of the global transaction 1 and its branch transaction 1 and branch transaction 2, and send the determined topology information to the database instance 1 to record it in the system table of the database instance 1. Instance 1 sends a heartbeat packet to update the heartbeat information of global transaction 1 recorded by database instance 1.

Step S408, the suspended transaction inspection module in the database instance 1 scans the system table, finds that the global transaction 1 has an abnormal heartbeat, takes over the global transaction 1, and continues to commit/roll back the transaction according to the status of the branch transaction 1 and the branch transaction 2.

If the distributed database agent 1 fails, the global transaction 1 has not yet completed the commit, and becomes a suspended transaction. The suspended transaction inspection module in database instance 1 scans the system table and finds that the heartbeat of global transaction 1 is abnormal. Then, database instance 1 takes over global transaction 1 and determines the status of branch transaction 1 and branch transaction 2. The status of branch transaction can include but not Restricted to at least one of the following: INIT (initialization), PREPARED (pre-commit), COMMIT (commit). According to the status of branch transaction 1 and branch transaction 2, database instance 1 can continue to commit or roll back the transaction.

For example, if branch transaction 1 and branch transaction 2 are in the INIT state, they are controlled to roll back; both branch transaction 1 and branch transaction 2 have been pre-committed successfully, then branch transaction 1 and branch transaction 2 are controlled to commit; if branch transaction 1 and branch transaction 2 are both pre-committed successfully If the branch transaction 2 is partially submitted successfully, and part of it has not been submitted successfully, the submission will continue. If a branch transaction is not successfully processed at a certain stage, the control branch transaction 1 and branch transaction 2 are rolled back.

With reference to FIG. 3 and FIG. 5 , the process of the suspended transaction inspection method in this example may also include the following steps:

Step S502 , the application terminal 2 connects to the distributed database agent 2 and initiates a global transaction 2 .

Step S504, the distributed database agent 2 sends the branch transaction 3 and the branch transaction 4 corresponding to the global transaction 2 to the database instance 2 and the database instance 3, respectively.

The distributed database agent 2 can determine the branch transaction 3 and the branch transaction 4 corresponding to the global transaction 2, send the branch transaction 3 to the database instance 2, and send the branch transaction 4 to the database instance 3.

Step S506, the distributed database agent 2 records the topology information of the global transaction 2 and its branch transaction 3 and branch transaction 4 in the system table of the database instance 2, and updates the heartbeat information of the global transaction 2 recorded by the database instance 2 in real time.

The distributed database agent 2 can also determine the topology information of the global transaction 2 and its branch transaction 3 and branch transaction 4, and send the determined topology information to the database instance 2 to record it in the system table of the database instance 2. Instance 2 sends a heartbeat packet to update the heartbeat information of global transaction 2 recorded by database instance 2.

Exemplarily, the topology information and heartbeat information recorded in the system table of the database instance 2 may include:

Step S508, the suspended transaction inspection module in the database instance 2 scans the system table, finds that the global transaction 2 has an abnormal heartbeat, takes over the global transaction 2, and continues to commit/roll back the transaction according to the status of the branch transaction 3 and the branch transaction 4.

If the distributed database agent 2 fails, at this time, the global transaction 2 has not completed the commit, and becomes a suspended transaction. The suspended transaction inspection module in database instance 2 scans the system table and finds that the heartbeat of global transaction 2 is abnormal. Then, database instance 2 takes over global transaction 2 and determines the status of branch transaction 3 and branch transaction 4. The status of branch transaction can include but not Limited to at least one of the following: INIT, PREPARED, COMMIT. According to the status of branch transaction 3 and branch transaction 4, database instance 2 can continue to commit or roll back the transaction.

For example, branch transaction 3 and branch transaction 4 are in the INIT state, and both are controlled to be rolled back; both branch transaction 3 and branch transaction 4 have been pre-committed successfully, then branch transaction 3 and branch transaction 4 are controlled to commit; if branch transaction 3 and branch transaction 4 are both pre-committed successfully Part 4 of the branch transaction is successfully submitted, and part of it has not been submitted successfully, then continue to advance the submission. If a branch transaction is not successfully processed at a certain stage, the control branch transaction 3 and branch transaction 4 are rolled back.

It should be noted that the system table of database instance 3 may also record topology information of some global transactions and their branch transactions, and heartbeat information of these global transactions. Exemplarily, the topology information and heartbeat information recorded in the system table of database instance 3 may be:

It can be seen from the above that different global transactions and their corresponding branch transactions can be registered in the database instance of a branch transaction processing the global transaction, and each database instance can register multiple global transactions and their corresponding branch transactions, and at the same time , the database instance can independently complete the inspection and takeover of suspended transactions. It can not only retain the advantages of centralized transaction management, that is, ensure the ACID properties of global transactions, but also avoid centralized transaction management caused by the need to register both global transactions and branch transactions in the global transaction manager. The performance bottleneck of the entire cluster The problem.

Through this example, through the distributed global transaction and distributed transaction registration mode, the pressure of transaction inspection can be reduced; through distributed parallel suspended transaction inspection, the efficiency of suspended transaction inspection can be improved; through distributed parallel suspended transaction inspection, the efficiency of suspended transaction inspection can be improved; Parallel processing can also improve the processing efficiency of suspended transactions.

It should be noted that, for the sake of simple description, the foregoing method embodiments are all expressed as a series of action combinations, but those skilled in the art should know that the present application is not limited by the described action sequence. Because in accordance with the present application, certain steps may be performed in other orders or concurrently. Secondly, those skilled in the art should also know that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present application.

From the description of the above embodiments, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course can also be implemented by hardware, but in many cases the former is better implementation. Based on this understanding, the technical solution of the present application can be embodied in the form of a software product in essence or the part that contributes to the related technology, and the computer software product is stored in a storage medium (such as ROM (Read-Only Memory, only read memory)/RAM (Random Access Memory), magnetic disk, optical disk), including several instructions to make a terminal device (which can be a mobile phone, computer, server, or network device, etc.) to execute this application The methods described in the various examples.

According to another aspect of the embodiments of the present application, there is also provided a suspension transaction inspection device for implementing the above suspension transaction inspection method. Fig. 6 is a structural block diagram of an apparatus for inspecting suspended affairs according to an embodiment of the present application. As shown in Fig. 6 , the apparatus may include:

(1) a receiving unit 602, configured to receive target topology information through the target database, wherein the target topology information is the topology information between the target global transaction and a plurality of target branch transactions corresponding to the target global transaction;

(2) The saving unit 604 is connected to the receiving unit 602, and is configured to save the target topology information into the target storage object, wherein the target storage object is used to record each global transaction in the multiple global transactions and the relationship with each global transaction. The topology information between the corresponding multiple branch transactions, and the target database is used to process one branch transaction among the multiple branch transactions corresponding to each global transaction;

(3) The inspection unit 606 is connected to the storage unit 604, and is configured to perform an inspection of suspended transactions for each global transaction through the target database according to the topology information recorded in the target storage object.

It should be noted that the receiving unit 602 in this embodiment may be configured to execute the above step S202, the saving unit 604 in this embodiment may be configured to execute the above step S204, and the inspection unit 606 in this embodiment may be configured to execute the above step S204. The above step S206.

Through the above unit, the target topology information is received through the target database, wherein the target topology information is the topology information between the target global transaction and a plurality of target branch transactions corresponding to the target global transaction; the target topology information is saved into a target storage object, wherein the target storage object is used to record topology information between each global transaction in multiple global transactions and multiple branch transactions corresponding to each global transaction, and the target database for processing one branch transaction in the plurality of branch transactions corresponding to each global transaction; according to the topology information recorded in the target storage object, the global transactions are respectively suspended through the target database The transaction inspection solves the problem of low efficiency of suspended transaction processing caused by the large number of global transactions and branch transactions managed by the manager in the suspension transaction control method in the related art, reduces the processing pressure of the manager, and improves the Hang transaction efficiency.

In one embodiment, the receiving unit 602 includes:

The receiving module is configured to receive the target transaction message sent by the target server through the target database, wherein the target server is the transaction coordinator of the target global transaction, and the target transaction message carries the target topology information and the pending branch transaction information corresponding to the target database. , the branch transaction information to be processed is used to indicate the branch transaction to be processed by the target database among the multiple target branch transactions.

In one embodiment, the inspection unit 606 includes:

The first determining module is configured to determine the first state information corresponding to the target global transaction through the target database according to the target topology information recorded in the target storage object;

The second determining module is configured to determine the target global transaction as a suspended transaction when it is determined according to the first state information that the target global transaction is abnormal before committing.

In one embodiment, the first determination module includes: a determination sub-module, and the above-mentioned apparatus further includes: a determination unit, wherein:

The determination submodule is set to detect the target heartbeat information through the target database according to the target topology information, wherein the first state information includes the target heartbeat information, the target heartbeat information is the heartbeat information between the target database and the target server, and the target server is the heartbeat information between the target database and the target server. The transaction coordinator corresponding to the global transaction;

The determining unit is configured to, after detecting the target heartbeat information through the target database according to the target topology information, when it is detected that the target heartbeat information stops updating, determine that the target global transaction is abnormal before committing.

In one embodiment, the above-mentioned device further includes:

The acquiring unit is set to, according to the topology information recorded in the target storage object, after the suspending transaction inspection is performed on each global transaction through the target database, and the target global transaction is determined as a suspending transaction, the target global transaction is determined as a suspended transaction, and multiple target branches are obtained. second state information corresponding to each target branch transaction in the transaction;

The control unit is configured to control the execution of the target transaction operation on each branch transaction according to the second state information corresponding to each target branch transaction, wherein the target transaction operation includes one of the following: transaction commit and transaction rollback.

In one embodiment, the control unit includes:

The first control module is configured to control the transaction submission to each target branch transaction when it is determined that each target branch transaction has been pre-submitted successfully according to the second state information corresponding to each target branch transaction;

The second control module is configured to control the transaction rollback of each target branch transaction when it is determined according to the second state information corresponding to each target branch transaction that there is a branch transaction that fails to pre-commit.

In one embodiment, the above-mentioned device further includes:

The deletion unit is set to perform a suspended transaction inspection of each global transaction through the target database according to the topology information recorded in the target storage object, and when the target global transaction is successfully submitted, remove the target topology information from the target storage object. delete.

It should be noted here that the examples and application scenarios implemented by the foregoing modules and corresponding steps are the same, but are not limited to the contents disclosed in the foregoing embodiments. It should be noted that, as a part of the device, the above modules may run in the hardware environment as shown in FIG. 1 , and may be implemented by software or hardware, wherein the hardware environment includes a network environment.

According to yet another aspect of the embodiments of the present application, there is also provided an electronic device for implementing the above method for inspecting suspended transactions, where the electronic device may be a server, a terminal, or a combination thereof.

FIG. 7 is a structural block diagram of an electronic device according to an embodiment of the present application. As shown in FIG. 7 , it includes a processor 702 , a communication interface 704 , a memory 706 and a communication bus 708 , wherein the processor 702 , the communication interface 704 and the memory 706 communicates with each other through the communication bus 708, wherein,

memory 706 for storing computer programs;

When the processor 702 is used to execute the computer program stored in the memory 706, the following steps are implemented:

S1, receiving target topology information through the target database, wherein the target topology information is the topology information between the target global transaction and multiple target branch transactions corresponding to the target global transaction;

S2, save the target topology information into the target storage object, where the target storage object is used to record the topology information between each global transaction in the multiple global transactions and the multiple branch transactions corresponding to each global transaction, and the target The database is used to process one of the branch transactions corresponding to each global transaction;

S3, according to the topology information recorded in the target storage object, through the target database, each global transaction is respectively inspected for suspended transactions.

In one embodiment, in the embodiment of the present application, the above-mentioned communication bus may be a PCI (Peripheral Component Interconnect, Peripheral Component Interconnect Standard) bus, or an EISA (Extended Industry Standard Architecture, Extended Industry Standard Architecture) bus or the like. The communication bus can be divided into an address bus, a data bus, a control bus, and the like. For ease of presentation, only one thick line is used in FIG. 7, but it does not mean that there is only one bus or one type of bus. The communication interface is used for communication between the above electronic device and other devices.

The memory may include RAM and may also include non-volatile memory, such as at least one disk memory. In one embodiment, the memory may also be at least one storage device located remotely from the aforementioned processor.

As an example, the above-mentioned memory 706 may include, but is not limited to, the receiving unit 602 , the saving unit 604 and the inspection unit 606 in the above-mentioned suspended transaction inspection device. In addition, it may also include, but is not limited to, other module units in the above-mentioned suspended transaction inspection device, which will not be repeated in this example.

The above-mentioned processor can be a general-purpose processor, which can include but is not limited to: CPU (Central Processing Unit, central processing unit), NP (Network Processor, network processor), etc.; can also be DSP (Digital Signal Processing, digital signal processor) ), ASIC (Application Specific Integrated Circuit, Application Specific Integrated Circuit), FPGA (Field-Programmable Gate Array, Field Programmable Gate Array) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components.

In an implementation manner, for specific examples in the embodiments of the present application, reference may be made to the examples described in the foregoing embodiments, and details are not described herein again in this embodiment.

Those of ordinary skill in the art can understand that the structure shown in FIG. 7 is for illustration only, and the device implementing the above-mentioned method for inspecting suspended affairs can also be a terminal device, and the terminal device can be a smart phone (such as an Android mobile phone, an iOS mobile phone, etc.), Tablet PCs, PDAs, Mobile Internet Devices (MIDs, MIDs), PADs and other terminal devices. FIG. 7 does not limit the structure of the above electronic device. For example, the electronic device may also include more or fewer components than those shown in FIG. 7 (eg, network interfaces, display devices, etc.), or have a different configuration than that shown in FIG. 7 .

Those of ordinary skill in the art can understand that all or part of the steps in the various methods of the above embodiments can be completed by instructing the hardware related to the terminal device through a program, and the program can be stored in a computer-readable storage medium, and the storage medium can Including: flash disk, ROM, RAM, magnetic disk or CD, etc.

According to yet another aspect of the embodiments of the present application, a storage medium is also provided. In one embodiment, in the embodiment of the present application, the above-mentioned storage medium may be used to execute the program code of any one of the above-mentioned suspended transaction inspection methods in the embodiment of the present application.

In an implementation manner, in this embodiment of the present application, the above-mentioned storage medium may be located on at least one network device among multiple network devices in the network shown in the above-mentioned embodiment.

In one embodiment, in this embodiment of the present application, the storage medium is configured to store program codes for executing the following steps:

In an implementation manner, for specific examples in the embodiments of the present application, reference may be made to the examples described in the foregoing embodiments, which will not be repeated in this embodiment.

In one embodiment, in the embodiments of the present application, the above-mentioned storage medium may include, but is not limited to, various media that can store program codes, such as U disk, ROM, RAM, removable hard disk, magnetic disk, or optical disk.

The above-mentioned serial numbers of the embodiments of the present application are only for description, and do not represent the advantages or disadvantages of the embodiments.

If the integrated units in the above-mentioned embodiments are implemented in the form of software functional units and sold or used as independent products, they may be stored in the above-mentioned computer-readable storage medium. Based on this understanding, the technical solutions of the present application can be embodied in the form of software products in essence, or the parts that contribute to the related technologies, or all or part of the technical solutions. The computer software products are stored in the storage medium, including Several instructions are used to cause one or more computer devices (which may be personal computers, servers, or network devices, etc.) to execute all or part of the steps of the methods described in the various embodiments of the present application.

In the above-mentioned embodiments of the present application, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.

In the several embodiments provided in this application, it should be understood that the disclosed client may be implemented in other manners. The apparatus embodiments described above are only illustrative, for example, the division of the units is only a logical function division, and there may be other division methods in actual implementation, for example, multiple units or components may be combined or Integration into another system, or some features can be ignored, or not implemented. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be through some interfaces, indirect coupling or communication connection of units or modules, and may be in electrical or other forms.

The units described as separate components may or may not be physically separated, and components displayed as units may or may not be physical units, that is, may be located in one place or distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution provided in this embodiment.

In addition, each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically alone, or two or more units may be integrated into one unit. The above-mentioned integrated units may be implemented in the form of hardware, or may be implemented in the form of software functional units.

The above are only the preferred embodiments of the present application. It should be pointed out that for those skilled in the art, without departing from the principles of the present application, several improvements and modifications can also be made. It should be regarded as the protection scope of this application.

Industrial Applicability

The embodiments of the present application provide a method and device, an electronic device, and a storage medium for inspecting a suspended transaction. Target topology information is received through a target database, and the target topology information is a combination of a target global transaction and multiple target branch transactions corresponding to the target global transaction. The topology information between the two; save the target topology information into the target storage object, and the target storage object is used to record the topology information between each global transaction in the multiple global transactions and the multiple branch transactions corresponding to each global transaction, The target database is used to process one branch transaction among the multiple branch transactions corresponding to each global transaction; according to the topology information recorded in the target storage object, each global transaction is inspected by the target database. Since the database instance (database node) saves the topology information associated with the database instance through the system table, each global transaction and its corresponding branch transaction can be registered in at least one associated database instance, different global transactions and their corresponding branches Transactions are registered in different database instances, instead of the global transaction manager for unified global transaction management, so that the purpose of distributed global transaction and branch transaction registration management can be achieved, which can reduce the processing pressure of the manager and improve the suspension. The technical effect of transaction processing efficiency further solves the problem of low hanging transaction processing efficiency caused by the large number of global transactions and branch transactions managed by the manager in the suspended transaction control method in the related art.

Claims

A suspension transaction inspection method, comprising:

Receive target topology information through a target database, wherein the target topology information is topology information between a target global transaction and a plurality of target branch transactions corresponding to the target global transaction;

The target topology information is stored in a target storage object, wherein the target storage object is used to record the relationship between each global transaction in multiple global transactions and multiple branch transactions corresponding to each global transaction. topology information, the target database is used to process a branch transaction in the plurality of branch transactions corresponding to each global transaction;

According to the topology information recorded in the target storage object, the suspended transaction inspection is performed on each global transaction through the target database.
The method of claim 1, wherein receiving the target topology information via the target database comprises:

The target transaction message sent by the target server is received through the target database, wherein the target server is the transaction coordinator of the target global transaction, and the target transaction message carries the target topology information and the target database. Corresponding branch transaction information to be processed, the to-be-processed branch transaction information is used to indicate the branch transaction to be processed by the target database among the multiple target branch transactions.
The method according to claim 1, wherein, according to the topology information recorded in the target storage object, respectively performing suspended transaction inspection on each global transaction through the target database comprises:

According to the target topology information recorded in the target storage object, determine the first state information corresponding to the target global transaction through the target database;

If it is determined according to the first state information that the target global transaction is abnormal before committing, the target global transaction is determined to be a suspended transaction.
The method according to claim 3, wherein, according to the target topology information recorded in the target storage object, determining the first state information corresponding to the target global transaction through the target database comprises:

According to the target topology information, the target heartbeat information is detected through the target database, wherein the first state information includes the target heartbeat information, and the target heartbeat information is the heartbeat information between the target database and the target server , the target server is the transaction coordinator corresponding to the target global transaction;

After detecting the target heartbeat information through the target database according to the target topology information, the method further includes: in the case where it is detected that the target heartbeat information stops updating, determining that the target global transaction is being submitted An exception occurred before.
The method according to any one of claims 1 to 4, wherein after each global transaction is inspected for suspended transactions through the target database according to the topology information recorded in the target storage object, the The method also includes:

In the case where the target global transaction is determined to be a suspending transaction, acquiring second state information corresponding to each target branch transaction in the plurality of target branch transactions;

The target transaction operation is controlled to be performed on each branch transaction according to the second state information corresponding to each target branch transaction, wherein the target transaction operation includes one of the following: transaction commit and transaction rollback.
The method according to claim 5, wherein controlling the execution of the target transaction operation on the respective branch transactions according to the second state information corresponding to the respective target branch transactions comprises:

Under the condition that it is determined according to the second state information corresponding to each target branch transaction that all the target branch transactions have been pre-committed successfully, controlling the transaction submission of each target branch transaction;

When it is determined according to the second state information corresponding to each target branch transaction that there is a branch transaction that fails to pre-commit, the control is to perform transaction rollback on each target branch transaction.
The method according to any one of claims 1 to 6, wherein, after performing suspending transaction inspection on each global transaction through the target database according to the topology information recorded in the target storage object, the The method also includes:

In the case that the target global transaction is successfully submitted, the target topology information is deleted from the target storage object.
A suspension affairs inspection device, comprising:

a receiving unit, configured to receive target topology information through a target database, wherein the target topology information is the topology information between a target global transaction and a plurality of target branch transactions corresponding to the target global transaction;

A saving unit, configured to save the target topology information into a target storage object, wherein the target storage object is used to record each global transaction in a plurality of global transactions and multiple global transactions corresponding to the each global transaction topology information between branch transactions, the target database is used to process one branch transaction in the plurality of branch transactions corresponding to each global transaction;

The inspection unit is configured to inspect each global transaction through the target database to perform suspension transaction inspection respectively according to the topology information recorded in the target storage object.
An electronic device comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other through the communication bus,

The memory is configured to store computer programs;

The processor is arranged to perform the method steps of any one of claims 1 to 7 by running the computer program stored on the memory.
A computer-readable storage medium in which a computer program is stored, wherein the computer program is arranged to perform the method steps of any one of claims 1 to 7 when run.