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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/0aed1880-93b1-55fb-9346-7ea3d5f1884a%40gmail.com.
