Apparatus for resolving automatic transaction facility (ATF) failures

    公开(公告)号:US12099416B1

    公开(公告)日:2024-09-24

    申请号:US18457858

    申请日:2023-08-29

    申请人: Gravic, Inc.

    IPC分类号: G06F11/00 G06F11/14 G06F16/23

    摘要: An apparatus is provided for resolving an unintended transaction rollback in a system that includes an audited database, a non-audited application, and a facility for converting non-audited applications to use audited database transactions, wherein the unintended transaction rollback is the result of a failure of the facility to convert the unintended transaction rollback to a commit operation, The non-audited application is operated with the facility creating database transactions against the audited database. The database transactions include one or more transaction steps or operations. The created database transactions are monitored to detect transaction rollbacks. A determination is made when a detected transaction rollback for a database transaction is an unintended transaction rollback. The one or more transaction steps or operations of the database transaction that included the unintended transaction rollback are recovered in the audited database. The recovering resolves the unintended transaction rollback. The monitoring, determining, and recovering are performed by an Automatic Transaction Facility (ATF) recovery engine.

    Systems and methods to fully process an initially incomplete replicated and committed transaction

    公开(公告)号:US11681686B1

    公开(公告)日:2023-06-20

    申请号:US16904687

    申请日:2020-06-18

    申请人: Gravic, Inc.

    IPC分类号: G06F16/23 G06F16/27 G06F16/28

    摘要: Methods and apparatus are provided to fully process an initially incomplete replicated and committed transaction. A transaction pattern table is provided that includes a plurality of records, each record being defined by a transaction pattern identifier. Each record includes a transaction pattern and a metric of occurrence of the transaction pattern. An incomplete transaction is automatically compared to the transaction patterns in the table and a subset of transaction patterns in the table are identified that are potential candidates for matching the incomplete transaction. The incomplete transaction is categorized using the metric of occurrence of the transaction pattern for each transaction pattern in the subset. The categorization predicts when all steps or operations of the transaction which have completed in the source database have been replicated, and the incomplete transaction is committed based on this prediction. Any additional steps or operations which have completed in the source database for the committed incomplete transaction are processed as a new transaction applied to the target database, thereby fully processing the incomplete transaction.

    Method for replacing a currently operating data replication engine with a new data replication engine without application downtime and while preserving target database consistency

    公开(公告)号:US10474695B1

    公开(公告)日:2019-11-12

    申请号:US16417049

    申请日:2019-05-20

    申请人: Gravic, Inc.

    IPC分类号: G06F16/27 G06F16/23

    摘要: An automated method is provided for replacing a currently operating data replication engine with a new data replication engine. A currently operating data replication engine reports its audit trail position upon stopping. The new data replication engine starts and is positioned at an audit trail position which is prior to the reported stopped audit trail position by an amount of the audit trail which corresponds to time that is equal to or greater than a source database transaction abort timer. The position of the new data replication engine to the stopped audit trail position defines a position window. Audit trail transactions are processed in the position window by the new data replication engine by ignoring transactions which committed or aborted in the position window, and replicating remaining transactions in the position window from the source database to the target database. The new data replication engine replicates all transactions that are started after the stopped audit trail position.

    Method of ensuring transactional integrity of a system that includes a first subsystem and a second subsystem

    公开(公告)号:US10394798B1

    公开(公告)日:2019-08-27

    申请号:US16213627

    申请日:2018-12-07

    申请人: Gravic, Inc.

    摘要: A method is provided for ensuring transactional integrity of a system that includes a first subsystem and a second subsystem. The first subsystem receives a request to process a transaction. The first subsystem sends to the second subsystem the request to process a transaction. Each of the subsystems process the identical request. An indicia engine at each subsystem computes indicia of the outcome of the processing of the identical request. The indicia engine at the second subsystem sends its computed indicia to the first subsystem, and the indicia engine at the first subsystem compares its computed indicia with the indicia received from the second subsystem, and sends a transaction abort directive to the second subsystem when the comparison indicates that the computed indicia of the second subsystem does not match the computed indicia of the first subsystem, thereby indicating a lack of transactional integrity in one or both of the first and second subsystems.