[IGNITE-13572] Duplicates in select query during partition eviction for caches with 0 backups

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.9, 2.8.1
• Fix Version/s: 2.10, 2.9.1
• Component/s: sql
• Release Note: Don't skip filtering for caches with zero backups.
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Konstantin Sirotkin
• Reporter: Ivan Daschinsky
• Reviewer: Alexey Goncharuk
• Created: 12/Oct/20 13:28
• Updated: 11/Jan/21 16:54
• Resolved: 02/Dec/20 08:57

Description

Scenario:

1. Start 2 nodes with indexed atomic partitioned cache with 0 backups.
2. Load sufficient amout of data (or emulate slow removal from idx)
3. Start another node.
4. Perform SELECT * FROM <TABLE>.

Query result contains duplicates, result size is significantly bigger than expected cache size.

Reproducer is attached.

Reproduced on 2.8.1, ongoing 2.9 and master

Issue Links

• breaks: IGNITE-13561 Fix non-stable test for dynamic indexing
• links to: GitHub Pull Request #8439