[PHOENIX-6182] IndexTool to verify and repair every index row

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0.0, 4.15.0
• Fix Version/s: 5.1.0, 4.16.0, 4.16.1
• Assignee: Tanuj Khurana
• Reporter: Kadir OZDEMIR
• Created: 07/Oct/20 17:19
• Updated: 11/Nov/21 19:06
• Resolved: 02/Feb/21 14:45

Description

IndexTool rebuilds and verifies every index row pointed by the data table. However, IndexTool cannot clean up the index rows that are not referenced by the data table if there are such index rows. In order to do that it needs to scan index table regions and make sure that every index row is valid. For example we can add an option called source table (as in IndexScrutinyTool) to do repair and verify index rows.

Issue Links

• relates to: PHOENIX-6356 missing row.clear() for dummy row in GlobalIndexRegionScanner
• requires: PHOENIX-6181 IndexRepairRegionScanner to verify and repair every global index row
• links to: GitHub Pull Request #1017
• links to: GitHub Pull Request #1022
• links to: GitHub Pull Request #1124
• links to: GitHub Pull Request #1126

Sub-Tasks

• Add option to IndexTool to specify the source table for scan: Resolved
• Generate different query plan depending upon if the source is index table or data table: Resolved
• Add counters for extra index rows, log results to PIT and PIT_RESULT table: Resolved