[IGNITE-7039] SQL: local query should pin affected partitions

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: sql-stability
• Assignee: Evgeny Stanilovsky
• Reporter: Vladimir Ozerov
• Created: 28/Nov/17 07:24
• Updated: 29/Dec/20 09:52

Description

When distributed query is executed, we pin cache partitions for particular topology version on map nodes [1]. However, it seems that we do no do that for local queries. This is a bug because partition with required data could be evicted from local node at any time, leading to incorrect results.

[1] https://github.com/apache/ignite/blob/ignite-2.3/modules/indexing/src/main/java/org/apache/ignite/internal/processors/query/h2/twostep/GridMapQueryExecutor.java#L288

Issue Links

• is blocked by: IGNITE-6677 Collect QueryDetailMetrics for cache-less SQL queries
• relates to: IGNITE-8927 Hangs when executing an SQL query when there are LOST partitions
• links to: GitHub Pull Request #3194
• links to: GitHub Pull Request #3194
• links to: TC run