Archive Manager repair not showing any progress

Products

• CA eHealth
• CA Spectrum

Issue/Introduction

Archive Manager database corrupt.  The repair has been running 45 minutes with no cpu showing for command.

Cause

• MySQL repair will generally use very little CPU.
• Command Prompt Window was in Select Mode.

Environment

Release : 20.2.x

Component : SPCAEM - Events and Alarms

Resolution

• Logged into MySQL:   ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb -A
• Ran Show full processlist\G and verified there was no activity:

• Command Prompt was in Select mode so the terminal was not displaying in real-time:

Ct

• Ctrl + C  exited Select mode and revealed Archive Manager Repair was successfully completed.