[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16946851#comment-16946851 ] Maxim Muzafarov commented on IGNITE-8913: - Moved to 2.9 due to inactivity. Please, feel free to move it back if you will be able to complete the ticket by 2.8 code freeze date, December 2, 2019. > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Improvement > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Priority: Major > Labels: iep-29, sql-stability > Fix For: 2.8 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16693024#comment-16693024 ] Vladimir Ozerov commented on IGNITE-8913: - Re-merged with master. > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Vladimir Ozerov >Priority: Major > Labels: iep-29, sql-stability > Fix For: 2.8 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16693028#comment-16693028 ] Vladimir Ozerov commented on IGNITE-8913: - Test run (SQL only): https://ci.ignite.apache.org/viewQueued.html?itemId=2360521 > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Vladimir Ozerov >Priority: Major > Labels: iep-29, sql-stability > Fix For: 2.8 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16693025#comment-16693025 ] ASF GitHub Bot commented on IGNITE-8913: GitHub user devozerov opened a pull request: https://github.com/apache/ignite/pull/5442 IGNITE-8913 You can merge this pull request into a Git repository by running: $ git pull https://github.com/gridgain/apache-ignite ignite-8913-1 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/ignite/pull/5442.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 #5442 commit 26543e10f8143dbc2d313b870081d633baf4cd05 Author: SGrimstad Date: 2018-08-14T11:21:13Z IGNITE-9141 Implemented commit ee631080782fe17a007e10117a96fc1a72990854 Author: devozerov Date: 2018-08-14T12:54:32Z Merge branch 'master' into ignite-9141 commit 4587bfc24f25045fd7fc2197076797cc6ca54e32 Author: devozerov Date: 2018-08-14T13:23:19Z Review. commit 1511eb31b644113091be156d872f5adb2daecb84 Author: SGrimstad Date: 2018-08-14T11:21:13Z IGNITE-9141 Implemented commit 0425a32a3d490165b29bcf9236a49a48f7761666 Author: devozerov Date: 2018-08-14T13:23:19Z Review. commit a7209f870148f984cdbf3e6437337c7b665defb5 Author: SGrimstad Date: 2018-08-20T11:56:11Z IGNITE-9141 Modified according to review comments. Integration tests added commit 08e196ad4503d4487fda0da2b61406ef3bd84cbf Author: SGrimstad Date: 2018-08-20T12:28:46Z IGNITE-9141 javadoc added commit b006a8dba4ae4319aa78a0d3c6fd6eef47bb1da8 Author: SGrimstad Date: 2018-08-20T12:29:46Z IGNITE-9141 javadoc added commit 0ed04a7ca655866685841b2ec9c2ed64797bf233 Author: devozerov Date: 2018-08-28T08:05:04Z Merge branch 'master' into ignite-9141 commit 02db267355a8405c64c45d51c81e342df664d612 Author: devozerov Date: 2018-08-28T08:45:55Z Review comments. commit 0c4301cdc0d6108ed5b51173144e19d3ad450e63 Author: SGrimstad Date: 2018-08-28T11:08:47Z IGNITE-9141 Fixes according to review commit dd35f024d77d12badf711bce3644450008e38921 Author: SGrimstad Date: 2018-08-29T12:15:43Z IGNITE-8913 Query cancelled messages are enriched with details, tests updated commit ce15a79ded414f3b41bbe8ca3521f5ff4aaa3174 Author: zaleslaw Date: 2018-08-28T11:03:37Z IGNITE-9393:[ML] KMeans fails on complex data in cache this closes #4628 commit 435184a203598740ace2f0b53cf136dc3443e168 Author: Roman Guseinov Date: 2018-08-28T11:41:09Z IGNITE-9367: Fixed crash in ODBC on executing query with closed connection This closes #4621 commit 82e55e927260327996495360b5ae7019a1c958a6 Author: Denis Mekhanikov Date: 2018-08-28T14:46:29Z IGNITE-9389 Avoid deadlock on cache#close(). - Fixes #4626. Signed-off-by: Alexey Goncharuk commit a4dedb746a5997d8f318b7ee059825e7b7101687 Author: Aleksei Scherbakov Date: 2018-08-28T15:18:26Z IGNITE-9401 Fixed race in tx rollback test - Fixes #4633. Signed-off-by: Alexey Goncharuk commit b8b2e7098a675a4f37264579be1dfd2c89f3316c Author: Ivan Rakov Date: 2018-08-29T12:32:59Z IGNITE-6879 Support Spring Data 2.0 - Added package description to parent/pom.xml commit c1f5a85c61ad6086b8b180b3169fed30f1155841 Author: Alexey Goncharuk Date: 2018-08-30T08:35:53Z IGNITE-9326 Fixed deferred serialization error handling for EntryProcessor result - Fixes #4588. Signed-off-by: Alexey Goncharuk commit ee2c5a7b7c7f0a0684fdaa063c759057c4bfa6ba Author: zaleslaw Date: 2018-08-30T08:56:39Z IGNITE-9421: ML Examples: LogisticRegressionSGDTrainerExample example result not correct this closes #4646 commit f858474292805cf93a30c01676f519790402df1c Author: Alexey Goncharuk Date: 2018-08-30T09:39:22Z IGNITE-9429 Fixed flaky GridCacheReplicatedDataStructuresFailoverSelfTest commit 88d16494516ab66af3849aae8e3aa6faf7f32efb Author: Vasiliy Sisko Date: 2018-08-30T11:11:21Z IGNITE-9370 Fixed execution of REST commands in demo mode. commit 23b33b617356704370f6b15b05b41f3edc5b2bd9 Author: Igor Seliverstov Date: 2018-08-30T11:52:49Z IGNITE-4191: MVCC and transactional SQL support. Joint multi-man-years efforts of Semen Boikov, Igor Seliverstov, Alexander Paschenko, Igor Sapego, Sergey Kalashnikov, Roman Kondakov, Pavel Kuznetsov, Ivan Pavlukhin, Andrey Mashenkov, and many others. Special thanks for design ideas and review to Alexey Goncharuk and Sergi Vladykin. This closes #3220. commit eec22c55249669091edf404f126181a350197ada Author: Anton Kalashnikov Date: 2018-08-30T12:02:50Z IGNITE-6552 Added ability to set WAL history size in bytes - Fixes #3559. commit 8af84fe0f62880937b7350efa9a9646086a98ce3 Author: EdShangGG Date: 2018-08-30T13:47:23Z IGNITE-9302 Added
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16658722#comment-16658722 ] Sergey Grimstad commented on IGNITE-8913: - remerged https://ci.ignite.apache.org/viewLog.html?buildId=2120800; > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Sergey Grimstad >Priority: Major > Labels: sql-stability > Fix For: 2.8 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16629095#comment-16629095 ] Sergey Grimstad commented on IGNITE-8913: - 1 point adjusted and pushed 2 point - we actually do not swallow any {{SQLException, but only with }} e.getErrorCode() == ErrorCode.{color:#9876aa}STATEMENT_WAS_CANCELED{color} and throwing our own instead with more details > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Sergey Grimstad >Priority: Major > Labels: sql-stability > Fix For: 2.8 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16620522#comment-16620522 ] Sergey Grimstad commented on IGNITE-8913: - fixed according to review > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Sergey Grimstad >Priority: Major > Labels: sql-stability > Fix For: 2.7 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (IGNITE-8913) Uninformative SQL query cancellation message
[ https://issues.apache.org/jira/browse/IGNITE-8913?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16602175#comment-16602175 ] Sergey Grimstad commented on IGNITE-8913: - [https://ci.ignite.apache.org/viewLog.html?buildId=1785278;] failed tests are flaky and non-reproducible locally > Uninformative SQL query cancellation message > > > Key: IGNITE-8913 > URL: https://issues.apache.org/jira/browse/IGNITE-8913 > Project: Ignite > Issue Type: Bug > Components: sql >Affects Versions: 2.5 >Reporter: Vladislav Pyatkov >Assignee: Sergey Grimstad >Priority: Major > Labels: sql-stability > Fix For: 2.7 > > Attachments: sgrimstad_IGNITE_8913_Query_cancelled_me.patch > > > When query timeouted or cancelled or other exception, we getting message: > "The query was cancelled while executing". > Need make message more clear - text of query, node which the cancelled, > reason of cancel query e.t.c. > {noformat} > 2018-06-19 > 00:00:10.653[ERROR][query-#93192%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.GridQueryCancel.set(GridQueryCancel.java:53) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQuery(IgniteH2Indexing.java:1115) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1207) > at > org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSqlQueryWithTimer(IgniteH2Indexing.java:1185) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:683) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > 2018-06-19 > 00:00:11.629[ERROR][query-#93187%DPL_GRID%DplGridNodeName%][o.a.i.i.p.q.h.t.GridMapQueryExecutor] > Failed to execute local query. > org.apache.ignite.cache.query.QueryCancelledException: The query was > cancelled while executing. > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest0(GridMapQueryExecutor.java:670) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onQueryRequest(GridMapQueryExecutor.java:527) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor.onMessage(GridMapQueryExecutor.java:218) > at > org.apache.ignite.internal.processors.query.h2.twostep.GridMapQueryExecutor$2.onMessage(GridMapQueryExecutor.java:178) > at > org.apache.ignite.internal.managers.communication.GridIoManager$ArrayListener.onMessage(GridIoManager.java:2333) > 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:1142) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)