Repair a potentially corrupted SSDB in spectrum

Products

• Network Observability
• Spectrum

Issue/Introduction

Spectrum uses a sleepycat database and it can get hidden corruption, usually in the catalog and not the actual data.

This allows the db to still run, but causes unexpected behaviour.

 

Here are the steps to clean up the db and remove the corruption.

 

Environment

Spectrum :: All Supported Versions

Resolution

On the MLS (Main Location Server)

Move a copy of the most recent backup to the problem LS (Location Server)

Copy to the $SPECROOT/SS-DB-Backup directory and unzip the file and give it a unique name such as MLS-SAVE.SSdb

Stop the LS Spectroserver

From the $SPECROOT/SS directory  

Enter the following command to load the catalog from the MLS system

   ../SS-Tools/SSdbload -ic ../SS-DB-Backup/MLS-SAVE.SSdb (use your filename)

In the SS-DB-Backup folder unzip your most recent SSdb savefile. For this example we'll use file name local-SS.SSdb

Enter the following command to load the models only save from step above on top of the new catalog

   ../SS-Tools/SSdbload -m ../SS-DB-Backup/local-SS.SSdb

 

Start the Spectroserver

 

Additional Information

To stop and start the Spectroserver
AS the spectrum install owner
$SPECROOT/bin/startSS.pl
$SPECROOT/bin/stopSS.pl