Archive Manager repair not showing any progress

Article Id: 140337
Status: Published
Updated On: 18-11-2019 09:27
Products:
CA Spectrum , CA Spectrum , CA Spectrum , CA Spectrum , CA Spectrum , CA Spectrum , CA Spectrum , CA eHealth
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 : 10.3

Component : Spectrum Core / SpectroSERVER

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.