How to resolve MySql errors

Document ID : KB000047355
Last Modified Date : 14/02/2018
Show Technical Document Details

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