Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

IEV with CSM 3.1.1 mysql database index corruption

Hello,

We use Cisco IPS Event Viewer version 5.2(2.5) and we have a problem with the mysql database. Sometime, we can not execute views because database index become corrupt. We use myisamchk.exe to repair the index but someone know how avoid the problem?

This is one error that we get when we try to execute view : Null: Incorrect key file for table: 'event_realtime_table'. Try to repair it S1000 1034

Thank you

Rene Charpentier

1 REPLY
Silver

Re: IEV with CSM 3.1.1 mysql database index corruption

You should try stopping the MySQL service and then delete the following files event_realtime_table.frm, event_realtime_table.MYI and event_realtime_table.MYD from mysql\data\alarmDB directory. After this restart the MySQL service.

163
Views
0
Helpful
1
Replies
CreatePlease to create content