[jira] [Commented] (IGNITE-11496) Long running SQL queries could be randomly canceled from WC

["Vasiliy Sisko (JIRA)" <ji...@apache.org>]

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

Vasiliy Sisko commented on IGNITE-11496:
----------------------------------------

Implemented notification of node when extraction of query results is long.

> Long running SQL queries could be randomly canceled from WC
> -----------------------------------------------------------
>
>                 Key: IGNITE-11496
>                 URL: https://issues.apache.org/jira/browse/IGNITE-11496
>             Project: Ignite
>          Issue Type: Bug
>          Components: wizards
>    Affects Versions: 2.5
>            Reporter: Evgenii Zhuravlev
>            Assignee: Vasiliy Sisko
>            Priority: Major
>
> I've tried to run some long-running queries from WC(more than a couple of minutes) and I've faced a behavior when the query was canceled without clicking on the cancel button.
> I've opened different browser tabs at this moment, maybe it could be the reason.
> {code}
> javax.cache.CacheException: Failed to run reduce query locally.
>     at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:883)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$7.iterator(IgniteH2Indexing.java:1494)
>     at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:95)
>     at org.apache.ignite.internal.visor.query.VisorQueryHolder.getIterator(VisorQueryHolder.java:97)
>     at org.apache.ignite.internal.visor.query.VisorQueryFetchFirstPageTask$VisorQueryFetchFirstPageJob.run(VisorQueryFetchFirstPageTask.java:85)
>     at org.apache.ignite.internal.visor.query.VisorQueryFetchFirstPageTask$VisorQueryFetchFirstPageJob.run(VisorQueryFetchFirstPageTask.java:51)
>     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:6750)
>     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:1123)
>     at org.apache.ignite.internal.processors.job.GridJobProcessor$JobExecutionListener.onMessage(GridJobProcessor.java:1921)
>     at org.apache.ignite.internal.managers.communication.GridIoManager.invokeListener(GridIoManager.java:1556)
>     at org.apache.ignite.internal.managers.communication.GridIoManager.processRegularMessage0(GridIoManager.java:1184)
>     at org.apache.ignite.internal.managers.communication.GridIoManager.access$4200(GridIoManager.java:125)
>     at org.apache.ignite.internal.managers.communication.GridIoManager$9.run(GridIoManager.java:1091)
>     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.cache.query.QueryCancelledException: The query was cancelled while executing.
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1240)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1303)
>     at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1281)
>     at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:835)
>     ... 20 more
> {code}



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