[PHOENIX-5627] Queries with SCN can see Cells with expired TTLs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Geoffrey Jacoby
• Reporter: Geoffrey Jacoby
• Created: 17/Dec/19 00:11
• Updated: 20/Dec/19 17:41
• Resolved: 20/Dec/19 17:41

Description

Using the IndexScrutinyTool, we recently saw a case where rows that had expired TTLs were flagged as "inconsistent", because they were seen in one side but not the other. This occurred during both data table -> index and index -> data table verification. Regardless of whether they were indeed inconsistent or not, they shouldn't be seen at all by the scrutiny tool.

In all cases the expired rows were only recently expired (so likely not cleaned up yet by compaction.)

Thanks, priyankporwal for pointing this out.

Issue Links

• duplicates: PHOENIX-5637 Queries with SCN return expired rows