[IGNITE-18328] SQL query may hangs forever.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0
• Labels: ignite-3
• Epic Link: Grid start-stop scenarios
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Andrey Mashenkov
• Created: 02/Dec/22 13:48
• Updated: 04/Sep/24 16:19

Description

Scenario

• Start gird [CGM, MetaStorage, DataNode]
• Stop MetaStorage node
• Run "Create table" sql query.
• Future returns cursor, but the cursor can't retrieve data from it.
• Observing in thread dump: Reading next batch (requestNextAsync) future can't be failed as ForkJoinPool thread blocked with bulk of tasks:

at j.u.c.CompletableFuture.get(CompletableFuture.java:1998)
at o.a.i.i.m.client.CursorImpl.close(CursorImpl.java:90)
at o.a.i.i.m.client.MetaStorageServiceImpl$WatchProcessor.lambda$stopWatch$1(MetaStorageServiceImpl.java:580)

See reproducer in IGNITE-18171 PR in ignite-runner module: org.apache.ignite.internal.cluster.ItNodeRestartTest#testCreateTable

Issue Links

• blocks: IGNITE-18326 SQL query may forget to finish implicit TX.
• is caused by: IGNITE-18171 Descibe nodes start/stop scenarios
• relates to: IGNITE-15389 org.apache.ignite.internal.metastorage.client.CursorImpl has potential deadlock inside