Nsure Audit Mysql can't open file log.MYI

  • Document ID:3393775
  • Creation Date:24-Aug-2006
  • Modified Date:27-Apr-2012
    • Micro Focus Products:
      Audit
      NetWare

Environment

Novell NetWare
Novell Audit 2.0.1 MySQL Channel

Situation

Customer performed a rollout of Novell Audit and various configuration issues with the Secure Logging Server (SLS) needed to be resolved.

Server placement of the SLS moved from one Server to another in an attempt to get a working solution.

After some time error messages were seen on 2 of the Servers being audited and the following message appeared on the SLS:

Nsure Audit MySQL: can't open file log.MYI

Resolution

One or more of the mysql tables had become corrupt. To resolve this issue, perform a repair using myisamchk as described at:

Mysql 5.0 Reference Manual / 8.3 myisamchk — MyISAM Table-Maintenance Utility

Additional Information

The myisamchk utility gets information about your database tables and then checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes).

Invoke myisamchk with the following syntax:

shell>myisamchk [options]tbl_name ...

Examples :
1. If you are not in the database directory, you can check all of the tables located there by specifying the path to the directory:
shell>myisamchk /path/to/database_dir/*.MYI

You can even check all tables in all databases by specifying a wildcard with the path to the MySQL data directory:

shell>myisamchk /path/to/datadir/*/*.MYI

The recommended way to quickly check all MyISAM tables is:

shell>myisamchk --silent --fast /path/to/datadir/*/*.MYI

shell>myisamchk --silent --force --fast --update-state \
--key_buffer_size=64M --sort_buffer_size=64M \
--read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI