InsightIQ: Historical Metric Data May Be Missing After Upgrade or Migration to 6.0.1

This issue can occur during:

• Offline migrations from InsightIQ 4.4 
  or
• In place upgrades from InsightIQ 5.2

After completing the upgrade or migration, the following may be observed:

• Certain or all historical InsighIQ metrics not appearing
• Unexpected gaps in long-term reporting
• Graphs showing incomplete or missing historical data ranges

Current data ingestion functions normally and does not impact cluster performance. The patch prevents this condition when applied prior to completing the migration.

During the migration process, the Reporting Data Processor may initiate a broad TimescaleDB continuous aggregate (CAGG) refresh from epoch 0 to present time. 

This occurs because the internal timing metadata contains pending / older rows.

In this state, the database's native refresh logic may remove previously generated historical aggregates if the corresponding raw inputs are no longer retained. 

This condition only occurs when the internal timing metadata is outdated. 

A patch is available that updates the Reporting Data Processor container image and safeguards historical datasets during the migration.

Download

Filename: insightiq601-downsample-patchv7.tar.gz

Installation Instructions

These steps may be performed before or during an ongoing migration. The patch does not interrupt or restart the migration process.

Upload the patch to the following the directory

/home/administrator

Once the patch has been uploaded the following commands will install it within the IIQ instance

cd /home/administrator
tar xvf insightiq601-downsample-patchv7.tar.gz
cd insightiq601-downsample-patchv7
./main.sh

Verify successful deployment of the script. You should see reporting-dataprocessor:v601-pv7

sudo docker ps

If historical metrics appear missing after the upgrade: 

• Confirm whether the patch was applied prior to migration
• If it was not applied and the unavailable data is required, Support can evaluate possible recovery options based on what remains in the environment.