Stop the scheduling of a Galaxy workflow invocation

gistfile1.txt

If a handler log is full of messages like:

Workflow step 1585 of invocation 554 delayed

then probably a workflow invocation is stuck because a step was cancelled by a user. After verifying that this is the case, to stop the workflow invocation scheduling connect to the Galaxy database using psql and do the following:

galaxy_db=> SELECT * FROM workflow_invocation WHERE id=554;
 id  |        create_time         |        update_time         | workflow_id | history_id | state | scheduler | handler  |               uuid               
-----+----------------------------+----------------------------+-------------+------------+-------+-----------+----------+----------------------------------
 554 | 2016-11-16 17:24:38.586902 | 2016-11-16 17:26:34.555872 |         201 |        485 | ready | core      | handler1 | 8d49678eac2111e697b90050569af9e3
(1 row)

galaxy_db=> UPDATE workflow_invocation SET state = 'scheduled' WHERE id = 554;
UPDATE 1