Error 145 on database table(s) when launching a Backup from the Control Center of Symantec Messaging Gateway version 9.x AND ABOVE
Last Updated November 03, 2015
Error 145 on one or more database table(s) is shown when launching a Backup from the Control Center. and ERROR "HOST VERSION CANNOT BACKUP THE DATABASE"
ERROR: Failed to run: '/opt/Symantec/Brightmail/mysql/bin/mysqldump': mysqldump: Got error: 145: Table './brightmail/report_sender' is marked as crashed and should be repaired when using LOCK TABLES
NOTE: the table in the example above may vary.
Also on newer versions you may also see the following error message on the web interface:
ERROR "HOST VERSION CANNOT BACKUP THE DATABASE"
The table is marked as crashed.
Run a Database check and repair to fix the issue.
Login to the command line interface (CLI) on the Control Center as the "admin" account.
Enter the following command. cc-config database --check
When prompted, enter yes to proceed.
After the MySQL check has completed: if one or more MySQL tables are marked as crashed, entering the following command at the next CLI prompt will attempt to repair those tables. cc-config database --repair