Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-11496

Long running SQL queries could be randomly canceled from WC

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5
    • Fix Version/s: 2.8
    • Component/s: wizards
    • Labels:
      None

      Description

      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.

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kuaw26 Alexey Kuznetsov
                Reporter:
                ezhuravl Evgenii Zhuravlev
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: