[IGNITE-23455] Sql. Fragment is sent to worker node, no response is obtained instead NodeLeft Is triggered

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0-beta1
• Fix Version/s: 3.1
• Component/s: sql
• Labels: ignite-3
• Epic Link: Processing sql on unstable topology
• Assignee: Unassigned
• Reporter: Evgeny Stanilovsky
• Created: 16/Oct/24 06:17
• Updated: 07/Jan/25 15:12

Description

Case: Fragment is sent to worker node but no response Is obtained and NodeLeft event is triggered. No information is available about fragment execution progress here, but we know that no data is passed from such a node.

1. In case of RO Tx only this fragment(s) can be remapped if no rows have been sent to the client, for example some kind of aggregate query (we have no such mechanisms for now) .
2. Implicit RW tx - tx need to be rolled back, execution must be restarted from the mapping phase.
3. Explicit RW tx - not recoverable. Need to close cursor with informative exception.