This document describes how to repair a damaged table in the Cisco Information Server (CIS) MySQL-based repository (meta database).
When you attempt to log in to the CIS or when the server is restarted, you encounter an error message similar to this within a pop-up window or in the server log:
An internal error has occurred.
Cause: Table '.\cs060201\metadata_dependencies' is marked
as crashed and last (automatic?) repair failed.
Cisco recommends that you first restart the MySQL instance in order to allow time for automatic repairs. Complete these steps in order to restart the MySQL instance:
- Stop the Composite server service.
- Navigate to the root of the installation directory.
- Enter the /bin/composite.show repo restart command.
- Restart the Composite server.
Microsoft Windows Installations
If a system restart does not resolve the error, then you must download the MySQL administrator client tool from MySQL and use the GUI in order to repair the table. Use the MySQL administrator tool locally on the same host and log in with these credentials:
- User: root
- Password: <password supplied during CIS installation>
- Port: 9408
In the administrator tool, locate your catalog or DB and choose to repair the suspect table.
Linux or Unix Installations
If this issue occurs on a Linux or Unix host, then you can choose to run a repair from the CLI. Here is an example:
<install dir>\apps\mysql-5_0_72\bin>mysqlcheck --auto-repair --check --databases
<your db name> --extended --user=root --password=<your password> --host=
If the table is repairable, start the CIS instance once more and monitor the bootup in order to verify that it is now active and listens.