How to cancel stuck running task in SolusVM 2?

Question

How to cancel a stuck task in SolusVM 2?

Answer

1. Create the database backup: 
   How to create SolusVM 2 database backup?
2. Access the database:
   How to access SolusVM 2 database?
3. Set the task status as 'failed':
   # update tasks set status='failed' where id=ID;
   Where ID is an id of a task in SolusVM 2 UI > Tasks 
    

For many tasks use the query:

UPDATE tasks
SET status = 'failed'
WHERE id IN (193608, 193609, 193610);