Recent versions of Plesk include a “Make a Copy” feature for databases. Unfortunately, on occasion the copy will fail but the copy task will not be removed. Then you’ll see a message like this every time you go to the affected database in Plesk.
You can view a list of the current tasks with the following command from a root ssh login:
1 2 |
echo "select * from longtasks" | \ mysql --password=`cat /etc/psa/.psa.shadow` -u admin psa |
You can clear the task by running the following command:
1 2 |
echo "delete from longtasks" | \ mysql --password=`cat /etc/psa/.psa.shadow` -u admin psa |