Resolved Database Task does nothing

[hauke]

I started a "check" on a database and this task does nothing and apears every time I log on.
The database itself is in order (a second check went through). What can I do?

 

[UFHH01]

Hi hauke,

your previous task didn't seem to finish correctly, so that Plesk didn't delete the ( temporary ) task. Pls. consider to use the "Plesk repair utility", with the example command ( logged in as user "root" over SSH ) :

plesk repair db -y -v​

Pls. consider to read as well the Plesk documentation, in order to inform yourself about additional options and descriptions:

=> Plesk Repair Utility ( Plesk 12.5 - online documentation - Administrator's Guide )​

 

[hauke]

repair shows "no warnings, no errors". Task is still there.

 

[UFHH01]

Hi hauke,

pls. login to your Plesk database ( as user "root" over SSH ) :

plesk db​

Find the task, which is unfinished/broken/hanging, by listing the tasks:

mysql> select * from longtasks;

Delete the task with for example:

mysql> delete from longtasks where id=X;

( where "X" is the number of the ID, which you would like to delete ).


Exit MySQL:

mysql> exit

 

[hauke]

works like a charm. thnx a lot!