[IGNITE-19088] Sql. Investigate why severals tests ItTableRaftSnapshotsTest hang/fail.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0-beta2
• Component/s: sql
• Labels: ignite-3
• Assignee: Maksim Zhuravkov
• Reporter: Maksim Zhuravkov
• Created: 22/Mar/23 07:30
• Updated: 03/May/23 08:32
• Resolved: 31/Mar/23 12:42

Description

After enabling distrubuted execution of DML queries in https://issues.apache.org/jira/browse/IGNITE-18225, performing DML in several test cases in ItTableRaftSnapshotsTest fail to terminate.
Internally the code hangs indefinitely at

some_node-sql-execution-pool-0

 java.lang.Thread.State: WAITING (parking)
	at jdk.internal.misc.Unsafe.park(java.base@11.0.14.1/Native Method)
	- parking to wait for  <0x00000005daab1fe8> (a java.util.concurrent.CompletableFuture$Signaller)
	at java.util.concurrent.locks.LockSupport.park(java.base@11.0.14.1/LockSupport.java:194)
	at java.util.concurrent.CompletableFuture$Signaller.block(java.base@11.0.14.1/CompletableFuture.java:1796)
	at java.util.concurrent.ForkJoinPool.managedBlock(java.base@11.0.14.1/ForkJoinPool.java:3128)
	at java.util.concurrent.CompletableFuture.waitingGet(java.base@11.0.14.1/CompletableFuture.java:1823)
	at java.util.concurrent.CompletableFuture.join(java.base@11.0.14.1/CompletableFuture.java:2043)
	at org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.send(MessageServiceImpl.java:102)
	at org.apache.ignite.internal.sql.engine.exec.ExchangeServiceImpl.request(ExchangeServiceImpl.java:106)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox.requestBatches(Inbox.java:341)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox.lambda$new$0(Inbox.java:89)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox$$Lambda$2832/0x0000000800e16040.request(Unknown Source)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox$RemoteSource.requestNextBatchIfNeeded(Inbox.java:555)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox.pushUnordered(Inbox.java:331)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox.push(Inbox.java:194)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox.doPush(Inbox.java:175)
	at org.apache.ignite.internal.sql.engine.exec.rel.Inbox$$Lambda$2835/0x0000000800e34c40.run(Unknown Source)
	at

some_node-sql-execution-pool-1:

java.lang.Thread.State: WAITING (parking)
	at jdk.internal.misc.Unsafe.park(java.base@11.0.14.1/Native Method)
	- parking to wait for  <0x00000005daabbeb0> (a java.util.concurrent.CompletableFuture$Signaller)
	at java.util.concurrent.locks.LockSupport.park(java.base@11.0.14.1/LockSupport.java:194)
	at java.util.concurrent.CompletableFuture$Signaller.block(java.base@11.0.14.1/CompletableFuture.java:1796)
	at java.util.concurrent.ForkJoinPool.managedBlock(java.base@11.0.14.1/ForkJoinPool.java:3128)
	at java.util.concurrent.CompletableFuture.waitingGet(java.base@11.0.14.1/CompletableFuture.java:1823)
	at java.util.concurrent.CompletableFuture.join(java.base@11.0.14.1/CompletableFuture.java:2043)
	at org.apache.ignite.internal.sql.engine.message.MessageServiceImpl.send(MessageServiceImpl.java:102)
	at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.sendFragment(ExecutionServiceImpl.java:495)
	at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.lambda$execute$7(ExecutionServiceImpl.java:708)
	at org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager$$Lambda$2790/0x000000080096a040.run(Unknown Source)
	at org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:80)
	at org.a

Issue Links

• is related to: IGNITE-19126 Make ItTableRaftSnapshotsTest less invasive
• is related to: IGNITE-18225 Sql. Pushdown MODIFY to data node
• relates to: IGNITE-19121 Future returned by a dropped message send is never completed
• relates to: IGNITE-18493 Remove test-only code from DefaultMessagingService
• links to: GitHub Pull Request #1853
• links to: https://github.com/apache/ignite-3/pull/1853