ADA console not processing Data Files after drive filled up and after freeing up some space

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)
• CA Application Delivery Analysis (NetQoS / ADA)

Issue/Introduction

When the drive fills up, some mysql tables can get into a crashed state.

We ran the following to get a dump of the table status for each table on the ADA console:

mysql -D super -t -e "show table_status;" > table_status.txt

Then searched for "crashed" and found:
Table '.\super\hourly_classify_end2end#P#pMaxValues' is marked as crashed and should be repaired

Environment

Release : 11.0.2

Component : NQSAMC - NETQOS SA MGMT CONSOLE

Resolution

To repair the table run:

mysql super
repair table hourly_classify_end2end;

This may take a few minutes and requires free disk space

We then found a hung mysql query in the "show processlist" command and found its process ID and ran "kill 7;" then restarted mysql and data started to process again.