On 2021/06/15 6:36 pm, Tom Kalmijn wrote:
> I was looking for a way to cancel a long running 'CREATE INDEX'.
>
> I tried "CALL CANCEL_SESSION(<id of create index session>)" with no luck.
>
> The resultset does return True but the running create index query does not stop.
There is currently no support for interrupting a CREATE INDEX operation.
CANCEL_SESSION sets a cancel flag, but unless the operation code checks the flag, it has no effect, and in this case,
CREATE INDEX does not check the flag