KILL
¶
Kills active jobs in the CrateDB cluster.
Note
This statement is only available for all users on clusters running CrateDB
versions 4.3 and above. Prior version 4.3, the
KILL
statement can only be run by the crate
superuser.
Table of contents
Synopsis¶
KILL (ALL | job_id)
Description¶
The KILL ALL
statement kills all active jobs within the CrateDB cluster
which are owned by the current user.
The statement KILL job_id
kills the job with a specified job_id
if the
job was started by the current user.
An exception to this is the CRATE
super-user, which can also kill
statements of other users.
Be aware that CrateDB doesn’t have transactions. If an operation which modifies
data is killed, it won’t rollback. For example if a update operation is killed
it is likely that it updated some documents before being killed. This might
leave the data in an inconsistent state. So take care when using KILL
.
Certain fast running operations have a small time frame in which they can be
killed. For example if you delete a single document by ID the document could
be deleted before the KILL
command is processed, but the client might
receive an error that the operation has been killed because the KILL
command processed before the final result is sent to the client.
KILL ALL
and KILL job_id
return the number of contexts killed per node.
For example if the only active query was select * from t
and that query is
being executed on 3 nodes, then KILL ALL
will return 3.
Parameters¶
- job_id:
The UUID of the currently active job that needs to be killed given as a string literal.