Server will not start after upgrade with error from sensor_stats querying missing ID in sensor_registrations

Products

• Carbon Black EDR (formerly Cb Response)

Issue/Introduction

• journalctl -fexu cb-enterprise and /var/log/messages shows errors related to key constraint when inserting into sensor_status 

• DETAIL: Key (sensor_id)=(XXXX) is not present in table "sensor_registrations".

• Server cannot start up after upgrade

Environment

• EDR Server: 7.5

Cause

An indexing issue with sensor_registrations

Resolution

1. Vacuum sensor_registrations table.
   
   • Only needs to be run against sensor_registrations
2. Start services