EDR: Duplicate Key Value Violates Unique "constra_sensorbuild_version_and_architecture"

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

When running /usr/share/cb/cbcheck sensor-builds --update, an error similar to below is seen

sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constra_sensorbuild_version_and_architecture"
DETAIL: Key (version_string, architecture)=(007.000.001.16744, 32) already exists.

 

Environment

• EDR Server: All Versions

Cause

The utility is trying to insert a second sensor package that already exists. 

Resolution

Restart the EDR Services will correct this error and ingest the new sensor package as expected
EDR: How to Restart Server Services