Cancel SQL queries in Management Portal or Shell

Question

Question

Conor Browne · Jan 31, 2020

How do you cancel a query that is executing in the Management Portal > System > SQL?

Does closing the browser cancel the query or does it continue to run in the background?

Is there any added benefit to using the Shell over the Portal? Perhaps there is a way to cancel/stop a query here?

$SYSTEM.SQL.Shell()

Thanks

Discussion (6)0

Log in or sign up to continue

Robert Cemper · Feb 1, 2020

Once the query is running it is not interested in any browser activity.

BUT:
the query is stopped when you fall into the session timeout
and the related process (and any query) is terminated.
SO it not running forever!

1 0

score 1 · Answer 1 · 2020-01-31T11:41:03-05:00

the benefit of the shell is:

you can stop it by <CTRL>+C immediately. But also don't get any output.
so it's rather a KILL than a STOP

score 0 · Answer 2 · 2020-01-31T18:38:10-05:00

Thanks Robert, do you happen to know if closing the browser in the management portal cancels the executing query?

score 0 · Answer 3 · 2020-02-01T05:55:18-05:00

Robert Cemper · Feb 1, 2020

Correction:

in SQL.Shell you get a partial result

0 0

score 0 · Answer 4 · 2020-02-02T08:31:22-05:00

Hi Conor,

We added a "cancel" button to the SMP in IRIS 2019.3 and are looking at an equally convenient mechanism from the shell.

score 0 · Answer 5 · 2020-02-06T09:07:17-05:00

Yuriy Borokhov · Feb 6, 2020

Very nice feature indeed! Thank you for adding it.

0 0