Recorder & logbook does not filter entities

[xraver]

The problem

in my configuration I've excluded several sensors, device_trackers etc. to be recorded in both recorder and logger integration. it was working properly up to 2024.02.5. after upgrading it to 2024.03.0 I can see in the logbook and in the recorder history all of them. reverting back to 2024.02.5 and removing homeassistant_v2.db the filter works back.

What version of Home Assistant Core has the issue?

2024.03.0

What was the last working version of Home Assistant Core?

2024.02.5

What type of installation are you running?

Home Assistant OS

Integration causing the issue

recorder

Link to integration documentation on our website

https://www.home-assistant.io/integrations/recorder/

Diagnostics information

No response

Example YAML snippet

exclude:
  entities:
    # Device Trackers
    - device_tracker.giorgio_s21
    - device_tracker.giorgio_tab_s8
    - device_tracker.lalaura_s_phone
    # Time & Date
    - sensor.date
    - sensor.time
    - sensor.time_date
    # Sun & Weather
    - sun.sun
    # Hacs
    - sensor.hacs

Anything in the logs that might be useful for us?

No response

Additional information

No response

[home-assistant[bot]]

Hey there @home-assistant/core, mind taking a look at this issue as it has been labeled with an integration (recorder) you are listed as a code owner for? Thanks!

Code owner commands

Code owners of `recorder` can trigger bot actions by commenting: - `@home-assistant close` Closes the issue. - `@home-assistant rename Awesome new title` Renames the issue. - `@home-assistant reopen` Reopen the issue. - `@home-assistant unassign recorder` Removes the current integration label and assignees on the issue, add the integration domain after the command. - `@home-assistant add-label needs-more-information` Add a label (needs-more-information, problem in dependency, problem in custom component) to the issue. - `@home-assistant remove-label needs-more-information` Remove a label (needs-more-information, problem in dependency, problem in custom component) on the issue.

_{^{(message by CodeOwnersMention)}}

---

recorder documentation recorder source _{^{(message by IssueLinks)}}

[draxaris1010]

I have the same issue on supervised. My db is a mariadb. If an entity is not present in the table states_meta, then its state is not recorded.

[issue-triage-workflows[bot]]

There hasn't been any activity on this issue recently. Due to the high number of incoming GitHub notifications, we have to clean some of the old issues, as many of them have already been resolved with the latest updates. Please make sure to update to the latest Home Assistant version and check if that solves the issue. Let us know if that works for you by adding a comment 👍 This issue has now been marked as stale and will be closed if no further activity occurs. Thank you for your contributions.