Drop database task fails with the error:
Task name Drop database db123456_dbname on host 192.168.10.100 Last execution output MySQL API error: Error dropping database (can't rmdir './db123456_dbname', errno: 39).
At the same time it looks like database is already empty - attempt to drop it manually fails as well with the same error:
mysql> DROP DATABASE db123456_dbname; ERROR 1010 (HY000): Error dropping database (can't rmdir './db123456_dbname', errno: 39) mysql> use db123456_dbname; Database changed mysql> show tables; Empty set (0.00 sec)
Database files were manually copied to the server, and folder
/var/lib/mysql/db123456_dbname actually contains a database:
# du -hsx /var/lib/mysql/db123456_dbname 20M /var/lib/mysql/db123456_dbname
of which MySQL is not aware of.
Backup database folder
/var/lib/mysql/db123456_dbname, delete files from
/var/lib/mysql/db123456_dbname and then restart the failed task.