missing_entities exceed maximum size of 16384 bytes

[pickonedev]

Hi!

Anyone knows about this problem? I get more than 1500 warnings per day in the log, about this... Any solution?

State attributes for sensor.watchman_missing_entities exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored

[swa72]

Yep, same here. Latest version 2023.4.1

[alexruffell]

While this doesn't fix the issue, I told recorder not to include watchman sensors as I only use it by looking at the file it outputs so the sensors are not useful to me

configuration.yaml

recorder:
  exclude:
    entity_globs: 
      - sensor.watchman*

[otiswrx]

I am also seeing this frequently in my logs. Will try the exclude option and see if that clears the warning.

[pickonedev]

  exclude:
    entity_globs:
      - sensor.watchman*

indeed solves the problem, like alex said.

[thargy]

Alternatively, less drastic is:

# Don't include watchman results in recorder as they're too big!
recorder:
  exclude:
    entities:
      - sensor.watchman_missing_entities
      - sensor.watchman_missing_services

Which leaves sensor.watchman_last_updated in the recorder, which is potentially helpful and does not grow out of control.

[ildar170975]

I excluded all watchman entities from Recorder, no need at all. These data are for "create a report -> analyse -> do smth" , not for keeping in History.

[dummylabs]

This data is only necessary to render a fancy UI markdown card, will add the solution on how to exclude it from the recordewr to the Readme. Another option I would consider is to provide the ability to disable it via UI settings for those who are not using UI card.