[IGNITE-18738] Implement Index Cleanup on transaction rollback

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0-beta2
• Component/s: persistence
• Labels: ignite-3
• Epic Link: MV Store
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Semyon Danilov
• Reporter: Semyon Danilov
• Reviewer: Aleksandr Polovtsev
• Created: 07/Feb/23 12:10
• Updated: 14/Feb/23 12:23
• Resolved: 10/Feb/23 08:35

Description

As part of the partition storage implementation , it is necessary to implement an index cleanup mechanism for cases when transactions are aborted and a rollback is required. This cleanup process should ensure that any index updates made during the transaction are properly removed to maintain the integrity.

This mechanism should be abstract enough so that it can be later used for the garbage collection.

https://issues.apache.org/jira/browse/IGNITE-17673 contains a pseudo-code for the index cleanup algorithm

Issue Links

• blocks: IGNITE-18739 Cleanup indexes as part of garbage collection
• is related to: IGNITE-17673 Extend MV partition storage API with methods to help cleaning up SQL indices
• links to: GitHub Pull Request #1657