MTP Stopped with error message that a table is marked as crashed

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)

Issue/Introduction

Seeing that the MTP is stopped in ADA. 

Also, when attempting to connect to the MTP, the following message is displayed:

Error in SqlCommand at Execute : Table './nqmpcdb/configuration_settings' is marked as crashed and should be repaired

 

Environment

Release : 10.0.5

Component : NQSAMP - NETQOS SA MULTI-PORT COLLECTOR

Cause

configuration_settings table in the nqmpcdb database is corrupted and needs to be repaired.

Resolution

1. ssh into the MTP server
2. type the following commands:
   
   1. mysql nqmpcdb
   2. show table status;
      1. The status for configuration_settings will show NULLs under every field.
   3. repair table configuration_settings;
      1. You may see a few warnings indicating the repairs that were done and an OK status.
   4. show table status;
      1. The status for configuration_settings should now show this table without NULLs.
3. exit back to the linux prompt
4. Run sudo /opt/NetQoS/scripts/startprocs.sh to make sure that all the MTP services are started