Failed backups cannot be removed from Backup Manager

Stefan Yakubov

Updated February 01, 2024 09:22

Plesk for Windows Plesk for Linux kb: technical

Applicable to:

Failed backups cannot be removed from a list in Tools & Settings > Backup Manager
The backup checkbox is greyed out and can not be selected

Failed backup task is stuck in the tasks.db database

Linux

Connect to the server via SSH
Access the backup tasks database:

# sqlite3 /usr/local/psa/PMM/tasks/tasks.db
Find the failed task by timestamp and remove it.

For example, the failed backup session was created 2020-09-01:

MYSQL_LIN: SELECT * FROM tasks WHERE dump LIKE '%2020-09-01%;
Examine the query output, and remove the task if the session timestamp matches the stuck one:

MYSQL_LIN: DELETE FROM tasks WHERE id=2;

Windows

Connect to the server via RDP
Download the sqlite3 client from this link and extract it to any convenient location (e.g. C:\sqlite)
Open the command prompt as Administrator and access the backup tasks database

C:\> "C:\sqlite\sqlite3.exe" "%plesk_dir%PMM\tasks\tasks.db"
Find the failed task by timestamp and remove it.

For example, the failed backup session was created 2020-09-01:

MYSQL_WIN: SELECT * FROM tasks WHERE dump LIKE '%2020-09-01%;
Examine the query output, and remove the which has the session timestamp matching the stuck one in GUI:

MYSQL_WIN: DELETE FROM tasks WHERE id=2;