You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/10/12 14:27:00 UTC

[jira] [Commented] (IGNITE-9557) Assert exception on explain of DELETE query.

    [ https://issues.apache.org/jira/browse/IGNITE-9557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16647963#comment-16647963 ] 

ASF GitHub Bot commented on IGNITE-9557:
----------------------------------------

GitHub user pavel-kuznetsov opened a pull request:

    https://github.com/apache/ignite/pull/4976

    IGNITE-9557: Assert in case of explains of updates operations.

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-9557

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/ignite/pull/4976.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #4976
    
----
commit c58911894be0581b799cc7012005d8930d49de06
Author: Pavel Kuznetsov <pa...@...>
Date:   2018-10-11T12:13:49Z

    ignite-9557: tests for EXPLAIN update queries.

commit 74d30f9241ddc3a424a3fd589c8c32bf1d2448cb
Author: Pavel Kuznetsov <pa...@...>
Date:   2018-10-12T14:25:01Z

    ignite-9557: Throw exception on EXPLAIN of update query.
    
    Added assertion that query is not a EXPLAIN of update operation: INSERT, UPDATE, DELETE or MERGE. In this case we throw IgniteSqlException with code of unsupported operation.

----


> Assert exception on explain of DELETE query.
> --------------------------------------------
>
>                 Key: IGNITE-9557
>                 URL: https://issues.apache.org/jira/browse/IGNITE-9557
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Vasiliy Sisko
>            Assignee: Pavel Kuznetsov
>            Priority: Major
>
> On execution of an query:
> {code:java}
> explain delete from "schema".type {code}
> received exception:
> {code:java}
> java.lang.AssertionError
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.parseAndSplit(IgniteH2Indexing.java:2309)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2105)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2139)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2134)
>     at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2711)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2148)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2083)
>     at org.apache.ignite.internal.visor.query.VisorQueryTask$VisorQueryJob.run(VisorQueryTask.java:94)
>     at org.apache.ignite.internal.visor.query.VisorQueryTask$VisorQueryJob.run(VisorQueryTask.java:59)
>     at org.apache.ignite.internal.visor.VisorJob.execute(VisorJob.java:69)
>     at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568)
>     at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6765)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(GridTaskWorker.java:1420)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.processMappedJobs(GridTaskWorker.java:666)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.body(GridTaskWorker.java:538)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(GridTaskProcessor.java:764)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:509)
>     at org.apache.ignite.internal.IgniteComputeImpl.executeAsync0(IgniteComputeImpl.java:488)
>     at org.apache.ignite.internal.IgniteComputeImpl.executeAsync(IgniteComputeImpl.java:468)
>     at org.apache.ignite.internal.visor.compute.VisorGatewayTask$VisorGatewayJob.execute(VisorGatewayTask.java:462)
>     at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568)
>     at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6765)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(GridTaskWorker.java:1420)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.processMappedJobs(GridTaskWorker.java:666)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.body(GridTaskWorker.java:538)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(GridTaskProcessor.java:764)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:509)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:489)
>     at org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsyncUnsafe(GridTaskCommandHandler.java:227)
>     at org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsync(GridTaskCommandHandler.java:163)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:318)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:99)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:174)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>     at java.lang.Thread.run(Thread.java:748){code}
> When a node is run without -ea flag an error is received:
> {code:java}
> javax.cache.CacheException: class org.apache.ignite.IgniteCheckedException: org.apache.ignite.internal.processors.query.h2.sql.GridSqlDelete cannot be cast to org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuery
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2151)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2083)
>     at org.apache.ignite.internal.visor.query.VisorQueryTask$VisorQueryJob.run(VisorQueryTask.java:94)
>     at org.apache.ignite.internal.visor.query.VisorQueryTask$VisorQueryJob.run(VisorQueryTask.java:59)
>     at org.apache.ignite.internal.visor.VisorJob.execute(VisorJob.java:69)
>     at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568)
>     at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6765)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(GridTaskWorker.java:1420)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.processMappedJobs(GridTaskWorker.java:666)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.body(GridTaskWorker.java:538)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(GridTaskProcessor.java:764)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:509)
>     at org.apache.ignite.internal.IgniteComputeImpl.executeAsync0(IgniteComputeImpl.java:488)
>     at org.apache.ignite.internal.IgniteComputeImpl.executeAsync(IgniteComputeImpl.java:468)
>     at org.apache.ignite.internal.visor.compute.VisorGatewayTask$VisorGatewayJob.execute(VisorGatewayTask.java:462)
>     at org.apache.ignite.internal.processors.job.GridJobWorker$2.call(GridJobWorker.java:568)
>     at org.apache.ignite.internal.util.IgniteUtils.wrapThreadLoader(IgniteUtils.java:6765)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.execute0(GridJobWorker.java:562)
>     at org.apache.ignite.internal.processors.job.GridJobWorker.body(GridJobWorker.java:491)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.job.GridJobProcessor.processJobExecuteRequest(GridJobProcessor.java:1125)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.sendRequest(GridTaskWorker.java:1420)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.processMappedJobs(GridTaskWorker.java:666)
>     at org.apache.ignite.internal.processors.task.GridTaskWorker.body(GridTaskWorker.java:538)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.startTask(GridTaskProcessor.java:764)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:509)
>     at org.apache.ignite.internal.processors.task.GridTaskProcessor.execute(GridTaskProcessor.java:489)
>     at org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsyncUnsafe(GridTaskCommandHandler.java:227)
>     at org.apache.ignite.internal.processors.rest.handlers.task.GridTaskCommandHandler.handleAsync(GridTaskCommandHandler.java:163)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor.handleRequest(GridRestProcessor.java:318)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor.access$100(GridRestProcessor.java:99)
>     at org.apache.ignite.internal.processors.rest.GridRestProcessor$2.body(GridRestProcessor.java:174)
>     at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:110)
>     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>     at java.lang.Thread.run(Thread.java:748)
> Caused by: class org.apache.ignite.IgniteCheckedException: org.apache.ignite.internal.processors.query.h2.sql.GridSqlDelete cannot be cast to org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuery
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2734)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.querySqlFields(GridQueryProcessor.java:2148)
>     ... 41 more
> Caused by: java.lang.ClassCastException: org.apache.ignite.internal.processors.query.h2.sql.GridSqlDelete cannot be cast to org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuery
>     at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.parse(GridSqlQuerySplitter.java:1654)
>     at org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split(GridSqlQuerySplitter.java:199)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.split(IgniteH2Indexing.java:2406)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.parseAndSplit(IgniteH2Indexing.java:2366)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:2105)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2139)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2134)
>     at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
>     at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:2711)
>     ... 42 more
> {code}



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