NFA RA and Harvester database backup fail

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.