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
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/0aed1880-93b1-55fb-9346-7ea3d5f1884a%40gmail.com.
