ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-5434) Yardstick sql benchmarks broken on Ignite-5267 branch
Date Wed, 07 Jun 2017 12:58:18 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-5434?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Vladimir Ozerov updated IGNITE-5434:
------------------------------------
    Fix Version/s: 2.1

> 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
>              Labels: important
>             Fix For: 2.1
>
>
> 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)

Mime
View raw message