Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Entity Info (Diagnostic) is spamming the DB #2320

Open
auanasgheps opened this issue Jan 21, 2025 · 2 comments
Open

Entity Info (Diagnostic) is spamming the DB #2320

auanasgheps opened this issue Jan 21, 2025 · 2 comments
Labels
FAQ Frequently Asked Questions

Comments

@auanasgheps
Copy link

auanasgheps commented Jan 21, 2025

I noticed that my Home Assistant DB almost tripled in size.

Image

After some troubleshooting, I found out that a new MioT entity called Info stores a lot of data and is spamming the DB.

Image

By looking at the changelog, the Info Entity was added in 1.0.0.. So in about a month and half it has become the biggest entity so far.

This entity should be at least disabled by default, and in my opinion requires additional work to avoid this kind of issues.

Image

Home Assistant: 2025.1.3
Xiaomi Miot Auto: 1.0.8

This is not a device specific issue. I have a friend with the same exact issue, for a different Vacuum and a Humidifier, with the same versions as mine:

Image

If you have this issue, here's how to fix this:

  • Disable the Info entity
  • Go to Developer Tools > Actions
  • Select Action "Recorder: Purge Entities"
    • Enable "Entities to Remove" and enter the entity ID
    • Select 0 days in "Days to keep"
    • Click on Perform Action

You can wait for the automated nightly purge or run it manually:

  • Select Action "Recorder: Purge"
    • Enable "Days to keep" and choose how many to keep, I recommend 14
    • Enable Repack
    • Click on Perform Action
  • Your DB will go back to an acceptable size.
@al-one
Copy link
Owner

al-one commented Jan 23, 2025

You can also avoid this problem by adding the following configuration.

# configuration.yaml
# https://www.home-assistant.io/integrations/recorder
recorder:
  exclude:
    entity_globs:
      - button.*_info

@al-one al-one added the FAQ Frequently Asked Questions label Jan 23, 2025
@auanasgheps
Copy link
Author

The problem should be avoided in the first place. Are you planning to disable this entity by default or other actions?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
FAQ Frequently Asked Questions
Projects
None yet
Development

No branches or pull requests

2 participants