MySQL Database Corruption
Release : 20.2.x
Component : Spectrum Reporting
Below are the commands that can be run to resolve this issue.
1. Login to the reporting database via MySQL.
cd <SPECROOT>/mysql/bin
./mysql.exe -uroot -proot reporting -A (Windows)
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot reporting -A (Linux)
2. Run the repair command using the table name from the error above:
repair table alarmbucket15728640_1601794334359
Once this is complete, the Spectrum Tomcat Service will need to be restarted.