[Enhancement] Limit the Number of Delete Rowsets in Compaction to Prevent Version Accumulation Errors

[Yukang-Lian]

Search before asking

• I had searched in the issues and found no similar issues.

Description

In the current compaction process, delete rowsets must be merged during the base compaction phase. If there are too many delete rowsets, the system must wait for the base compaction to merge them. Since base compaction runs infrequently, an excessive number of delete rowsets can delay compaction, resulting in too many versions waiting for compaction and eventually causing errors.

Solution

1. Implement a check during every delete operation to verify if the tablet already contains too many delete rowsets.
2. The threshold for the number of delete rowsets should be configurable via a setting in config.
3. If the number of delete rowsets exceeds this threshold, return an error to prevent further accumulation.

This solution aims to ensure that the compaction process is performed in a timely manner and prevent excessive versions from causing errors due to delayed compaction.

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct