Archive Manager repair not showing any progress

book

Article ID: 140337

calendar_today

Updated On:

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 : 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.

Attachments