Iurii Gerzhedovich created IGNITE-24483:
-------------------------------------------
Summary: Sql. Jdbc. Test
ItJdbcMultiStatementSelfTest.testAutoCommitFalseTxControlStatementsNotSupported
is flaky
Key: IGNITE-24483
URL: https://issues.apache.org/jira/browse/IGNITE-24483
Project: Ignite
Issue Type: Improvement
Reporter: Iurii Gerzhedovich
The test
ItJdbcMultiStatementSelfTest.testAutoCommitFalseTxControlStatementsNotSupported
is flaky
{code:java}
[2025-02-12T09:56:44,870][INFO
][%ijmsst_n_3344%sql-execution-pool-3][JdbcQueryEventHandlerImpl] Exception
while executing query.org.apache.ignite.sql.SqlException: The query was
cancelled while executing. at
org.apache.ignite.internal.sql.engine.util.SqlExceptionMapperProvider.lambda$mappers$0(SqlExceptionMapperProvider.java:50)
~[main/:?] at
org.apache.ignite.internal.lang.IgniteExceptionMapper.map(IgniteExceptionMapper.java:61)
~[main/:?] at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.map(IgniteExceptionMapperUtil.java:195)
~[main/:?] at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:125)
~[main/:?] at
org.apache.ignite.internal.lang.IgniteExceptionMapperUtil.mapToPublicException(IgniteExceptionMapperUtil.java:88)
~[main/:?] at
org.apache.ignite.internal.lang.SqlExceptionMapperUtil.mapToPublicSqlException(SqlExceptionMapperUtil.java:63)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.wrapIfNecessary(TxAwareAsyncCursor.java:160)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.handleError(TxAwareAsyncCursor.java:135)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.lambda$requestNextAsync$2(TxAwareAsyncCursor.java:68)
~[main/:?] at
java.base/java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:930)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture.uniHandleStage(CompletableFuture.java:946)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture.handle(CompletableFuture.java:2272)
~[?:?] at
org.apache.ignite.internal.sql.engine.exec.TxAwareAsyncCursor.requestNextAsync(TxAwareAsyncCursor.java:66)
~[main/:?] at
org.apache.ignite.internal.sql.engine.AsyncSqlCursorImpl.requestNextAsync(AsyncSqlCursorImpl.java:73)
~[main/:?] at
org.apache.ignite.client.handler.requests.jdbc.JdbcQueryCursor.requestNextAsync(JdbcQueryCursor.java:62)
~[main/:?] at
org.apache.ignite.client.handler.JdbcHandlerBase.createJdbcResult(JdbcHandlerBase.java:79)
~[main/:?] at
org.apache.ignite.client.handler.JdbcQueryEventHandlerImpl.lambda$queryAsync$1(JdbcQueryEventHandlerImpl.java:172)
~[main/:?] at
java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture.complete(CompletableFuture.java:2079)
~[?:?] at
org.apache.ignite.internal.sql.engine.exec.fsm.Program.advanceQuery(Program.java:148)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.fsm.Program.lambda$run$1(Program.java:117)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
~[main/:?] at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
[?:?] at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
[?:?] at java.base/java.lang.Thread.run(Thread.java:829) [?:?]Caused by:
org.apache.ignite.internal.sql.engine.QueryCancelledException: The query was
cancelled while executing. at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.closeRootNode(ExecutionServiceImpl.java:1293)
~[main/:?] at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl$DistributedQueryManager.lambda$close$15(ExecutionServiceImpl.java:1184)
~[main/:?] at
java.base/java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:1072)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture.postComplete(CompletableFuture.java:506)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run$$$capture(CompletableFuture.java:1705)
~[?:?] at
java.base/java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java)
~[?:?] ... 4 more[2025-02-12T09:56:44,871][INFO
][main][ItJdbcMultiStatementSelfTest] >>> Stopping test:
ItJdbcMultiStatementSelfTest#testAutoCommitFalseTxControlStatementsNotSupported,
displayName: testAutoCommitFalseTxControlStatementsNotSupported(), cost: 926ms.
java.sql.SQLException: The query was cancelled while executing.
at
org.apache.ignite.internal.jdbc.proto.IgniteQueryErrorCode.createJdbcSqlException(IgniteQueryErrorCode.java:57)
at
org.apache.ignite.internal.jdbc.JdbcStatement.execute0(JdbcStatement.java:161)
at
org.apache.ignite.internal.jdbc.JdbcStatement.execute(JdbcStatement.java:363)
at
org.apache.ignite.jdbc.ItJdbcMultiStatementSelfTest.testAutoCommitFalseTxControlStatementsNotSupported(ItJdbcMultiStatementSelfTest.java:426)
at java.base/java.lang.reflect.Method.invoke(Method.java:566) at
java.base/java.util.ArrayList.forEach(ArrayList.java:1541) at
java.base/java.util.ArrayList.forEach(ArrayList.java:1541) {code}
Rare fails on TC. Can be reproduced in local environment.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)