[IGNITE-17950] Sql. Investigate way of reworking query cancellation flow

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Component/s: sql
• Labels: ignite-3
• Epic Link: Ignite 3 transactions
• Assignee: Evgeny Stanilovsky
• Reporter: Konstantin Orlov
• Created: 21/Oct/22 13:01
• Updated: 15/Feb/23 08:08
• Resolved: 15/Feb/23 08:08

Description

To prevent locks from being held indefinitely, we need to make sure that the root fragment of the query is the last to cancel.

Let's investigate how to achieve  the goal with rework the query cancellation flow in order to meet this requirement.

As result we should have one or few tickets to implementation, potentially it will required some documents with describe the current state and proposed changes to have final state.

Issue Links

• blocks: IGNITE-17952 Sql. Make SQL distributed again
• incorporates: IGNITE-18632 Barrier for locks after cleanup started