How can I resolve MySql exceptions found in NetOps Portal 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
Release: Any
Component:
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 NetOps Portal 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.