Iurii Gerzhedovich created IGNITE-25232:
-------------------------------------------
Summary: Flaky ItSqlLogicTest test_incorrect_timestamp_ltz.test on
JDK 17/21
Key: IGNITE-25232
URL: https://issues.apache.org/jira/browse/IGNITE-25232
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Iurii Gerzhedovich
The test
org.apache.ignite.internal.sql.sqllogic.ItSqlLogicTest.sql(types/timestamp/test_incorrect_timestamp_ltz.test)
on JDK 17/21 has a high flaky rate.
It need to figure out the reasons and fix them.
{code:java}
java.lang.AssertionError: Not expected result at:
(test_incorrect_timestamp_ltz.test:18).
Statement: INSERT INTO timestamp_t VALUES ('blabla'::TIMESTAMP WITH LOCAL
TIME ZONE).
Loop variables: {}
Expected: begin 0, end -1, length 19
Actual:
org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at
java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
at
org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:916)
at
org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:850)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:652)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:785)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:630)
at
org.apache.ignite.internal.util.IgniteUtils.getInterruptibly(IgniteUtils.java:822)
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.sync(IgniteSqlImpl.java:675)
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.execute(IgniteSqlImpl.java:236)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.lambda$execute$2(PublicApiThreadingIgniteSql.java:81)
at
org.apache.ignite.internal.thread.PublicApiThreading.executeWithRole(PublicApiThreading.java:144)
at
org.apache.ignite.internal.thread.PublicApiThreading.execUserSyncOperation(PublicApiThreading.java:102)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.execute(PublicApiThreadingIgniteSql.java:81)
at org.apache.ignite.sql.IgniteSql.execute(IgniteSql.java:90)
at
org.apache.ignite.internal.sql.sqllogic.ScriptContext.executeQuery(ScriptContext.java:97)
at
org.apache.ignite.internal.sql.sqllogic.Statement.lambda$execute$0(Statement.java:140)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:53)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:45)
at org.junit.jupiter.api.Assertions.assertThrows(Assertions.java:3180)
at
org.apache.ignite.internal.sql.sqllogic.Statement.execute(Statement.java:138)
at
org.apache.ignite.internal.sql.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70)
at
org.junit.jupiter.api.AssertTimeoutPreemptively.lambda$assertTimeoutPreemptively$0(AssertTimeoutPreemptively.java:48)
at
org.junit.jupiter.api.AssertTimeoutPreemptively.lambda$submitTask$3(AssertTimeoutPreemptively.java:95)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.util.concurrent.ExecutionException:
org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at
java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
at
java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
at
org.apache.ignite.internal.util.IgniteUtils.getInterruptibly(IgniteUtils.java:820)
... 20 more
Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at SC.get(Unknown Source)
at
org.apache.ignite.internal.sql.engine.exec.exp.RowProviderImplementor$SqlRowProviderImpl.buildRow(RowProviderImplementor.java:185)
at
org.apache.ignite.internal.sql.engine.exec.exp.RowProviderImplementor$AbstractRowProvider.get(RowProviderImplementor.java:230)
at
org.apache.ignite.internal.sql.engine.prepare.KeyValueModifyPlan$InsertExecution.perform(KeyValueModifyPlan.java:165)
at
org.apache.ignite.internal.sql.engine.prepare.KeyValueModifyPlan.execute(KeyValueModifyPlan.java:147)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.executeExecutablePlan(ExecutionServiceImpl.java:468)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.executePlan(ExecutionServiceImpl.java:396)
at
org.apache.ignite.internal.sql.engine.exec.fsm.QueryExecutor.executePlan(QueryExecutor.java:538)
at
org.apache.ignite.internal.sql.engine.exec.fsm.CursorInitializationPhaseHandler.handle(CursorInitializationPhaseHandler.java:47)
at
org.apache.ignite.internal.sql.engine.exec.fsm.ExecutionPhase.evaluate(ExecutionPhase.java:48)
at org.apache.ignite.internal.sql.engine.exec.fsm.Program.run(Program.java:73)
at
org.apache.ignite.internal.sql.engine.exec.fsm.Program.lambda$run$1(Program.java:118)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
... 3 more
Caused by: java.lang.StringIndexOutOfBoundsException: Range [0, -1) out of
bounds for length 19
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:55)
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:52)
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:213)
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:210)
at
java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:98)
at
java.base/jdk.internal.util.Preconditions.outOfBoundsCheckFromToIndex(Preconditions.java:112)
at
java.base/jdk.internal.util.Preconditions.checkFromToIndex(Preconditions.java:349)
at java.base/java.lang.String.checkBoundsBeginEnd(String.java:4861)
at java.base/java.lang.String.substring(String.java:2830)
at
org.apache.calcite.util.TimestampWithTimeZoneString.<init>(TimestampWithTimeZoneString.java:54)
at
org.apache.calcite.runtime.SqlFunctions.toTimestampWithLocalTimeZone(SqlFunctions.java:5270)
... 16 more
Expected: a string containing "begin 0, end -1, length 19"
but: was "Range [0, -1) out of bounds for length 19"
java.lang.AssertionError: Not expected result at:
(test_incorrect_timestamp_ltz.test:18).
Statement: INSERT INTO timestamp_t VALUES ('blabla'::TIMESTAMP WITH LOCAL
TIME ZONE).
Loop variables: {}
Expected: begin 0, end -1, length 19
Actual:
org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at
java.base/java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:733)
at
org.apache.ignite.internal.util.ExceptionUtils$1.copy(ExceptionUtils.java:916)
at
org.apache.ignite.internal.util.ExceptionUtils$ExceptionFactory.createCopy(ExceptionUtils.java:850)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:652)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCauseInternal(ExceptionUtils.java:785)
at
org.apache.ignite.internal.util.ExceptionUtils.copyExceptionWithCause(ExceptionUtils.java:630)
at
org.apache.ignite.internal.util.IgniteUtils.getInterruptibly(IgniteUtils.java:822)
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.sync(IgniteSqlImpl.java:675)
at
org.apache.ignite.internal.sql.api.IgniteSqlImpl.execute(IgniteSqlImpl.java:236)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.lambda$execute$2(PublicApiThreadingIgniteSql.java:81)
at
org.apache.ignite.internal.thread.PublicApiThreading.executeWithRole(PublicApiThreading.java:144)
at
org.apache.ignite.internal.thread.PublicApiThreading.execUserSyncOperation(PublicApiThreading.java:102)
at
org.apache.ignite.internal.sql.api.PublicApiThreadingIgniteSql.execute(PublicApiThreadingIgniteSql.java:81)
at org.apache.ignite.sql.IgniteSql.execute(IgniteSql.java:90)
at
org.apache.ignite.internal.sql.sqllogic.ScriptContext.executeQuery(ScriptContext.java:97)
at
org.apache.ignite.internal.sql.sqllogic.Statement.lambda$execute$0(Statement.java:140)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:53)
at org.junit.jupiter.api.AssertThrows.assertThrows(AssertThrows.java:45)
at org.junit.jupiter.api.Assertions.assertThrows(Assertions.java:3180)
at
org.apache.ignite.internal.sql.sqllogic.Statement.execute(Statement.java:138)
at
org.apache.ignite.internal.sql.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70)
at
org.junit.jupiter.api.AssertTimeoutPreemptively.lambda$assertTimeoutPreemptively$0(AssertTimeoutPreemptively.java:48)
at
org.junit.jupiter.api.AssertTimeoutPreemptively.lambda$submitTask$3(AssertTimeoutPreemptively.java:95)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.util.concurrent.ExecutionException:
org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at
java.base/java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:396)
at
java.base/java.util.concurrent.CompletableFuture.get(CompletableFuture.java:2073)
at
org.apache.ignite.internal.util.IgniteUtils.getInterruptibly(IgniteUtils.java:820)
... 20 more
Caused by: org.apache.ignite.sql.SqlException: IGN-SQL-7
TraceId:8760bf37-9870-4868-b21a-471761f66ef0 Range [0, -1) out of bounds for
length 19
at SC.get(Unknown Source)
at
org.apache.ignite.internal.sql.engine.exec.exp.RowProviderImplementor$SqlRowProviderImpl.buildRow(RowProviderImplementor.java:185)
at
org.apache.ignite.internal.sql.engine.exec.exp.RowProviderImplementor$AbstractRowProvider.get(RowProviderImplementor.java:230)
at
org.apache.ignite.internal.sql.engine.prepare.KeyValueModifyPlan$InsertExecution.perform(KeyValueModifyPlan.java:165)
at
org.apache.ignite.internal.sql.engine.prepare.KeyValueModifyPlan.execute(KeyValueModifyPlan.java:147)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.executeExecutablePlan(ExecutionServiceImpl.java:468)
at
org.apache.ignite.internal.sql.engine.exec.ExecutionServiceImpl.executePlan(ExecutionServiceImpl.java:396)
at
org.apache.ignite.internal.sql.engine.exec.fsm.QueryExecutor.executePlan(QueryExecutor.java:538)
at
org.apache.ignite.internal.sql.engine.exec.fsm.CursorInitializationPhaseHandler.handle(CursorInitializationPhaseHandler.java:47)
at
org.apache.ignite.internal.sql.engine.exec.fsm.ExecutionPhase.evaluate(ExecutionPhase.java:48)
at org.apache.ignite.internal.sql.engine.exec.fsm.Program.run(Program.java:73)
at
org.apache.ignite.internal.sql.engine.exec.fsm.Program.lambda$run$1(Program.java:118)
at
org.apache.ignite.internal.sql.engine.exec.QueryTaskExecutorImpl.lambda$execute$0(QueryTaskExecutorImpl.java:86)
... 3 more
Caused by: java.lang.StringIndexOutOfBoundsException: Range [0, -1) out of
bounds for length 19
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:55)
at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:52)
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:213)
at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:210)
at
java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:98)
at
java.base/jdk.internal.util.Preconditions.outOfBoundsCheckFromToIndex(Preconditions.java:112)
at
java.base/jdk.internal.util.Preconditions.checkFromToIndex(Preconditions.java:349)
at java.base/java.lang.String.checkBoundsBeginEnd(String.java:4861)
at java.base/java.lang.String.substring(String.java:2830)
at
org.apache.calcite.util.TimestampWithTimeZoneString.<init>(TimestampWithTimeZoneString.java:54)
at
org.apache.calcite.runtime.SqlFunctions.toTimestampWithLocalTimeZone(SqlFunctions.java:5270)
... 16 more
Expected: a string containing "begin 0, end -1, length 19"
but: was "Range [0, -1) out of bounds for length 19"
at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:20)
at
org.apache.ignite.internal.sql.sqllogic.Statement.execute(Statement.java:150)
at
org.apache.ignite.internal.sql.sqllogic.SqlScriptRunner.run(SqlScriptRunner.java:70)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
