89 views

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.

 

Article Information

Last Updated:2017-09-19 05:31:37
Published:2017-09-19