Identifying double write errors in databases

A non-transitory computer-readable medium storing instructions that, when executed by one or more processors, cause the one or more processors to perform operations including:

• receiving a first indication of a first database write to a first database comprising first information about the first database write;
• receiving a second indication of a second database write to a second database comprising second information about the second database write;
• determining a time interval between the first database write and the second database write;
• responsive to the time interval being less than a predefined threshold time interval, determining a difference between the first database write and the second database write based on a comparison of the first information about the first database write and the second information about the second database write;
• generating a double write error comprising the first information about the first database write and the second information about the second database write;
• determining a latest database write based on the first information about the first database write and the second information about the second database write;
• generating a corrective database transaction based on the latest database write, the corrective database transaction comprising at least one of a first database command for the first database or a second database command for the second database;
• and
• executing the corrective database transaction to correct the double write error.

A system comprising:

• one or more processors;
• and
• one or more computer-readable storage media storing instructions which, when executed by the one or more processors, cause the one or more processors to perform operations including:
• receiving a first indication of a first database write to a first database comprising first information about the first database write;
• receiving a second indication of a second database write to a second database comprising second information about the second database write;
• determining a time interval between the first database write and the second database write;
• responsive to the time interval being less than a predefined threshold time interval, determining a difference between the first database write and the second database write based on a comparison of the first information about the first database write and the second information about the second database write;
• generating a double write error comprising the first information about the first database write and the second information about the second database write;
• determining a latest database write based on the first information about the first database write and the second information about the second database write;
• generating a corrective database transaction based on the latest database write, the corrective database transaction comprising at least one of a first database command for the first database or a second database command for the second database;
• and
• executing the corrective database transaction to correct the double write error.