Statistics Graphs card stuck on "Loading statistics..."

[timoschwarzer]

The problem

I recently added a Statistics Graph card to my dashboard. Unfortunately, it is stuck on "Loading statistics..." since then and the same error message as described in #89489 appears in the log every time I have the dashboard open.

What version of Home Assistant Core has the issue?

core-2023.8.3

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant Container

Integration causing the issue

No response

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

type: vertical-stack
cards:
  - type: entity
    entity: sensor.power_meter_total
    name: Power
  - chart_type: line
    period: hour
    type: statistics-graph
    entities:
      - sensor.power_meter_total
    hide_legend: true
    stat_types:
      - sum
      - state
    days_to_show: 30

Anything in the logs that might be useful for us?

homeassistant-homeassistant-1  | 2023-08-21 08:53:47.552 ERROR (MainThread) [homeassistant.components.websocket_api.http.connection] [140152766191936] Error handling message: Unknown error (unknown_error) [redacted] from [redacted] (Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36)
homeassistant-homeassistant-1  | Traceback (most recent call last):
homeassistant-homeassistant-1  |   File "/usr/src/homeassistant/homeassistant/components/websocket_api/connection.py", line 206, in async_handle
homeassistant-homeassistant-1  |     handler(self.hass, self, schema(msg))
homeassistant-homeassistant-1  |                              ^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 272, in __call__
homeassistant-homeassistant-1  |     return self._compiled([], data)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 595, in validate_dict
homeassistant-homeassistant-1  |     return base_validate(path, iteritems(data), out)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 387, in validate_mapping
homeassistant-homeassistant-1  |     cval = cvalue(key_path, value)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 818, in validate_callable
homeassistant-homeassistant-1  |     return schema(data)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 272, in __call__
homeassistant-homeassistant-1  |     return self._compiled([], data)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 595, in validate_dict
homeassistant-homeassistant-1  |     return base_validate(path, iteritems(data), out)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 387, in validate_mapping
homeassistant-homeassistant-1  |     cval = cvalue(key_path, value)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/schema_builder.py", line 818, in validate_callable
homeassistant-homeassistant-1  |     return schema(data)
homeassistant-homeassistant-1  |            ^^^^^^^^^^^^
homeassistant-homeassistant-1  |   File "/usr/local/lib/python3.11/site-packages/voluptuous/validators.py", line 755, in __call__
homeassistant-homeassistant-1  |     or 'value must be one of {}'.format(sorted(self.container)))
homeassistant-homeassistant-1  |                                         ^^^^^^^^^^^^^^^^^^^^^^
homeassistant-homeassistant-1  | TypeError: '<' not supported between instances of 'str' and 'NoneType'

Additional information

No response

[inkpw2]

Did you find a solution? I am having the same problem. It is also impacting other cards like apex charts and mini graph chart

[timoschwarzer]

@inkpw2 I ended up deleting all long-term stats from the database directly. So far, it seems it works again so I suspect at some point HA wrote something to the DB that it wasn't happy with anymore in a later version.

I don't know what exactly caused this though.

[inkpw2]

@inkpw2 I ended up deleting all long-term stats from the database directly. So far, it seems it works again so I suspect at some point HA wrote something to the DB that it wasn't happy with anymore in a later version.

I don't know what exactly caused this though.

Sorry for my ignorance, but how do you do that? I run HAOS

[timoschwarzer]

@inkpw2 you need to edit the Home Assistant database directly. https://www.home-assistant.io/docs/backend/database/

I don't use HAOS, so I can't give you accurate instructions on how to do that there.

[thoutenbos]

Any updates?
I have the same with an entity in 2023.10.0

Checked all the entries in states but nothing out of the ordinary.
Is there any other place where stats are persistent?

[home-assistant]

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

Code owner commands

Code owners of frontend 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 frontend Removes the current integration label and assignees on the issue, add the integration domain after the command.

_{^{(message by CodeOwnersMention)}}

---

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

[issue-triage-workflows]

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.