Maksim Timonin created IGNITE-23478:
---------------------------------------
Summary: Fix flaky test
SqlSystemViewsSelfTest.testQueryHistoryMetricsModes
Key: IGNITE-23478
URL: https://issues.apache.org/jira/browse/IGNITE-23478
Project: Ignite
Issue Type: Bug
Reporter: Maksim Timonin
Sometimes it fails with
{code:java}
[2024-10-17T15:30:09,203][WARN
][test-runner-#526%query.SqlSystemViewsSelfTest%][GridMapQueryExecutor] Failed
to execute local query. org.h2.message.DbException: Ошибка при вызове
пользовательской функции: "sleep_and_can_fail(): null" Exception calling
user-defined function: "sleep_and_can_fail(): null" [90105-197] at
org.h2.message.DbException.get(DbException.java:168) ~[h2-1.4.197.jar:1.4.197]
at org.h2.message.DbException.convertInvocation(DbException.java:324)
~[h2-1.4.197.jar:1.4.197] at
org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:468)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.JavaFunction.getValue(JavaFunction.java:38)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.Comparison.getValue(Comparison.java:239)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:93)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.Expression.getBooleanValue(Expression.java:178)
~[h2-1.4.197.jar:1.4.197] at
org.h2.command.dml.Select.isConditionMet(Select.java:312)
~[h2-1.4.197.jar:1.4.197] at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455)
~[h2-1.4.197.jar:1.4.197] at
org.h2.result.LazyResult.hasNext(LazyResult.java:79) ~[h2-1.4.197.jar:1.4.197]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[h2-1.4.197.jar:1.4.197]
at
org.apache.ignite.internal.processors.query.h2.twostep.MapQueryResult.fetchNextPage(MapQueryResult.java:199)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.prepareNextPage(GridMapQueryExecutor.java:969)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.lambda$onQueryRequest0$7988c368$1(GridMapQueryExecutor.java:525)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeWithResumableTimeTracking(IgniteH2Indexing.java:2304)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:524)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:281)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.onMessage(IgniteH2Indexing.java:1668)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:148)
~[classes/:?] at
org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:1793)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1199)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:447)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1447)
~[classes/:?] at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:102)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:91)
~[classes/:?] at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:124)
~[classes/:?] at
org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.lambda$testQueryHistoryMetricsModes$5(SqlSystemViewsSelfTest.java:528)
~[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:534)
[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:514)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:526)
[test-classes/:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:?] at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
[junit-4.12.jar:4.12] at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
[junit-4.12.jar:4.12] at
org.apache.ignite.testframework.junits.GridAbstractTest$6.run(GridAbstractTest.java:2499)
[test-classes/:?] at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: org.h2.jdbc.JdbcSQLException: Ошибка при вызове пользовательской
функции: "sleep_and_can_fail(): null" Exception calling user-defined function:
"sleep_and_can_fail(): null" [90105-197] at
org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
~[h2-1.4.197.jar:1.4.197] ... 42 more Caused by:
java.lang.IllegalArgumentException at
org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.can_fail(GridTestUtils.java:2642)
~[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.sleep_and_can_fail(GridTestUtils.java:2656)
~[test-classes/:?] at
jdk.internal.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) ~[?:?] at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at
org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:456)
~[h2-1.4.197.jar:1.4.197] ... 39 more
[2024-10-17T15:30:09,205][ERROR][test-runner-#526%query.SqlSystemViewsSelfTest%][GridMapQueryExecutor]
Failed to run map query on local node. org.h2.message.DbException: Ошибка при
вызове пользовательской функции: "sleep_and_can_fail(): null" Exception calling
user-defined function: "sleep_and_can_fail(): null" [90105-197] at
org.h2.message.DbException.get(DbException.java:168) ~[h2-1.4.197.jar:1.4.197]
at org.h2.message.DbException.convertInvocation(DbException.java:324)
~[h2-1.4.197.jar:1.4.197] at
org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:468)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.JavaFunction.getValue(JavaFunction.java:38)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.Comparison.getValue(Comparison.java:239)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:93)
~[h2-1.4.197.jar:1.4.197] at
org.h2.expression.Expression.getBooleanValue(Expression.java:178)
~[h2-1.4.197.jar:1.4.197] at
org.h2.command.dml.Select.isConditionMet(Select.java:312)
~[h2-1.4.197.jar:1.4.197] at
org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455)
~[h2-1.4.197.jar:1.4.197] at
org.h2.result.LazyResult.hasNext(LazyResult.java:79) ~[h2-1.4.197.jar:1.4.197]
at org.h2.result.LazyResult.next(LazyResult.java:59) ~[h2-1.4.197.jar:1.4.197]
at
org.apache.ignite.internal.processors.query.h2.twostep.MapQueryResult.fetchNextPage(MapQueryResult.java:199)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.prepareNextPage(GridMapQueryExecutor.java:969)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.lambda$onQueryRequest0$7988c368$1(GridMapQueryExecutor.java:525)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeWithResumableTimeTracking(IgniteH2Indexing.java:2304)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:524)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:281)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.onMessage(IgniteH2Indexing.java:1668)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:153)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:148)
~[classes/:?] at
org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:1793)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1199)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:447)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1447)
~[classes/:?] at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:102)
~[classes/:?] at
org.apache.ignite.internal.processors.query.h2.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:91)
~[classes/:?] at
org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:124)
~[classes/:?] at
org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.lambda$testQueryHistoryMetricsModes$5(SqlSystemViewsSelfTest.java:528)
~[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:534)
[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:514)
[test-classes/:?] at
org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:526)
[test-classes/:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:?] at
java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:?] at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
[junit-4.12.jar:4.12] at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
[junit-4.12.jar:4.12] at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
[junit-4.12.jar:4.12] at
org.apache.ignite.testframework.junits.GridAbstractTest$6.run(GridAbstractTest.java:2499)
[test-classes/:?] at java.base/java.lang.Thread.run(Thread.java:829) [?:?]
Caused by: org.h2.jdbc.JdbcSQLException: Ошибка при вызове пользовательской
функции: "sleep_and_can_fail(): null" Exception calling user-defined function:
"sleep_and_can_fail(): null" [90105-197] at
org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
~[h2-1.4.197.jar:1.4.197] ... 42 more Caused by:
java.lang.IllegalArgumentException at
org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.can_fail(GridTestUtils.java:2642)
~[test-classes/:?] at
org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.sleep_and_can_fail(GridTestUtils.java:2656)
~[test-classes/:?] at
jdk.internal.reflect.GeneratedMethodAccessor9.invoke(Unknown Source) ~[?:?] at
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
~[?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at
org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:456)
~[h2-1.4.197.jar:1.4.197] ... 39 more{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
