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

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

book

Article ID: 292312

calendar_today

Updated On:

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