Rebuild Archive Index Issue

Rebuild Archive Index Issue

-----------------------------------

Affected Roles:  Owner, Administrator

Related Digital Watchdog VMS Apps:  DW Spectrum® IPVMS

Complexity:  Medium to High

Last Edit:  July 9, 2021

-----------------------------------

Rebuild Archive Index Issue

If you have recently run the Rebuild Archive Index function and have noticed that the rebuilding process is experiencing issues or that it has completed, but you do not see the previously recorded footage available to view on the Timeline, then it is likely that the archive may have a corrupted database.

This article will outline how to restore archives from a corrupted database, following the failure of the Rebuild Archive Index function.

Supported/Affected Devices

• DW Blackjack® Bolt Series
• DW Blackjack® Cube Series
• DW Blackjack® P-Rack Series
• DW Blackjack® E-Rack Series

Storage Management

Before attempting to restore the archive files, perform the following:

• Make sure that the archive files and directories have not been moved or renamed.  Any changes in an active directory that DW Spectrum is writing to, without matching changes in the Storage Settings of the Server, will cause an error.
• Make sure that there is sufficient Reserved Space for the storage drives.  There is an increased likelihood for a corrupted database when drive storage is beyond capacity.  To learn more about how to view or adjust the Reserved Space settings, please read Adjust Reserved Disk Space.

Restoring Archives

**NOTE:  This process is for Servers that are using DW Spectrum v2.6 – Build 13867 (or newer).  If you are using an older version than this, you will not be able to perform this process until the current version is updated.

1. Stop the DW Spectrum Server.

• Windows:  Locate the DW Spectrum Tray Tool (typically located in the lower right-hand side of the Windows Task Bar or searchable from the Start Menu).

Right-click on the DW Spectrum Tray Tool, then select Stop Server.

• Linux:  Open the Terminal tool (shortcut:  CTRL+ALT+T), then use the command:

2.  Remove the corrupted database.

• Windows:  Navigate to the directory of the affected archives.

Locate and delete the file ending in _media.sqlite.

Example location:  C:/DW Spectrum Media

• Linux:  Navigate to each directory of the affected archives.

Locate and delete the file ending in “_media.sqlite”.

Example location:  /opt/digitalwatchdog/mediaserver/var

• NAS:  If you are restoring a NAS device, the database files will be stored in:

/opt/dwspectrum/mediaserver/var/storage_db/<storage directory>

3. After removing the _media.sqlite files, Start te DW Spectrum Server.

• Windows:  Locate the DW Spectrum Tray Tool (typically located in the lower right-hand side of the Windows Task Bar or searchable from the Start Menu).

Right-click on the DW Spectrum Tray Tool, then select Start Server.

• Linux:  Open the Terminal tool (shortcut:  CTRL+ALT+T), then use the following command:

4. Launch the DW Spectrum Client and log in as a user with either the Owner or with an Administrator role.

Right-click on the Server in the Resource Tree, then navigate Server Settings > Storage Management

Select Rebuild Archive Index.

Completing the Process

During the archive rebuild process, the Server will continue to record and archive footage normally.

Once the rebuild is complete, the Server will be operating on a clean archive database and recorded video should be available for playback in the Timeline again.

**NOTE:  The rebuild process may take a significant amount of time, depending on the overall size of the archive.