EDR: Duplicate Key Value Violates Unique "constra_sensorbuild_version_and_architecture"

[#1]

Environment

• EDR Server: All Versions

Symptoms

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.

 

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