How to resolve MySql errors in NetOps Portal

Products

• CA Infrastructure Management
• CA Performance Management
• Network Observability

Issue/Introduction

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

 

Environment

Release: Any
Component:

Resolution

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

Additional Information

It could take up to an hour for the issue to resolve after performing this.