Hello, Igniters.
Ignite right now support `KILL QUERY` command.
I tried to use it and stuck with the simple test.
Error is «Query with provided ID doesn’t exist»
Can you, please, advise me - How KILL QUERY should be used?
```
@Test
public void testCancelSQLQuery() throws Exception {
IgniteEx ignite0 = startGrids(NODES_CNT);
IgniteEx client = startClientGrid("client");
ignite0.cluster().state(ACTIVE);
initCache(client);
SqlFieldsQuery qry = new SqlFieldsQuery("SELECT _KEY, _VAL FROM
INTEGER").setSchema("default").setPageSize(10);
Iterator<List<?>> iter = queryProcessor(client).querySqlFields(qry,
true).iterator();
assertNotNull(iter.next());
List<List<?>> sqlQries0 = SqlViewExporterSpiTest.execute(ignite0,
"SELECT QUERY_ID FROM SYS.SQL_QUERIES");
assertEquals(1, sqlQries0.size());
String qryId = (String)sqlQries0.get(0).get(0);
SqlViewExporterSpiTest.execute(client, "KILL QUERY '" + qryId + "'»);
//Expecting this iteration will fail.
while(iter.hasNext())
assertNotNull(iter.next());
fail("You shouldn't be here!");
}
private void initCache(IgniteEx client) {
IgniteCache<Object, Object> cache = client.getOrCreateCache(
new
CacheConfiguration<>(DEFAULT_CACHE_NAME).setIndexedTypes(Integer.class,
Integer.class));
for (int i = 0; i < PAGE_SZ * PAGE_SZ; i++)
cache.put(i, i);
}
```
```
class org.apache.ignite.internal.processors.query.IgniteSQLException: Failed to
cancel query [nodeId=4f812490-47b9-4331-8b51-d783f5300000,qryId=1,err=Query
with provided ID doesn't exist [nodeId=4f812490-47b9-4331-8b51-d783f5300000,
qryId=1]]
at
org.apache.ignite.internal.processors.query.h2.CommandProcessor.processKillQueryCommand(CommandProcessor.java:482)
at
org.apache.ignite.internal.processors.query.h2.CommandProcessor.runCommand(CommandProcessor.java:411)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeCommand(IgniteH2Indexing.java:996)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.querySqlFields(IgniteH2Indexing.java:1085)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:2454)
````