NFA RA and Harvester database backup fail

Article Id: 145276

Status: Published

Updated On: 20-02-2020 11:06

Products:

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction:

Unable to take mysql database backup using mysqldump command. and getting below error.

Table 'performance_schema_session_variables' doesn't exist (1146)

Cause:

This happens when the database become corrupt.

Environment:

Component : NETWORK FLOW ANALYSIS

Resolution:

Run the mysqlcheck command on the database which is running into issues:

mysqlcheck --repair --databases db_name

Then run the mysqldump command again to take the backup.