Question:
How can I resolve MySql exceptions, found in CA Performance Center logs, such as EMService.log, PCService.log, etc?
Example:
java.sql.SQLException: Table './em/event_properties#P#p20160926' is marked as crashed and should be repaired
Answer:
1. Stop the MySql daemon, as follows
/etc/init.d/mysql stop
2. Run the following command to recover corrupted tables
myisamchk --recover /opt/CA/MySql/data/netqosportal/*.MYI
3. Start the MySql daemon, as follows
/etc/init.d/mysql start
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
Additional Information:
It could take up to an hour for the issue to resolve, after performing this