This article is for all versions of Amanda Enterprise (AE)
Issue Symptoms
In /opt/zmanda/amanda/logs/zmc_gui_errors.log you may see the following error:
MySQL error #145: Table './zmc/events' is marked as crashed and should be repaired
Or during ZMC startup you see the following:
/opt/zmanda/amanda/mysql//bin/mysqladmin.bin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/opt/zmanda/amanda/mysql/tmp/mysql.sock' (111)' and when you check /opt/zmanda/amanda/mysql/data/mysqld.log, you find indications of crashed tables.
Resolution
To repair the ZMC database, use the following procedure. Please note:
- This procedure should be performed only when no backup or restore or media management operation is in progress.
- ZMC will not be available during this procedure.
- A backup of ZMC database is created before database repair is attempted. The backup tarball is stored at /opt/zmanda/amanda/logs/zmcdb-<datestamp>.tar.gz
- The zmc_aee service will be stopped before database repair and restarted afterward.
Run the following command as the root user:
# /opt/zmanda/amanda/bin/zmc-db-repair.sh
Check the command logs for errors. If there are errors, please contact Zmanda Support team.