Ivan Artiukhov created IGNITE-20880: ---------------------------------------
Summary: Some TPC-H queries hang Key: IGNITE-20880 URL: https://issues.apache.org/jira/browse/IGNITE-20880 Project: Ignite Issue Type: Bug Components: sql Reporter: Ivan Artiukhov Attachments: logs.zip Apache Ignite 3, rev. 8d6264af0edb9752e2239f9b686abe5580056862 (Nov 16 2023) Benchmark: [https://github.com/cmu-db/benchbase/tree/main/src/main/java/com/oltpbenchmark/benchmarks/tpch] h1. Setup * 1 Ignite 3 server node, raft.fsync = false * TPC-H with scale factor = 0.1 h1. Steps # Start an Ignite 3 node # Run benchbase with {{-s 1 --create=true --load=true --execute=false}} to preload data # Observe via the benchbase log that the data was successfully loaded # Run {{benchbase with -s 1 --create=false --load=false --execute=true}} to run the benchmark h1. Expected result The benchmark finishes after warmup + duration time h1. Actual result The benchmark hangs on Q21 query: {noformat} SELECT cntrycode, COUNT(*) AS numcust, SUM(c_acctbal) AS totacctbal FROM ( SELECT SUBSTRING(c_phone FROM 1 FOR 2) AS cntrycode, c_acctbal FROM customer WHERE SUBSTRING(c_phone FROM 1 FOR 2) IN (?, ?, ?, ?, ?, ?, ?) AND c_acctbal > ( SELECT AVG(c_acctbal) FROM customer WHERE c_acctbal > 0.00 AND SUBSTRING(c_phone FROM 1 FOR 2) IN (?, ?, ?, ?, ?, ?, ?) ) AND NOT EXISTS ( SELECT * FROM orders WHERE o_custkey = c_custkey ) ) AS custsale GROUP BY cntrycode ORDER BY cntrycode {noformat} Hung client thread: {noformat} "TPCHWorker<000>" #61 prio=5 os_prio=0 cpu=13.83ms elapsed=3064.60s allocated=2668K defined_classes=46 tid=0x00007f9c4d2d73b0 nid=0x2703 waiting on condition [0x00007f9b662fd000] java.lang.Thread.State: WAITING (parking) at jdk.internal.misc.Unsafe.park(java.base@17.0.7/Native Method) - parking to wait for <0x00000006347cb998> (a java.util.concurrent.CompletableFuture$Signaller) at java.util.concurrent.locks.LockSupport.park(java.base@17.0.7/LockSupport.java:211) at java.util.concurrent.CompletableFuture$Signaller.block(java.base@17.0.7/CompletableFuture.java:1864) at java.util.concurrent.ForkJoinPool.unmanagedBlock(java.base@17.0.7/ForkJoinPool.java:3463) at java.util.concurrent.ForkJoinPool.managedBlock(java.base@17.0.7/ForkJoinPool.java:3434) at java.util.concurrent.CompletableFuture.waitingGet(java.base@17.0.7/CompletableFuture.java:1898) at java.util.concurrent.CompletableFuture.get(java.base@17.0.7/CompletableFuture.java:2072) at org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:139) at org.apache.ignite.internal.jdbc.JdbcPreparedStatement.executeWithArguments(JdbcPreparedStatement.java:765) at org.apache.ignite.internal.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:116) at com.oltpbenchmark.benchmarks.tpch.procedures.GenericQuery.run(GenericQuery.java:39) at com.oltpbenchmark.benchmarks.tpch.TPCHWorker.executeWork(TPCHWorker.java:44) at com.oltpbenchmark.api.Worker.doWork(Worker.java:416) at com.oltpbenchmark.api.Worker.run(Worker.java:282) at java.lang.Thread.run(java.base@17.0.7/Thread.java:833){noformat} Logs, configs: [^logs.zip] -- This message was sent by Atlassian Jira (v8.20.10#820010)