How to resolve MySql errors

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


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

/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