How to cancel a stuck task in Plesk

Connect to the Plesk server via SSH.

Create a backup of the Plesk database:

# plesk db dump > /root/psa_dump.sql

Find the stuck process:

# plesk db "SELECT id,type,status,finishTime FROM longtasks WHERE status <> 'done'"

+----+-----------------------------+---------+---------------------+
| id | type                        | status  | finishTime          |
+----+-----------------------------+---------+---------------------+
| 56 | ext-wp-toolkit-task\install | started | 0000-00-00 00:00:00 |
+----+-----------------------------+---------+---------------------+

Delete the task from the longtasks table using id from step 3:

# plesk db "DELETE FROM longtasks WHERE id=56"

Delete entries from the longtaskparams table using id from step 3:

# plesk db "DELETE FROM longtaskparams WHERE task_id=56"

Kill the stuck process:

# pkill task-async-executor

Note: In case tasks keep getting stuck after performing the above actions, clear the lock manager using the below commands:

# service sw-engine stop
# rm -rf /var/lock/lmlib/container_locks
# rm -f /usr/local/psa/var/cache/*
# service sw-engine start

Connect to the Plesk server via RDP.

Start a command prompt as an Administrator.

Create a backup of the Plesk database:

C:\> plesk db dump > C:\psa_dump.sql

Find the stuck process:

C:\> plesk db "SELECT id,type,status,finishTime FROM longtasks WHERE status <> 'done'"

+----+-----------------------------+---------+---------------------+
| id | type                        | status  | finishTime          |
+----+-----------------------------+---------+---------------------+
| 56 | ext-wp-toolkit-task\install | started | 0000-00-00 00:00:00 |
+----+-----------------------------+---------+---------------------+

Delete the task from the longtasks table using id from step 4:

C:\> plesk db "DELETE FROM longtasks WHERE id=56"

Delete entries from the longtaskparams table using id from step 4:

C:\> plesk db "DELETE FROM longtaskparams WHERE task_id=56"