Errors seen in the ARCHMGR.OUT file for Spectrum indicate database corruption that needs to be repaired

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

Errors seen in the $SPECROOT/SS/DDM/ARCHMGR.OUT file of Spectrum indicates corruption in the DDM database that needs to be repaired. The following are some examples:

 

Feb 09 22:02:36 ERROR TRACE at ModelArchDBImp.cc(4820): doSqlQuery/mysql_query: Failure executing query:

DELETE FROM event WHERE utime <= 1485468156 LIMIT 1000 - Incorrect key file for table '.\ddmdb\event.MYI'; try to repair it

 

Native error: 145, table './ddmdb/event' is marked as crashed and should be repaired

 

 

Resolution:

Use the following instructions to repair the DDM database corruption:

1. Log into the system as the user that owns the Spectrum installation

2. If Windows, start a bash shell by running "bash -login"

3. Shutdown the ArchMgr process if running:

    a. On Windows, start the Spectrum Control Panel and select Control -> Stop Archive Manager from the top level menu

    b. On Linux or Solaris, run the following command from the $SPECROOT/bin directory where <HOST> is the hostname of the systems and <PID> is the process id of the ArchMgr process:

./cmdC <HOST> 2 <PID>

4. cd to the $SPECROOT/SS/DDM directory and enter the following command to repair the DDM database:

./ArchMgr -repair

5. When the repair is complete start the Archive Manager:

    a. On Windows, start the Spectrum Control Panel and select Control -> Start Archive Manager from the top level menu

    b. On Linux and Solaris, cd to the $SPECROOT/bin directory and run the following command:

./startSS.pl

6. Review the $SPECROOT/SS/DDM/ARCHMGR.OUT file to verify the errors are gone