ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Kozlov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-9162) Query returns ICE: org.h2.table.TableView cannot be cast
Date Thu, 02 Aug 2018 10:00:00 GMT
Sergey Kozlov created IGNITE-9162:
-------------------------------------

             Summary: Query returns ICE: org.h2.table.TableView cannot be cast
                 Key: IGNITE-9162
                 URL: https://issues.apache.org/jira/browse/IGNITE-9162
             Project: Ignite
          Issue Type: Bug
          Components: sql
    Affects Versions: 2.4
            Reporter: Sergey Kozlov


1. Start 1 Ignite node {{bin/ignite.sh server.xml -v -J-DCONSISTENT_ID=node1}}
2. Start sqlline {{bin/sqlline.sh -u jdbc:ignite:thin://127.0.0.1/?distributedJoins=true}}
3. Execute statements:

{noformat}
0: jdbc:ignite:thin://127.0.0.1/> CREATE TABLE t1 ( id INT NOT NULL, int_col1 INT NOT NULL,
PRIMARY KEY (id)) WITH "TEMPLATE=partitioned";
No rows affected (0,151 seconds)
0: jdbc:ignite:thin://127.0.0.1/> INSERT INTO t1 (id,int_col1) VALUES (1,0),(2,0),(3,0),(4,0);
4 rows affected (0,052 seconds)
0: jdbc:ignite:thin://127.0.0.1/> SELECT * FROM ( SELECT * FROM t1 WHERE int_col1  >
0 ORDER BY id ) WHERE int_col1  = 1
 ORDER BY id;
Error: javax.cache.CacheException: class org.apache.ignite.IgniteCheckedException: org.h2.table.TableView
cannot be cast
 to org.apache.ignite.internal.processors.query.h2.opt.GridH2Table (state=50000,code=0)
0: jdbc:ignite:thin://127.0.0.1/>
{noformat}

Node log:
{noformat}
[12:39:38,162][SEVERE][client-connector-#50][JdbcRequestHandler] Failed to execute SQL query
[reqId=0, req=JdbcQueryExecuteRequest [schemaName=PUBLIC, pageSize=1024, maxRows=0, sqlQry=SELECT
* FROM ( SELECT * FROM t1 WHERE int_col1  > 0 ORDER BY id ) WHERE int_col1  = 1 ORDER BY
id, args=[], stmtType=ANY_STATEMENT_TYPE]]
javax.cache.CacheException: class org.apache.ignite.IgniteCheckedException: org.h2.table.TableView
cannot be cast to org.apache.ignite.internal.processors.query.h2.opt.GridH2Table
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2047)
	at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.executeQuery(JdbcRequestHandler.java:456)
	at org.apache.ignite.internal.processors.odbc.jdbc.JdbcRequestHandler.handle(JdbcRequestHandler.java:203)
	at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:160)
	at org.apache.ignite.internal.processors.odbc.ClientListenerNioListener.onMessage(ClientListenerNioListener.java:44)
	at org.apache.ignite.internal.util.nio.GridNioFilterChain$TailFilter.onMessageReceived(GridNioFilterChain.java:279)
	at org.apache.ignite.internal.util.nio.GridNioFilterAdapter.proceedMessageReceived(GridNioFilterAdapter.java:109)
	at org.apache.ignite.internal.util.nio.GridNioAsyncNotifyFilter$3.body(GridNioAsyncNotifyFilter.java:97)
	at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
	at org.apache.ignite.internal.util.worker.GridWorkerPool$1.run(GridWorkerPool.java:70)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: class org.apache.ignite.IgniteCheckedException: org.h2.table.TableView cannot be
cast to org.apache.ignite.internal.processors.query.h2.opt.GridH2Table
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2601)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2044)
	... 12 more
Caused by: java.lang.ClassCastException: org.h2.table.TableView cannot be cast to org.apache.ignite.internal.processors.query.h2.opt.GridH2Table
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.extractPartitionFromEquality(GridSqlQuerySplitter.java:2336)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.extractPartition(GridSqlQuerySplitter.java:2268)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.derivePartitionsFromQuery(GridSqlQuerySplitter.java:2250)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitSelect(GridSqlQuerySplitter.java:1539)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitQueryModel(GridSqlQuerySplitter.java:1227)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.splitQuery(GridSqlQuerySplitter.java:306)
	at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split(GridSqlQuerySplitter.java:224)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.split(IgniteH2Indexing.java:1936)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.parseAndSplit(IgniteH2Indexing.java:1898)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1650)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2035)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2030)
	at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2578)
	... 13 more

{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message