Database corruption error during post install of Spectrum

Products

• Spectrum

Issue/Introduction

During post-install on a Spectrum upgrade, the installation stopped with a corrupt db error in the post install log:

Migration file dbsavefile.SSdb was not found or is not readable.
Backing up catalog and models to db_20181120,1.SSdb ERROR:
This application has been started using a Spectrum database which was not gracefully closed.
The application will now shut down to allow you to load and initialize a previously-saved good database.
SPC-DBS-20095: SSdbsave Error: Unable to open database.
** Error during backup to db_20181120,1.SSdb <user>@xxxxxx

Environment

Release: Any
Component: SPCCSS

Resolution

If this is a VM and a snapshot was taken before running the upgrade:

1. Reload the snapshot image

2. Ensure there are no issues with the SpectroSERVER database by starting the SpectroSERVER and ensuring it activates 100%. 

3. If the SpectroSERVER fails to activate, reinitialize with a recent database save and retest.

4. After verifying the SpectroSERVER database is good, shutdown the Spectrum processes and rerun the upgrade.

If this is not a VM or if it is a VM but there is no snapshot from before running the upgrade:

1. Remove the *.ix and *.db files from the $SPECROOT/SS directory

2. Locate a recent SSdb database save from the previous version

    a. If compressed, uncompress the SSdb database save file

    b. Rename the uncompressed SSdb database save file to dbsavefile.SSdb

    c. Copy the dbsavefile.SSdb file to the $SPECROOT/SS directory

    d. Run the upgrade

The Spectrum installation process looks for a file named dbsavefile.SSdb in the $SPECROOT/SS directory and if found, will run a migration of that database.

Reference the "Migrating and Upgrading" section of the documentation for more information on using the dbsavefile.SSdb