The cancel operator cancels a running query or transaction.

Synopsis

cancel( query_id )
cancel( transaction_id )


Summary

The cancel operator cancels and aborts a currently running query or transaction by its id, supplied as a string.

Obtain a query id value from the SciDB log or via the list('queries') command. SciDB maintains query context information for each completed and in-progress query in the server. If you issue a Ctrl+C or abort from the iquery client, SciDB aborts the query and removes its context from the server.

Obtain a transaction id value from the SciDB log or via the list('transactions') or list('txns') command.  This command shows the transaction's id, age in seconds, currently running query's id if any, and information about any locks the transaction currently holds.

In Enterprise Edition security mode, administrative privileges are required to cancel the queries and transactions of other users.

Examples

AFL% list('txns');
{inst,n} self,age,creation_time,user_id,user,is_interactive,coordinator,transaction_id,query_id,locks
{0,0} true,0,'2023-04-26 19:53:32',1,'scidbadmin',false,0,'0.1682538812822058648','0.1682538812822649910','[]'
{0,1} false,15,'2023-04-26 19:53:17',1,'scidbadmin',true,0,'0.1682538797490963036',null,'[["WR","public.B@1"],["RD","public.A@0"]]'
AFL% 
AFL% cancel('0.1682538797490963036');
Query was executed successfully
AFL%