How to Cancel a Long Running Transaction | All Nodes
Canceling Long Running Transactions
Often times we kick off transactions that we may want to cancel. The transaction may end up running longer than expected, potentially causing performance issues or unexpected behavior. So how to do that quickly?
Cancel Transactions Pre-Istanbul (Node Specific)
Pre-Istanbul, canceling transactions was only available for the node you were currently logged into under User Administration > All Active Transactions
Clicking on All Active Transactions brings up a list of the actively running transactions for the node logged into. To cancel a transaction:
- Select the transaction in the list
- Open the menu at the bottom of the list and select Kill
Note: It may take a few seconds for the transaction to die in the background. Refresh the list several times to confirm the transaction is properly killed.
Cancel Transactions on Any Node (Istanbul+)
In Istanbul, the ability was added to be able to cancel any transaction from the node logged into, no longer node specific. This is available in another module, System Diagnostics > Active Transactions (All Nodes). Follow the same steps as above to kill transactions:
- Select the transaction in the list
- Open the menu at the bottom of the list and select Kill
Note: Transactions are grouped by the application node that is currently running them.