search

home-assistant / core

:house_with_garden: Open source home automation that puts local control and privacy first.
https://www.home-assistant.io
Apache License 2.0
73.67k stars 30.81k forks source link

Energy Dashboard gap for Time Change #129250

Open MiguelAngelLV opened 2 weeks ago

MiguelAngelLV commented 2 weeks ago

The problem

Today, the time change took place in much of Europe, which caused us to have '2:00 twice.'

As expected, in the Energy Panel, 2:00 is shown twice (good!), however, the second slot appears empty, and all consumption is shown at 3:00.

In general, it’s not a big issue, but perhaps it would be a good idea to review it.

image

What version of Home Assistant Core has the issue?

2024.10.4

What was the last working version of Home Assistant Core?

No response

What type of installation are you running?

Home Assistant OS

Integration causing the issue

Energy Dashboard

Link to integration documentation on our website

https://www.home-assistant.io/home-energy-management/

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

No response

Additional information

No response

brxxm commented 2 weeks ago

It's working correct for me on the default energy dashboard.

Schermafbeelding 2024-10-27 om 09 27 11
ERBN19 commented 2 weeks ago

I noticed the same problem but a little bit different.

I am running 2 homeassistant systems for 2 locations. 1 of the 2 locations stops totally which is not good.

Location 1 In the log files I read the following:

2024-10-27 02:57:47.022 ERROR (MainThread) [homeassistant.components.recorder.core] The recorder backlog queue reached the maximum size of 819059 events; usually, the system is CPU bound, I/O bound, or the database is corrupt due to a disk problem; The recorder will stop recording events to avoid running out of memory
2024-10-27 02:58:18.829 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly
2024-10-27 02:58:18.872 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=276 from 2024-10-27 01:36:48.636960)

The energy dashboard of this location location 1

Here also the double 2:00, and the system performing good.

Location 2 (stopped) In the log files I read the following:

2024-10-27 02:54:01.756 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly
2024-10-27 02:54:01.775 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=200 from 2024-10-27 01:39:22.055981)

The energy dashboard of this location, notice it completly stopped. location 2

Now I have checked if the DSMR has a problem, but this integration is reporting data but the data is not stored in the database. location 2 verbruik Also checked this for other integrations, all reporting data, but it is not stored.

The recorder problem is solved by a full reboot of the system, but the data is a little bit messy. location 2-1

So it is a bug or problem with the recorder?