How can I resolve MySql exceptions, found in CA Performance Center logs, such as EMService.log, PCService.log, etc?
java.sql.SQLException: Table './em/event_properties#P#p20160926' is marked as crashed and should be repaired
1. Stop the MySql daemon, as follows
2. Run the following command to recover corrupted tables
myisamchk --recover /opt/CA/MySql/data/netqosportal/*.MYI
3. Start the MySql daemon, as follows
4. Restart services on the CAPC system, and perform a full sync of the Event Manager data source, if this was an error in the EMService.log
It could take up to an hour for the issue to resolve, after performing this