[
https://issues.apache.org/jira/browse/IGNITE-25232?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-25232:
----------------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> 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
> Assignee: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-3
>
> 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)
