[ https://issues.apache.org/jira/browse/IGNITE-11557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yury Gerzhedovich updated IGNITE-11557: --------------------------------------- Ignite Flags: (was: Docs Required) > flaky test SqlSystemViewsSelfTest.testQueryHistoryMetricsModes > -------------------------------------------------------------- > > Key: IGNITE-11557 > URL: https://issues.apache.org/jira/browse/IGNITE-11557 > Project: Ignite > Issue Type: Bug > Components: sql > Affects Versions: 1.8 > Reporter: Yury Gerzhedovich > Assignee: Yury Gerzhedovich > Priority: Major > Time Spent: 10m > Remaining Estimate: 0h > > test failed with the following trace > _[2019-03-18 > 08:24:48,268][ERROR][test-runner-#443693%query.SqlSystemViewsSelfTest%][GridMapQueryExecutor] > Failed to execute local query. class > org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. > Exception calling user-defined function: "can_fail(): null"; SQL statement: > SELECT "STRING"._KEY, "STRING"._VAL FROM "STRING" WHERE _key=100 AND > sleep()>0 AND can_fail()=0 [90105-197] at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:846) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:923) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:588) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:388) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:203) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:163) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:161) > at > org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2057) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1234) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:757) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$3.iterator(IgniteH2Indexing.java:1015) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:102) > at > org.apache.ignite.internal.processors.cache.query.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:64) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:121) > at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.lambda$testQueryHistoryMetricsModes$0(SqlSystemViewsSelfTest.java:349) > at > org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:317) > at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:347) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > at > org.apache.ignite.testframework.junits.GridAbstractTest$7.run(GridAbstractTest.java:2107) > at java.lang.Thread.run(Thread.java:748) Caused by: > org.h2.jdbc.JdbcSQLException: Exception calling user-defined function: > "can_fail(): null"; SQL statement: SELECT "STRING"._KEY, "STRING"._VAL FROM > "STRING" WHERE _key=100 AND sleep()>0 AND can_fail()=0 [90105-197] at > org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at > org.h2.message.DbException.get(DbException.java:168) at > org.h2.message.DbException.convertInvocation(DbException.java:324) at > org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:468) at > org.h2.expression.JavaFunction.getValue(JavaFunction.java:38) at > org.h2.expression.Comparison.getValue(Comparison.java:239) at > org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:86) at > org.h2.expression.Expression.getBooleanValue(Expression.java:178) at > org.h2.command.dml.Select.isConditionMet(Select.java:312) at > org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455) > at org.h2.result.LazyResult.hasNext(LazyResult.java:79) at > org.h2.result.LazyResult.next(LazyResult.java:59) at > org.h2.command.dml.Select.queryFlat(Select.java:527) at > org.h2.command.dml.Select.queryWithoutCache(Select.java:633) at > org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) at > org.h2.command.dml.Query.query(Query.java:352) at > org.h2.command.dml.Query.query(Query.java:333) at > org.h2.command.CommandContainer.query(CommandContainer.java:114) at > org.h2.command.Command.executeQuery(Command.java:202) at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:839) > ... 29 more Caused by: java.lang.IllegalArgumentException at > org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.can_fail(GridTestUtils.java:2122) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:456) ... > 46 more [2019-03-18 > 08:24:48,278][ERROR][test-runner-#443693%query.SqlSystemViewsSelfTest%][GridMapQueryExecutor] > Failed to run map query on local node. class > org.apache.ignite.IgniteCheckedException: Failed to execute SQL query. > Exception calling user-defined function: "can_fail(): null"; SQL statement: > SELECT "STRING"._KEY, "STRING"._VAL FROM "STRING" WHERE _key=100 AND > sleep()>0 AND can_fail()=0 [90105-197] at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:846) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:923) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:588) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:388) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:203) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:163) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor$1.applyx(GridReduceQueryExecutor.java:161) > at > org.apache.ignite.internal.util.lang.IgniteInClosure2X.apply(IgniteInClosure2X.java:38) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.send(IgniteH2Indexing.java:2057) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.send(GridReduceQueryExecutor.java:1234) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:757) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$3.iterator(IgniteH2Indexing.java:1015) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.iter(QueryCursorImpl.java:102) > at > org.apache.ignite.internal.processors.cache.query.RegisteredQueryCursor.iter(RegisteredQueryCursor.java:64) > at > org.apache.ignite.internal.processors.cache.QueryCursorImpl.getAll(QueryCursorImpl.java:121) > at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.lambda$testQueryHistoryMetricsModes$0(SqlSystemViewsSelfTest.java:349) > at > org.apache.ignite.testframework.GridTestUtils.assertThrows(GridTestUtils.java:317) > at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:347) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > at > org.apache.ignite.testframework.junits.GridAbstractTest$7.run(GridAbstractTest.java:2107) > at java.lang.Thread.run(Thread.java:748) Caused by: > org.h2.jdbc.JdbcSQLException: Exception calling user-defined function: > "can_fail(): null"; SQL statement: SELECT "STRING"._KEY, "STRING"._VAL FROM > "STRING" WHERE _key=100 AND sleep()>0 AND can_fail()=0 [90105-197] at > org.h2.message.DbException.getJdbcSQLException(DbException.java:357) at > org.h2.message.DbException.get(DbException.java:168) at > org.h2.message.DbException.convertInvocation(DbException.java:324) at > org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:468) at > org.h2.expression.JavaFunction.getValue(JavaFunction.java:38) at > org.h2.expression.Comparison.getValue(Comparison.java:239) at > org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:86) at > org.h2.expression.Expression.getBooleanValue(Expression.java:178) at > org.h2.command.dml.Select.isConditionMet(Select.java:312) at > org.h2.command.dml.Select$LazyResultQueryFlat.fetchNextRow(Select.java:1455) > at org.h2.result.LazyResult.hasNext(LazyResult.java:79) at > org.h2.result.LazyResult.next(LazyResult.java:59) at > org.h2.command.dml.Select.queryFlat(Select.java:527) at > org.h2.command.dml.Select.queryWithoutCache(Select.java:633) at > org.h2.command.dml.Query.queryWithoutCacheLazyCheck(Query.java:114) at > org.h2.command.dml.Query.query(Query.java:352) at > org.h2.command.dml.Query.query(Query.java:333) at > org.h2.command.CommandContainer.query(CommandContainer.java:114) at > org.h2.command.Command.executeQuery(Command.java:202) at > org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:114) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:839) > ... 29 more Caused by: java.lang.IllegalArgumentException at > org.apache.ignite.testframework.GridTestUtils$SqlTestFunctions.can_fail(GridTestUtils.java:2122) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.h2.engine.FunctionAlias$JavaMethod.getValue(FunctionAlias.java:456) ... > 46 more [2019-03-18 08:24:48,293][ERROR][main][root] Test failed. > java.lang.AssertionError at org.junit.Assert.fail(Assert.java:86) at > org.junit.Assert.assertTrue(Assert.java:41) at > org.junit.Assert.assertTrue(Assert.java:52) at > org.apache.ignite.testframework.junits.JUnitAssertAware.assertTrue(JUnitAssertAware.java:34) > at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:393) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at > org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) > at > org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) > at > org.apache.ignite.testframework.junits.GridAbstractTest$7.run(GridAbstractTest.java:2107) > at java.lang.Thread.run(Thread.java:748)_ > ++[11:38:11]++_[org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes]_ > _java.lang.AssertionError_ > ++[11:38:11]++_[org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes]_ > _java.lang.AssertionError at > org.apache.ignite.internal.processors.query.SqlSystemViewsSelfTest.testQueryHistoryMetricsModes(SqlSystemViewsSelfTest.java:393)_ -- This message was sent by Atlassian JIRA (v7.6.3#76005)