CN111090658A - Abnormal transaction processing method, system and equipment - Google Patents
Abnormal transaction processing method, system and equipment Download PDFInfo
- Publication number
- CN111090658A CN111090658A CN201911088882.0A CN201911088882A CN111090658A CN 111090658 A CN111090658 A CN 111090658A CN 201911088882 A CN201911088882 A CN 201911088882A CN 111090658 A CN111090658 A CN 111090658A
- Authority
- CN
- China
- Prior art keywords
- transaction
- abnormal
- transaction processing
- transaction information
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q20/00—Payment architectures, schemes or protocols
- G06Q20/08—Payment architectures
- G06Q20/10—Payment architectures specially adapted for electronic funds transfer [EFT] systems; specially adapted for home banking systems
- G06Q20/108—Remote banking, e.g. home banking
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Finance (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application provides an abnormal transaction processing method, an abnormal transaction processing system and equipment thereof, wherein the method applied to transaction processing application comprises the following steps: calling a monitoring interface according to a preset period; if the first abnormal transaction information fed back by the monitoring interface is obtained, reading second abnormal transaction information of a transaction server corresponding to the transaction processing application; matching the first abnormal transaction information with the second abnormal transaction information, and judging whether target abnormal transaction information successfully matched is contained; and if the target abnormal transaction information is contained, calling an clearing interface to clear the thread corresponding to the target abnormal transaction information. Therefore, automatic detection and processing of abnormal transactions are achieved, automatic discovery and processing of the abnormal transactions are achieved, and the technical problem that in the prior art, the abnormal transactions are low in processing efficiency due to the fact that manual communication is needed is solved.
Description
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method, a system, and a device for processing an abnormal transaction.
Background
At present, applications that rely on databases to process transactions are becoming more popular, for example, prepaid applications rely on databases to perform processing of transactions such as refunds and payments. In the related art, it may happen that the transaction initiated by the application cannot be fed back normally, in this case, the database administrator is usually relied on to manually monitor the transaction which is not successfully processed, if the abnormal transaction which is not normally submitted is found, the database administrator gives an alarm through a short message, and after confirming the application, the database administrator contacts the application management technician to check the state of the application server. If the state of the application server is confirmed to be abnormal, the application management technician firstly conducts isolation processing on the corresponding abnormal account to ensure that new business does not conduct new operation on the account any more, then a database administrator manually removes abnormal transactions, and then communicates with the application management technician whether the corresponding abnormal account recovers transaction processing or not.
However, in the above-described prior art, monitoring and processing of abnormal transactions all depend on manual work, and communication time required by technicians is long, which results in lengthening of fault time of corresponding account, resulting in low processing efficiency of abnormal transactions, and affecting transaction processing services.
Disclosure of Invention
The present application is directed to solving, at least to some extent, one of the technical problems in the related art described above.
The application provides an abnormal transaction processing method, system and equipment thereof, which aim to solve the technical problem of low abnormal transaction processing efficiency caused by manual communication in the prior art.
An embodiment of a first aspect of the present application provides an abnormal transaction processing method, where the method is applied in a transaction processing application, the transaction processing application is in communication connection with a transaction processing database, and the transaction processing database includes a preset monitoring interface and a preset clearing interface, where the method includes the following steps: calling the monitoring interface according to a preset period; if the first abnormal transaction information fed back by the monitoring interface is obtained, reading second abnormal transaction information of a transaction server corresponding to the transaction processing application; matching the first abnormal transaction information with the second abnormal transaction information, and judging whether target abnormal transaction information successfully matched is contained; and if the target abnormal transaction information is contained, calling the clearing interface to clear the thread corresponding to the target abnormal transaction information.
In addition, the abnormal transaction processing method of the embodiment of the application further includes the following additional technical features:
in an embodiment of the present application, the matching the first abnormal transaction information and the second abnormal transaction information, and determining whether the target abnormal transaction information that is successfully matched is included includes: extracting a first abnormal transaction identifier in the first abnormal transaction information and a second abnormal transaction identifier in the second abnormal transaction information; and judging whether the first abnormal transaction identifier is consistent with the second abnormal transaction identifier.
In one embodiment of the present application, the first abnormal transaction identifier and the second abnormal transaction identifier include: the method comprises the following steps of transaction processing database name, abnormal transaction initiating transaction processing application identification and abnormal transaction thread identification.
In an embodiment of the present application, before the reading the second abnormal transaction information of the transaction server corresponding to the transaction processing application, the method includes: acquiring the processing time of each transaction of each account of the transaction processing application; determining an abnormal account number meeting a preset abnormal condition according to the processing time; and generating the second abnormal transaction information according to the transaction information of the abnormal account.
In an embodiment of the present application, the determining, according to the processing time, an abnormal account that meets a preset abnormal condition includes: judging whether the processing time of each transaction is greater than a preset duration or not; if the processing time is longer than the preset duration, determining that the transaction is an abnormal transaction; judging whether the number of the continuous abnormal transactions of each account exceeds a preset threshold value or not; and if the number exceeds the preset threshold value, determining the corresponding account as the abnormal account.
In an embodiment of the present application, after the determining whether the target abnormal transaction information successfully matched is included, the method further includes: if the target abnormal transaction information is contained, determining a target account corresponding to the target abnormal transaction information; when the transaction aiming at the target account is acquired, isolating the target account and acquiring other accounts related to the target account; and sending the transaction aiming at the target account to a transaction processing database corresponding to the other accounts.
In an embodiment of the present application, after the invoking the clear interface to clear the process corresponding to the target abnormal transaction information if the target abnormal transaction information is included, the method further includes: sending a test transaction for the target account to the transaction processing database; acquiring response information fed back by the transaction processing database aiming at the test transaction; and if the response information is consistent with the successful response information corresponding to the test transaction, releasing the isolation of the target account so as to send the things aiming at the target account to a transaction processing database corresponding to the target account.
An embodiment of a second aspect of the present application provides an abnormal transaction processing method, where the method is applied to a transaction processing database, where the transaction processing database is in communication connection with a transaction processing application, and the transaction processing database includes a preset monitoring interface and a preset clearing interface, where the method includes the following steps: acquiring a first call request of the transaction processing application to the monitoring interface according to a preset period; starting a detection function preset in the monitoring interface according to the first call request, and acquiring first abnormal transaction information in the transaction processing database; feeding back the first abnormal transaction information to the transaction processing application; receiving a second call request of the transaction processing application to the clearing interface, wherein the second call request carries target abnormal transaction information; and calling a preset clearing function through the clearing interface to clear the thread corresponding to the target abnormal transaction information.
An embodiment of a third aspect of the present application provides a transaction processing application, where the transaction processing application is in communication connection with a transaction processing database, and the transaction processing database includes a preset monitoring interface and a preset clearing interface, where the transaction processing application includes: the calling module is used for calling the monitoring interface according to a preset period; the first acquisition module is used for reading second abnormal transaction information of a transaction server corresponding to the transaction processing application when the first abnormal transaction information fed back by the monitoring interface is acquired; the judging module is used for matching the first abnormal transaction information with the second abnormal transaction information and judging whether target abnormal transaction information which is successfully matched is contained; the calling module is further configured to call the clearing interface to clear the thread corresponding to the target abnormal transaction information when the target abnormal transaction information is included.
An embodiment of a fourth aspect of the present application provides a transaction database, where the transaction database is in communication connection with a transaction application, and the transaction database includes a preset monitoring interface and a preset clearing interface, where the transaction database includes: the second obtaining module is used for obtaining a first calling request of the transaction processing application to the monitoring interface according to a preset period; a third obtaining module, configured to start a detection function preset in the monitoring interface according to the first call request, and obtain first abnormal transaction information in the transaction processing database; a feedback module, configured to feed back the first abnormal transaction information to the transaction processing application; a receiving module, configured to receive a second call request of the transaction processing application to the clearing interface, where the second call request carries target abnormal transaction information; and the clearing module is used for calling a preset clearing function through the clearing interface to clear the thread corresponding to the target abnormal transaction information.
An embodiment of a fifth aspect of the present application provides an abnormal transaction processing system, including a transaction processing application, a transaction server corresponding to the transaction processing application, and a transaction processing database, where the transaction processing application is communicatively connected to the transaction processing database, and the transaction processing application is configured to execute the abnormal transaction processing method according to the embodiment of the first aspect; the transaction database is used for executing the abnormal transaction processing method according to the embodiment of the second aspect.
An embodiment of a sixth aspect of the present application provides an electronic device, including: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being configured to perform the exception transaction processing method described in the embodiment of the first aspect.
An embodiment of a seventh aspect of the present application proposes a non-transitory computer-readable storage medium, which stores computer instructions for causing the computer to execute the exception transaction processing method described in the embodiment of the first aspect.
The technical scheme provided by the application at least comprises the following technical effects:
the automatic processing that the account is locked by abnormal affairs in a database caused by application server faults is realized, manual intervention is not needed, services are quickly recovered, all automatic processing is realized, the abnormal affairs of database information are actively packaged and inquired, corresponding interfaces are packaged, the transaction processing application is used for actively detecting, the problem of manual detection of a monitoring system is avoided, the fault finding time is shortened, the isolation service aiming at the abnormal account is actively isolated, subsequent service loss is reduced, the recovery service is performed in an active detection mode, the usability is ensured, generally speaking, unilateral manual checking is avoided, automatic judgment and processing of a full link between the transaction processing application and the transaction processing database are formed, and subsequent intelligent processing is facilitated.
Additional aspects and advantages of the present application will be set forth in part in the description which follows and, in part, will be obvious from the description, or may be learned by practice of the present application.
Drawings
The foregoing and/or additional aspects and advantages of the present application will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings of which:
FIG. 1 is a block diagram of an exception transaction processing system according to one embodiment of the present application;
fig. 2 is a flowchart illustrating an abnormal transaction processing method according to an embodiment of the present application;
fig. 3 is a flowchart illustrating another exception transaction processing method according to an embodiment of the present application;
fig. 4 is a schematic view of an application scenario of exception transaction processing according to an embodiment of the present application;
fig. 5 is a schematic structural diagram of a transaction application according to an embodiment of the present application; and
fig. 6 is a schematic structural diagram of a transaction database according to an embodiment of the present application.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary and intended to be used for explaining the present application and should not be construed as limiting the present application.
The following describes an abnormal transaction processing method, system and device thereof according to an embodiment of the present application with reference to the drawings. The abnormal transaction in the embodiment of the present application may be any transaction conforming to the interactive processing with the database, for example, various processing transactions (including payment and refund) of the payment transaction by the fund preparation application may be possible.
In order to solve the problems that in the prior art, the processing time is long and the service quality is affected due to the fact that manual intervention and processing are relied on in the abnormal transaction processing, the method for automatically processing the abnormal transaction and recovering the service processing capability of the related account is provided.
In order to make the application scenario of the exception transaction processing of the present application more clearly understood by those skilled in the art, first, the exception transaction processing system of the embodiment of the present application is explained.
FIG. 1 is a block diagram of an exception transaction processing system according to one embodiment of the present application. As shown in fig. 1, the exception transaction processing system includes: the transaction processing application 100, the transaction server 300 corresponding to the transaction processing application, and the transaction processing database 200, where, referring to fig. 1, the transaction processing application 100 is connected in communication with the transaction processing database 200, in this embodiment, the transaction processing database 200 is used to process a transaction sent to the transaction processing application 100, where the transaction processing application 100 may be a pay-as-you-go application, etc., the transaction processing application 100 may correspond to one or more transaction processing databases 200 (only one shown in the figure), and a transaction sent to the transaction processing application 100 may correspond to multiple account numbers, for example, a transaction sent to the pay-as-you-go application may be sent by a pay account number, a transaction sent by a pay-as-you-go account number, etc.
Specifically, the transaction processing application 100 may implement automatic communication with the transaction processing database 200 through a preset monitoring interface and a clearing interface included in the transaction processing database 200, and release manual interaction based on the automatic communication, thereby improving the processing efficiency of the abnormal transaction, and in addition, the abnormal transaction mentioned in the embodiments of the present application refers to a transaction that is not processed in time, which may cause data jamming and thus cause the transaction processing application 100 to roll back.
In this embodiment, if an abnormal transaction occurring in the transaction application 100 is found and exists in the transaction database 200 at the same time, it indicates that a transaction level processing jam actually occurs, for example, after a new transaction to an account is initiated by a pay-for-deposit application server, the application server suddenly goes down due to a hardware fault, the application server loses response, the transaction cannot be normally submitted or rolled back, the account is locked by an uncommitted transaction, so that new operation transactions to the account by other application servers enter a waiting state, and a transaction jam occurs in the database, so that a deposit failure occurs.
For convenience of explanation, the following description focuses on the method side of the application in a transaction application. As mentioned in the above embodiments, the transaction application is in communication connection with a transaction database, and the transaction database includes a preset monitoring interface and a preset clearing interface.
Specifically, fig. 2 is a schematic flowchart of an abnormal transaction processing method according to an embodiment of the present application.
As shown in fig. 2, the exception transaction processing method includes the following steps:
Specifically, in this embodiment, the transaction processing application actively monitors whether an abnormal transaction exists in the database according to a preset period, that is, detects abnormal transaction information of the transaction processing database by calling the monitoring interface.
Because there may be a plurality of transaction databases corresponding to the transaction application, it may be determined at intervals whether there is abnormal transaction information in the plurality of transaction databases corresponding to the transaction application, for example, it may be detected whether there is abnormal transaction information in all the transaction databases in the machine room corresponding to the transaction application.
The preset period may be set according to actual needs, and as a possible implementation manner, the preset period may be 5 seconds.
And step 102, if the first abnormal transaction information fed back by the monitoring interface is obtained, reading second abnormal transaction information of a transaction server corresponding to the transaction processing application.
It should be noted that the first abnormal transaction information is abnormal information in the transaction processing database, the transaction processing database may determine whether the operation time for the transaction exceeds a preset duration, if so, the transaction is considered to be abnormal, the second abnormal transaction information refers to an abnormality in the transaction processing application, the abnormality may be a service abnormality such as a password input error by a user for 3 times, and the abnormality may also include a response timeout abnormality, that is, the processing time of each transaction for each account in the transaction processing application is acquired, the abnormal account satisfying a preset abnormal condition is determined according to the processing time, and the second abnormal transaction information is generated according to the transaction information of the abnormal account, where the transaction information of the abnormal account corresponds to the second abnormal transaction information, and may include a name of the transaction processing database corresponding to the abnormal account, An abnormal transaction initiating transaction application identification, an abnormal transaction thread identification, and the like.
In practical application, a central control node is provided, the central control node monitors logs of all application servers, abnormal statistics of operation states of account numbers can be obtained, if one application server fails, and for a failed transaction of account number locking, a final operated transaction processing database can be detected by the central control node, wherein operation failure of a single application server for the account number operation is judged according to time, when operation failure occurs, information about abnormal transactions is output to the logs, and the central control node can monitor abnormal transaction information in the logs, so that second abnormal transaction information of the transaction server can be read based on the central control node. It should be noted that, in different application scenarios, the manner of determining the abnormal account satisfying the preset abnormal condition according to the processing time is different, and the example is as follows:
example one:
in this example, whether the processing time of each transaction is greater than a preset duration is determined, where the preset duration may be determined according to the transaction type of each transaction, and if the processing time is greater than the preset duration, the transaction is determined to be an abnormal transaction, and further, whether the number of the abnormal transactions occurring continuously in each account exceeds a preset threshold is determined, for example, five times of the continuous abnormal transactions occur, and if the processing time exceeds the preset threshold, the corresponding account is determined to be an abnormal account.
Example two:
in this example, the transaction type of each transaction is obtained, whether the processing time of each transaction is greater than a preset duration is judged, wherein the preset duration can be determined according to the transaction type of each transaction, if the processing time is greater than the preset duration, the transaction is determined to be an abnormal transaction, further, whether the number of abnormal transactions corresponding to the preset transaction type is greater than a preset number within a preset time period is determined, and if the processing time is greater than the preset number, the corresponding account is determined to be an abnormal account.
And 103, matching the first abnormal transaction information with the second abnormal transaction information, and judging whether the target abnormal transaction information successfully matched is included.
Specifically, the monitoring interface acquires first abnormal transaction information in the transaction processing database, and if the first abnormal transaction information is acquired, whether the first abnormal transaction information exists in the transaction server at the same time is judged, so that whether abnormal transactions needing to be cleared exist is judged based on whether the abnormal transactions exist at the same time.
As a possible implementation manner, the first abnormal transaction information and the second abnormal transaction information both include an abnormal transaction identifier, which may include any information capable of locating uniqueness of the abnormal transaction, for example, the abnormal transaction identifier includes a transaction processing database name, an abnormal transaction initiating transaction processing application identifier (such as a transaction processing application IP), and an abnormal transaction thread identifier (such as a thread number).
Of course, in order to obtain more comprehensive abnormal transaction information, the first abnormal transaction information may further include other information, such as the time held by the abnormal transaction, the SQL text of the executed transaction, and the like, and the obtaining of the information depends on the definition of the relevant parameters in the monitoring interface.
And step 104, if the target abnormal transaction information is contained, calling a clearing interface to clear the thread corresponding to the target abnormal transaction information.
Specifically, if the transaction information includes the target abnormal transaction information, that is, the transaction information is considered to include information that is abnormal in the transaction processing application and the transaction processing database at the same time, in order to quickly reply to the normal transaction processing, the clearing interface may be invoked to clear the thread corresponding to the target abnormal transaction information.
In an embodiment of the present application, in order to avoid that new matters cannot be executed, service isolation processing may be performed on a target account with target abnormal transaction information.
Specifically, if the target account corresponding to the target abnormal transaction information is determined if the target abnormal transaction information is contained, it can be understood that the abnormal transaction information is for a certain account, and therefore, the account identification information can be extracted to obtain the target account, and further, when a new transaction for the target account is obtained, the target account is isolated and other accounts associated with the target account are obtained, for example, generally, 3 to 5 accounts exist in a larger organization, so that all accounts for the same organization can be associated, and thus, the object for the target account is sent to a transaction processing database of an account in which the abnormal transaction information does not exist in other accounts.
In this embodiment, in order to further verify whether the target account has a function of recovering the transaction processing, after the process corresponding to the target abnormal transaction information is cleared by calling the clearing interface, a test transaction for the target account may be sent to the transaction processing database, and if response information fed back by the transaction processing database for the test transaction is acquired and the response information is consistent with successful response information corresponding to the test transaction, isolation of the target account is released so as to send the transaction for the target account to the transaction processing database corresponding to the target account.
Based on the embodiment, in order to facilitate the optimization of the processing process of the abnormal transaction, the whole process of the abnormal transaction processing can be sent to a log file for recording, so as to find out the defects in time and optimize.
Therefore, the abnormal transaction processing method in the embodiment realizes automatic processing of locking the account number by the abnormal transaction in the database caused by the fault of the application server, does not need manual intervention, quickly recovers services, automatically processes all the services, actively isolates the services, and reduces subsequent service loss.
The following description focuses on the transaction database side to finally describe the abnormal transaction processing method according to the embodiment of the present application.
The monitoring interface and the clearing interface in the transaction processing database can be packaged through python and provide access to the outside in an HTTP mode, in order to avoid abuse of other applications, the limitation that a single application IP can be accessed for at most 1 time per second can be set, and an abnormal warning is returned when the number of times of access exceeds the number of times, so that the situation that the interfaces are called in large quantity and the database is influenced is prevented. And the access of the application IP to the interface is set, so that other application IPs are prevented from calling the interface, and the security is enhanced. For example, a white list application IP is set, and when the IP of the accessed transaction processing application belongs to the white list application IP, the corresponding transaction processing application is allowed to call the transaction processing database.
Fig. 3 is a flowchart illustrating another exception transaction processing method according to an embodiment of the present application.
As shown in fig. 3, the exception transaction processing method includes:
When executed, a detection function in a monitoring interface in a transaction processing database may obtain first abnormal transaction information in the transaction processing database, where specific content included in the first abnormal transaction information may be implemented according to a parameter definition in the detection function, and as a possible implementation manner, parameters in the detection function are as follows: clientIp is the IP of the transaction application, db is the transaction database, the thread number of the abnormal transaction, the locktime is the time of the abnormal transaction, and SQL _ text is the SQL executed by the abnormal transaction.
As a possible implementation, the monitoring interface returns the first abnormal transaction information in json.
And 204, receiving a second call request of the transaction processing application to the clearing interface, wherein the second call request carries target abnormal transaction information.
When the transaction processing application finds that the target abnormal transaction information matched with the abnormal transaction information exists in the application server side, the clearing interface is called.
The clearing interface is configured to clear the thread corresponding to the target abnormal transaction information, that is, the clearing interface calls a preset clearing function to clear the thread corresponding to the target abnormal transaction information, and as a possible implementation manner, the clearing function may obtain the abnormal transaction information in the following transaction processing data: and the clientIp is the IP of the transaction application corresponding to the abnormal transaction, db is the transaction database where the abnormal transaction exists, the thread number of the abnormal transaction is the readId, and the like, the obtained abnormal transaction information is compared with the target abnormal transaction information again, and if the obtained abnormal transaction information is consistent with the target abnormal transaction information, the corresponding process is cleared.
In order to enable those skilled in the art to more clearly understand the whole process of the abnormal transaction processing method, a specific application scenario is described below, in the application scenario, the detection interface and the purge interface provided by the transaction processing database are located as DBAs, and the transaction processing application is RCMP, that is, as shown in fig. 4, the RCMP triggers an active probing function at that time, so that the DBAs executes a probing script corresponding to the probing function, and then the DBA feeds back first abnormal transaction information, and if the RCMP includes target abnormal transaction information matching the first abnormal transaction information, the purge interface in the DBA is executed, a KILL function is executed, and a processing result is fed back to the RCMP.
To sum up, the abnormal transaction processing method of the embodiment of the present application implements automatic processing of locking an account by an abnormal transaction in a database caused by a failure of an application server, does not require manual intervention, rapidly recovers services, and performs all automatic processing by actively encapsulating the abnormal transaction inquiring information of the database, and encapsulating the abnormal transaction into a corresponding interface for active detection by a transaction processing application, thereby avoiding the problem of manual detection of a monitoring system, reducing failure discovery time, actively isolating an isolation service for the abnormal account, reducing subsequent service loss, and performing the recovery service in an active detection manner, thereby ensuring availability.
In order to implement the above embodiments, the present application also provides a transaction processing application. The transaction processing application is in communication connection with a transaction processing database, where the transaction processing database includes a preset monitoring interface and a preset clearing interface, and as shown in fig. 5, the transaction processing application includes: a calling module 110, a first obtaining module 120, and a determining module 130, wherein,
the invoking module 110 is configured to invoke the monitoring interface according to a preset period.
The first obtaining module 120 is configured to, when the first abnormal transaction information fed back by the monitoring interface is obtained, read second abnormal transaction information of a transaction server corresponding to the transaction processing application.
The judging module 130 is configured to match the first abnormal transaction information with the second abnormal transaction information, and judge whether target abnormal transaction information successfully matched is included;
in this embodiment, the invoking module 110 is further configured to invoke the clearing interface to clear the thread corresponding to the target abnormal transaction information when the target abnormal transaction information is included.
In order to implement the foregoing embodiment, the present application further provides a transaction processing database, where the transaction processing database is in communication connection with a transaction processing application, and the transaction processing database includes a preset monitoring interface and a preset clearing interface, where as shown in fig. 6, the transaction processing database includes: a second acquisition module 210, a third acquisition module 220, a feedback module 230, a receiving module 240, and a clearing module 250, wherein,
the second obtaining module 210 is configured to obtain a first call request of the transaction application to the monitoring interface according to a preset period.
The third obtaining module 220 is configured to start a detection function preset in the monitoring interface according to the first call request, and obtain the first abnormal transaction information in the transaction processing database.
A feedback module 230, configured to feed back the first abnormal transaction information to the transaction processing application.
The receiving module 240 is configured to receive a second call request of the transaction processing application to the clear interface, where the second call request carries target abnormal transaction information.
And the clearing module 250 is configured to invoke a preset clearing function through the clearing interface to clear the thread corresponding to the target abnormal transaction information.
It should be noted that the foregoing explanation of the abnormal transaction processing method is also applicable to the relevant devices in the embodiments of the present application, and the implementation principle thereof is similar and will not be described herein again.
In order to implement the foregoing embodiments, the present application further provides an electronic device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, and when the processor executes the computer program, the electronic device implements the abnormal transaction processing method described in the foregoing embodiments and focused on the transaction processing application side.
In order to implement the above embodiments, the present application also proposes a non-transitory computer-readable storage medium storing computer instructions for causing the computer to execute the abnormal transaction processing method described in the above embodiments focusing on the transaction processing application side.
In the description herein, reference to the description of the term "one embodiment," "some embodiments," "an example," "a specific example," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the application. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Furthermore, the terms "first", "second" and "first" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In the description of the present application, "plurality" means at least two, e.g., two, three, etc., unless specifically limited otherwise.
Any process or method descriptions in flow charts or otherwise described herein may be understood as representing modules, segments, or portions of code which include one or more executable instructions for implementing steps of a custom logic function or process, and alternate implementations are included within the scope of the preferred embodiment of the present application in which functions may be executed out of order from that shown or discussed, including substantially concurrently or in reverse order, depending on the functionality involved, as would be understood by those reasonably skilled in the art of the present application.
The logic and/or steps represented in the flowcharts or otherwise described herein, e.g., an ordered listing of executable instructions that can be considered to implement logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device. More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). Additionally, the computer-readable medium could even be paper or another suitable medium upon which the program is printed, as the program can be electronically captured, via for instance optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner if necessary, and then stored in a computer memory.
It should be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above embodiments, the various steps or methods may be implemented in software or firmware stored in memory and executed by a suitable instruction execution system. If implemented in hardware, as in another embodiment, any one or combination of the following techniques, which are known in the art, may be used: a discrete logic circuit having a logic gate circuit for implementing a logic function on a data signal, an application specific integrated circuit having an appropriate combinational logic gate circuit, a Programmable Gate Array (PGA), a Field Programmable Gate Array (FPGA), or the like.
It will be understood by those skilled in the art that all or part of the steps carried by the method for implementing the above embodiments may be implemented by hardware related to instructions of a program, which may be stored in a computer readable storage medium, and when the program is executed, the program includes one or a combination of the steps of the method embodiments.
In addition, functional units in the embodiments of the present application may be integrated into one processing module, or each unit may exist alone physically, or two or more units are integrated into one module. The integrated module can be realized in a hardware mode, and can also be realized in a software functional module mode. The integrated module, if implemented in the form of a software functional module and sold or used as a stand-alone product, may also be stored in a computer readable storage medium.
The storage medium mentioned above may be a read-only memory, a magnetic or optical disk, etc. Although embodiments of the present application have been shown and described above, it is understood that the above embodiments are exemplary and should not be construed as limiting the present application, and that variations, modifications, substitutions and alterations may be made to the above embodiments by those of ordinary skill in the art within the scope of the present application.
Claims (13)
1. An abnormal transaction processing method is applied to a transaction processing application, the transaction processing application is in communication connection with a transaction processing database, and the transaction processing database comprises a preset monitoring interface and a preset clearing interface, wherein the method comprises the following steps:
calling the monitoring interface according to a preset period;
if the first abnormal transaction information fed back by the monitoring interface is obtained, reading second abnormal transaction information of a transaction server corresponding to the transaction processing application;
matching the first abnormal transaction information with the second abnormal transaction information, and judging whether target abnormal transaction information successfully matched is contained;
and if the target abnormal transaction information is contained, calling the clearing interface to clear the thread corresponding to the target abnormal transaction information.
2. The method of claim 1, wherein the matching the first abnormal transaction information with the second abnormal transaction information and determining whether the target abnormal transaction information successfully matched is included comprises:
extracting a first abnormal transaction identifier in the first abnormal transaction information and a second abnormal transaction identifier in the second abnormal transaction information;
and judging whether the first abnormal transaction identifier is consistent with the second abnormal transaction identifier.
3. The method of claim 2, wherein the first and second anomalous transaction identifications comprise:
the method comprises the following steps of transaction processing database name, abnormal transaction initiating transaction processing application identification and abnormal transaction thread identification.
4. The method of claim 1, wherein before the reading the second abnormal transaction information of the transaction server corresponding to the transaction processing application, the method comprises:
acquiring the processing time of each transaction of each account of the transaction processing application;
determining an abnormal account number meeting a preset abnormal condition according to the processing time;
and generating the second abnormal transaction information according to the transaction information of the abnormal account.
5. The method according to claim 4, wherein the determining, according to the processing time, the abnormal account number meeting the preset abnormal condition includes:
judging whether the processing time of each transaction is greater than a preset duration or not;
if the processing time is longer than the preset duration, determining that the transaction is an abnormal transaction;
judging whether the number of the continuous abnormal transactions of each account exceeds a preset threshold value or not;
and if the number exceeds the preset threshold value, determining the corresponding account as the abnormal account.
6. The method of claim 1, after the determining whether the target abnormal transaction information with the successful match is included, further comprising:
if the target abnormal transaction information is contained, determining a target account corresponding to the target abnormal transaction information;
when the transaction aiming at the target account is acquired, isolating the target account and acquiring other accounts related to the target account;
and sending the transaction aiming at the target account to a transaction processing database corresponding to the other accounts.
7. The method of claim 6, wherein after the step of calling the cleanup interface to clean the process corresponding to the target abnormal transaction information if the target abnormal transaction information is included, further comprising:
sending a test transaction for the target account to the transaction processing database;
acquiring response information fed back by the transaction processing database aiming at the test transaction;
and if the response information is consistent with the successful response information corresponding to the test transaction, releasing the isolation of the target account so as to send the things aiming at the target account to a transaction processing database corresponding to the target account.
8. An abnormal transaction processing method is applied to a transaction processing database, wherein the transaction processing database is in communication connection with a transaction processing application, and the transaction processing database comprises a preset monitoring interface and a preset clearing interface, wherein the method comprises the following steps:
acquiring a first call request of the transaction processing application to the monitoring interface according to a preset period;
starting a detection function preset in the monitoring interface according to the first call request, and acquiring first abnormal transaction information in the transaction processing database;
feeding back the first abnormal transaction information to the transaction processing application;
receiving a second call request of the transaction processing application to the clearing interface, wherein the second call request carries target abnormal transaction information;
and calling a preset clearing function through the clearing interface to clear the thread corresponding to the target abnormal transaction information.
9. A transaction application, wherein the transaction application is communicatively connected to a transaction database, and the transaction database includes a preset monitoring interface and a preset clearing interface, and the transaction application includes:
the calling module is used for calling the monitoring interface according to a preset period;
the first acquisition module is used for reading second abnormal transaction information of a transaction server corresponding to the transaction processing application when the first abnormal transaction information fed back by the monitoring interface is acquired;
the judging module is used for matching the first abnormal transaction information with the second abnormal transaction information and judging whether target abnormal transaction information which is successfully matched is contained;
the calling module is further configured to call the clearing interface to clear the thread corresponding to the target abnormal transaction information when the target abnormal transaction information is included.
10. A transaction database, wherein the transaction database is in communication connection with a transaction application, and the transaction database includes a preset monitoring interface and a preset clearing interface, and wherein the transaction database includes:
the second obtaining module is used for obtaining a first calling request of the transaction processing application to the monitoring interface according to a preset period;
a third obtaining module, configured to start a detection function preset in the monitoring interface according to the first call request, and obtain first abnormal transaction information in the transaction processing database;
a feedback module, configured to feed back the first abnormal transaction information to the transaction processing application;
a receiving module, configured to receive a second call request of the transaction processing application to the clearing interface, where the second call request carries target abnormal transaction information;
and the clearing module is used for calling a preset clearing function through the clearing interface to clear the thread corresponding to the target abnormal transaction information.
11. An abnormal transaction processing system, which comprises a transaction processing application, a transaction server corresponding to the transaction processing application, and a transaction processing database, wherein the transaction processing application is connected with the transaction processing database in a communication way, wherein,
the transaction processing application is configured to perform the exception transaction processing method of any of claims 1-7;
the transaction database is for executing the exception transaction processing method of claim 8.
12. An electronic device, comprising:
at least one processor; and a memory communicatively coupled to the at least one processor;
wherein the memory stores instructions executable by the at least one processor, the instructions being arranged to perform the exception transaction processing method of any of claims 1 to 7.
13. A non-transitory computer-readable storage medium storing computer instructions for causing a computer to perform the exception transaction processing method of any one of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911088882.0A CN111090658B (en) | 2019-11-08 | 2019-11-08 | Abnormal transaction processing method, system and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911088882.0A CN111090658B (en) | 2019-11-08 | 2019-11-08 | Abnormal transaction processing method, system and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111090658A true CN111090658A (en) | 2020-05-01 |
| CN111090658B CN111090658B (en) | 2021-03-02 |
Family
ID=70393239
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911088882.0A Active CN111090658B (en) | 2019-11-08 | 2019-11-08 | Abnormal transaction processing method, system and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111090658B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111586057A (en) * | 2020-05-09 | 2020-08-25 | 杭州安恒信息技术股份有限公司 | Transaction level Modbus protocol industrial control abnormal behavior detection method and system |
| CN111813615A (en) * | 2020-06-30 | 2020-10-23 | 光大兴陇信托有限责任公司 | Transaction exception processing method for application system |
| CN113537009A (en) * | 2021-06-30 | 2021-10-22 | 上海晶赞融宣科技有限公司 | Household isolation supervision system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070069006A1 (en) * | 2005-09-02 | 2007-03-29 | Honda Motor Co., Ltd. | Automated Handling of Exceptions in Financial Transaction Records |
| US20130097136A1 (en) * | 2011-10-17 | 2013-04-18 | Pie Digital, Inc. | Method and system for acessing domain specific in-memory database management system |
| US20160379185A1 (en) * | 2015-06-25 | 2016-12-29 | Bank Of America Corporation | Predictive determination and resolution of a value of indicia located in a negotiable instrument electronic image |
| CN107844363A (en) * | 2017-10-27 | 2018-03-27 | 东软集团股份有限公司 | Business transaction processing method, device, storage medium and equipment |
| CN107908494A (en) * | 2017-11-10 | 2018-04-13 | 泰康保险集团股份有限公司 | Processing method, device, electronic equipment and the storage medium of anomalous event |
| CN108108479A (en) * | 2018-01-04 | 2018-06-01 | 山东中创软件商用中间件股份有限公司 | A kind of database connecting detection method, system, equipment and computer media |
| CN108243056A (en) * | 2016-12-27 | 2018-07-03 | 大唐移动通信设备有限公司 | A kind of method and device for obtaining exception information |
| CN108319711A (en) * | 2018-02-07 | 2018-07-24 | 腾讯科技（深圳）有限公司 | Transaction consistency test method, device, storage medium and the equipment of database |
| CN109785042A (en) * | 2018-12-13 | 2019-05-21 | 深圳平安财富宝投资咨询有限公司 | Abnormality eliminating method, server, storage medium and the device of distributed deployment |
-
2019
- 2019-11-08 CN CN201911088882.0A patent/CN111090658B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070069006A1 (en) * | 2005-09-02 | 2007-03-29 | Honda Motor Co., Ltd. | Automated Handling of Exceptions in Financial Transaction Records |
| US20130097136A1 (en) * | 2011-10-17 | 2013-04-18 | Pie Digital, Inc. | Method and system for acessing domain specific in-memory database management system |
| US20160379185A1 (en) * | 2015-06-25 | 2016-12-29 | Bank Of America Corporation | Predictive determination and resolution of a value of indicia located in a negotiable instrument electronic image |
| CN108243056A (en) * | 2016-12-27 | 2018-07-03 | 大唐移动通信设备有限公司 | A kind of method and device for obtaining exception information |
| CN107844363A (en) * | 2017-10-27 | 2018-03-27 | 东软集团股份有限公司 | Business transaction processing method, device, storage medium and equipment |
| CN107908494A (en) * | 2017-11-10 | 2018-04-13 | 泰康保险集团股份有限公司 | Processing method, device, electronic equipment and the storage medium of anomalous event |
| CN108108479A (en) * | 2018-01-04 | 2018-06-01 | 山东中创软件商用中间件股份有限公司 | A kind of database connecting detection method, system, equipment and computer media |
| CN108319711A (en) * | 2018-02-07 | 2018-07-24 | 腾讯科技（深圳）有限公司 | Transaction consistency test method, device, storage medium and the equipment of database |
| CN109785042A (en) * | 2018-12-13 | 2019-05-21 | 深圳平安财富宝投资咨询有限公司 | Abnormality eliminating method, server, storage medium and the device of distributed deployment |
Non-Patent Citations (2)
| Title |
|---|
| S. INOUE: "Adapting transactions to exceptional situations using structured messages", 《PROCEEDINGS 1999 INTERNATIONAL SYMPOSIUM ON DATABASE APPLICATIONS IN NON-TRADITIONAL ENVIRONMENTS 》 * |
| 罗斌: "多数据库系统中数据一致性维护技术的研究与实现", 《中国优秀硕士学位论文全文数据库信息科技辑》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111586057A (en) * | 2020-05-09 | 2020-08-25 | 杭州安恒信息技术股份有限公司 | Transaction level Modbus protocol industrial control abnormal behavior detection method and system |
| CN111586057B (en) * | 2020-05-09 | 2022-08-16 | 杭州安恒信息技术股份有限公司 | Transaction level Modbus protocol industrial control abnormal behavior detection method and system |
| CN111813615A (en) * | 2020-06-30 | 2020-10-23 | 光大兴陇信托有限责任公司 | Transaction exception processing method for application system |
| CN111813615B (en) * | 2020-06-30 | 2024-02-23 | 光大兴陇信托有限责任公司 | Transaction exception processing method for application system |
| CN113537009A (en) * | 2021-06-30 | 2021-10-22 | 上海晶赞融宣科技有限公司 | Household isolation supervision system |
| CN113537009B (en) * | 2021-06-30 | 2024-02-13 | 上海晶赞融宣科技有限公司 | Household isolation supervision system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111090658B (en) | 2021-03-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111090658B (en) | Abnormal transaction processing method, system and equipment | |
| US7389341B2 (en) | Remotely monitoring a data processing system via a communications network | |
| CN108616404B (en) | Customer service method, management platform, storage medium and system | |
| US20080098109A1 (en) | Incident resolution | |
| CN110034948B (en) | Method and device for troubleshooting system faults | |
| US7995485B1 (en) | Method and apparatus for providing automated diagnostics of networks | |
| CN107800783B (en) | Method and device for remotely monitoring server | |
| CN110275992B (en) | Emergency processing method, device, server and computer readable storage medium | |
| CN114095258B (en) | Attack defense method, attack defense device, electronic equipment and storage medium | |
| WO2022135158A1 (en) | Transaction request processing method and apparatus, and transaction transfer system | |
| CN111698121B (en) | SNMP trap alarm test method and related device | |
| CN105653322A (en) | Operation and maintenance server and server event processing method | |
| CN114793132A (en) | Optical module detection method and device, electronic equipment and storage medium | |
| CN113411209A (en) | Distributed password service full-link detection system and method | |
| CN112561506A (en) | Live broadcast data processing method, system, device and medium based on virtual currency | |
| US10674337B2 (en) | Method and device for processing operation for device peripheral | |
| CN113271337B (en) | Method and device for subscribing computer message | |
| CN114090369A (en) | Service instance monitoring method, device and storage medium | |
| US11862007B2 (en) | Method for automatically analyzing and filtering out redundant alarms in the fault management system of radio transceiver stations | |
| CN116610379A (en) | Method and device for starting pcsd service | |
| CN117354188A (en) | Method, device, equipment and medium for monitoring abnormality of thread stay full link | |
| CN115269307A (en) | Method and device for monitoring batch processing | |
| CN115171300A (en) | Bank self-service equipment fault handling method and device | |
| CN114741227A (en) | Method and device for repairing program fault and electronic equipment | |
| CN115237567A (en) | Service data processing method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |