Error 145 on database table(s) when launching a Backup from the Control Center of Symantec Messaging Gateway version 9.x AND ABOVE

book

Article ID: 155754

calendar_today

Updated On:

Products

Messaging Gateway

Issue/Introduction

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"

Cause

The table is marked as crashed.

Resolution

Run a Database check and repair to fix the issue.

  1. Login to the command line interface (CLI) on the Control Center as the "admin" account.
     
  2. Enter the following command.
    cc-config database --check 
     
  3. When prompted, enter yes to proceed.
     
  4. 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
 

 

Attachments

servlet.png get_app