The application discloses a
system, method and storage medium for distributed idempotent state update and expired write shielding. The
system collects and processes node operation indexes to generate a node operation
feature vector E, and a global coordination center assigns a strictly increasing and non-overlapping epoch lock interval [Epoch_low, Epoch_high] to the
processing node according to the
feature vector. The
processing node establishes a placeholder
record in a
memory type storage with an idempotent key and selects an epoch lock Epoch_lock within the interval; after the placeholder is successful, a row-level exclusive lock is applied to the target
record in the same transaction in the business
database, and a double predicate condition update is performed in the order of interval switching and then interval writing; when the upper interval boundary field epoch_hi_field is less than Epoch_low, the upper interval boundary is updated to Epoch_high; when (epoch_field is less than Epoch_lock) and (Epoch_lock is less than or equal to epoch_hi_field), the business state is written and the epoch_field is updated to Epoch_lock, thereby rejecting expired writes. Placeholder
timeout triggers takeover competition, and a script-based atomic conditional update writes takeover_low to determine a unique takeoverer to continue writing. Optionally, a
transaction log drilling index module follows to parse the
transaction log to establish a drilling index and maintain a
watermark_lsn consistency boundary, to support playback,
verification or compensation.