Upgrade to Server Version 8.10.2 + Takes Long Time To Complete

Products

• Carbon Black App Control (formerly Cb Protection)

Issue/Introduction

During server upgrade the step Executing 'migrate'. Please wait... seems stuck, but the time elapsed continues to count up.

Environment

• App Control Server: 8.10.2

Cause

Upgrades coming from 8.10.0 and below to 8.10.2+ requires a table restructure during the upgrade process. This causes a longer than usual upgrade time.

EP-19460: Changed how we store yara tags associated with file instances to improve query performance and to significantly reduce disk storage usage.

Resolution

This is expected when upgrading to 8.10.2+.  Upgrade time is highly variable and is dependent on the number of antibody instances, the count of yara tags, and the SQL resources.

Additional Information

• The "What's Running Now" script can be used to monitor the Individual Query changes and overall duration of this step. The Status column showing "Suspended" is not a cause for concern.
  • Run the "What's Running Now" SQL Script
• Delaying the upgrade will potentially increase the time it takes to complete due to additional Yara tag and file associations.
• Some customers have reported upgrade times ranging from 1 hour to as extreme as 30 hours.