Symptoms
-
Plesk full backup task got failed with an error in
file:
%plesk_dir%/PMM/sessions/<timestamp>/migration.result
PLESK_ERROR: <execution-result status=”error” log-location=”/usr/local/psa/PMM/sessions/<timestamp>/migration.result”>
<object name=”019″ type=”client”>
<object name=”domain.tld” type=”domain”>
<object name=”db_name” type=”mysql”>
<message id=”dddba294-8e17-4d09-88c2-939270aef116″ severity=”error
<description>Failed to execute backup of mysql database 'lap
</message>
<message id=”78afa08d-35e6-464a-8d7a-88c7ffdf69c7″ severity=”error
<description>Failed to pack files backup_database_1_1401080148 i
412864 bytes free of 492248408064 bytes total on mount point 0]</description -
Manual backup of domain’s database results in error:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin database > database_backup.sql
mysqldump: Got error: 145: Table ‘./db_name/toc_whos_online’ is marked as crashed and should be repaired when using LOCK TABLES -
The following error appears during a migration process:
PLESK_ERROR: WARNING: (mysql object ‘db_name’) Not all the data was backed up into /var/cache/<timestamp>/clients/ccia/domains/domain.tld/databases/db_name_1 successfully. Use of chdir(”) or chdir(undef) as chdir() is deprecated at Storage/Bundle.pm line 39, <STDIN> line 5.
mysqldump: Got error: 145: Table ‘./db_name/Logs’ is marked as crashed and should be repaired when using LOCK TABLESOr
PLESK_ERROR: stderr: mysqldump: Got error: 144: “Table ‘./db_name/table_name’ is marked as crashed and last (automatic?) repair failed” when using LOCK TABLES
Cause
Database table corruption.
Resolution
Note: if the solutions below don’t help, affected database should be restored from a backup.
Repair the corrupted database using one of the following methods:
Via Plesk GUI
- Log in to Plesk
- Navigage to Plesk > Domains > example.com > Databases > db_name and click Check and Repair:
Via phpMyAdmin
-
Log in to Plesk;
-
Navшgate to Plesk > Domains > example.com > Databases > db_name and click phpMyAdmin:
-
Click SQL button and run the following query:
REPAIR TABLE table_name;
Where table_name is the name of the table to repare
Via SSH
-
Connect to the server via SSH;
-
Execute the command:
# MYSQL_PWD=
cat /etc/psa/.psa.shadow
 mysqlcheck -uadmin -r db_name table_nameWhere db_name is the name of the database where table table_name to be repaired.