[
https://issues.apache.org/jira/browse/IGNITE-5434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aleksey Chetaev updated IGNITE-5434:
------------------------------------
Description:
Yardstick benchmarks:
* sql-query
* sql-query-join
* sql-query-put
broken in Ignite-5267 branch, in master all ok.
Exception:
<00:39:22><main><yardstick> Starting warmup.
Finishing main test [ts=1496795962893, date=Wed Jun 07 00:39:22 UTC 2017]
ERROR: Shutting down benchmark driver to unexpected exception.
Type '--help' for usage.
javax.cache.CacheException: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
"query"."Person" WHERE salary >= ? and salary <= ?
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:807)
at
org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.executeQuery(IgniteSqlQueryBenchmark.java:90)
at
org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.test(IgniteSqlQueryBenchmark.java:64)
at
org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
at java.lang.Thread.run(Thread.java:745)
Caused by: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
"query"."Person" WHERE salary >= ? and salary <= ?
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1291)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSql(IgniteH2Indexing.java:1196)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1947)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1945)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2283)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryDistributedSql(GridQueryProcessor.java:1944)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySql(GridQueryProcessor.java:1924)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:792)
... 4 more
Caused by: org.h2.jdbc.JdbcSQLException: Column "SALARY" not found; SQL
statement:
SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM "query"."Person" WHERE
salary >= ? and salary <= ? [42122-195]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at
org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
at org.h2.expression.Comparison.optimize(Comparison.java:178)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:130)
at org.h2.command.dml.Select.prepare(Select.java:842)
at org.h2.command.Parser.prepareCommand(Parser.java:262)
at org.h2.engine.Session.prepareLocal(Session.java:573)
at org.h2.engine.Session.prepareCommand(Session.java:514)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:397)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1271)
... 12 more
was:
Yardstick benchmarks:
* sql-query
* sql-query-join
* sql-query-put
broken in Ignite-5267 branch, in master all ok.
Exception:
<00:39:22><main><yardstick> Starting warmup.
Finishing main test [ts=1496795962893, date=Wed Jun 07 00:39:22 UTC 2017]
ERROR: Shutting down benchmark driver to unexpected exception.
Type '--help' for usage.
javax.cache.CacheException: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
"query"."Person" WHERE salary >= ? and salary <= ?
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:807)
at
org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.executeQuery(IgniteSqlQueryBenchmark.java:90)
at
org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.test(IgniteSqlQueryBenchmark.java:64)
at
org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
at java.lang.Thread.run(Thread.java:745)
Caused by: class
org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to parse
query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
"query"."Person" WHERE salary >= ? and salary <= ?
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1291)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSql(IgniteH2Indexing.java:1196)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1947)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1945)
at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2283)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryDistributedSql(GridQueryProcessor.java:1944)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.querySql(GridQueryProcessor.java:1924)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:792)
... 4 more
Caused by: org.h2.jdbc.JdbcSQLException: Column "SALARY" not found; SQL
statement:
SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM "query"."Person" WHERE
salary >= ? and salary <= ? [42122-195]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at
org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
at org.h2.expression.Comparison.optimize(Comparison.java:178)
at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:130)
at org.h2.command.dml.Select.prepare(Select.java:842)
at org.h2.command.Parser.prepareCommand(Parser.java:262)
at org.h2.engine.Session.prepareLocal(Session.java:573)
at org.h2.engine.Session.prepareCommand(Session.java:514)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:397)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1271)
... 12 more
> Yardstick sql benchmarks broken on Ignite-5267 branch
> -----------------------------------------------------
>
> Key: IGNITE-5434
> URL: https://issues.apache.org/jira/browse/IGNITE-5434
> Project: Ignite
> Issue Type: Bug
> Components: sql, yardstick
> Affects Versions: 2.1
> Reporter: Aleksey Chetaev
> Priority: Critical
>
> Yardstick benchmarks:
> * sql-query
> * sql-query-join
> * sql-query-put
> broken in Ignite-5267 branch, in master all ok.
> Exception:
> <00:39:22><main><yardstick> Starting warmup.
>
>
>
>
> Finishing main test [ts=1496795962893, date=Wed Jun 07 00:39:22 UTC 2017]
>
>
>
>
> ERROR: Shutting down benchmark driver to unexpected exception.
>
>
>
>
> Type '--help' for usage.
>
>
>
>
> javax.cache.CacheException: class
> org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
> parse query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
> "query"."Person" WHERE salary >= ? and salary <= ?
>
>
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:807)
>
>
>
> at
> org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.executeQuery(IgniteSqlQueryBenchmark.java:90)
>
>
>
> at
> org.apache.ignite.yardstick.cache.IgniteSqlQueryBenchmark.test(IgniteSqlQueryBenchmark.java:64)
>
>
>
> at
> org.yardstickframework.impl.BenchmarkRunner$2.run(BenchmarkRunner.java:178)
>
>
>
>
> at java.lang.Thread.run(Thread.java:745)
>
>
>
>
> Caused by: class
> org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
> parse query: SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM
> "query"."Person" WHERE salary >= ? and salary <= ?
>
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1291)
>
>
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSql(IgniteH2Indexing.java:1196)
>
>
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1947)
>
>
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor$8.applyx(GridQueryProcessor.java:1945)
>
>
>
> at
> org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
>
>
>
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2283)
>
>
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.queryDistributedSql(GridQueryProcessor.java:1944)
>
>
>
> at
> org.apache.ignite.internal.processors.query.GridQueryProcessor.querySql(GridQueryProcessor.java:1924)
>
>
>
> at
> org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:792)
>
>
>
> ... 4 more
>
>
>
>
> Caused by: org.h2.jdbc.JdbcSQLException: Column "SALARY" not found; SQL
> statement:
>
>
>
> SELECT "query"."Person"._KEY, "query"."Person"._VAL FROM "query"."Person"
> WHERE salary >= ? and salary <= ? [42122-195]
>
>
>
> at
> org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
>
>
>
>
> at org.h2.message.DbException.get(DbException.java:179)
>
>
>
>
> at org.h2.message.DbException.get(DbException.java:155)
>
>
>
>
> at
> org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)
>
>
>
>
> at org.h2.expression.Comparison.optimize(Comparison.java:178)
>
>
>
>
> at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:130)
>
>
>
>
> at org.h2.command.dml.Select.prepare(Select.java:842)
>
>
>
>
> at org.h2.command.Parser.prepareCommand(Parser.java:262)
>
>
>
>
> at org.h2.engine.Session.prepareLocal(Session.java:573)
>
>
>
>
> at org.h2.engine.Session.prepareCommand(Session.java:514)
>
>
>
>
> at
> org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
>
>
>
>
> at
> org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
>
>
>
>
> at
> org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
>
>
>
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:397)
>
>
>
> at
> org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryDistributedSqlFields(IgniteH2Indexing.java:1271)
>
>
>
> ... 12 more
>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
