I am afraid not. I have restarted and even rebooted several times today while trying to get my energy dashboard and graphs to work again, so my earliest logs are from 14:00 today.
Since the recorder freezes at 04:00 and then works again after a reboot/restart my logs don’t have anything yet.
And since I now disabled the purge temporarily I doubt I will have any issues, but I will report back here tomorrow of the issues show up again.
If you want you can force a recorder purge by running:
service: recorder.purge
data:
repack: false
apply_filter: false
So you don’t have to wait until tomorrow morning 4:10.
1 Like
Look here for more information about auto_purge.
auto_purge boolean (Optional, default: true)
Automatically purge the database every night at 04:12 local time. Purging keeps the database from growing indefinitely, which takes up disk space and can make Home Assistant slow. If you disable
auto_purgeit is recommended that you create an automation to call therecorder.purgeperiodically.
All that doesn’t really explain why the Recorder Purge suddenly stalls since 2024.7 when it was just quietly doing it’s thing for years before that…
2 Likes
iCloud 3 is offending integration for me. Have now disabled until resolved.
But that’s my issue…I have none of those integrations and have never used them.
I also don’t have (as far as I am aware) anything that “messes” with the Recorder.
2 Likes
Does your system have any custom integrations installed?
If it does, please list them.
If it doesn’t then your system may have a unique problem.
Oh I have a pretty long list of custom integrations, just nothing that should interfere with the Recorder.
I honestly don’t know how to extract a list of custom integration ls from HA and paste it here…and looking them all up and typing them here would be…time consuming.
What leads you to that conclusion?
- None of them are mentioned in the many, many threads about this issue
- None of them need to mess with the recorder
- I can’t find anything in the logs
My overall conclusion thus far is, that I “simply” have a corrupted Database Index. Why this is suddenly an issue now, but never was before is what really puzzles me. I guess some changes were made to the recorder in 2024.7 and now suddenly loads of people run into this issue?
1 Like
I don’t have a single custom integration installed and have had no problems with the latest release.
What’s really strange is that I have two identical Home Assistant instances running on two different computers and only one of them has this issue, the other one works just fine. All the custom integrations are the same (none of them is listed on the first post), sensors and entities are the same, even dashboards are identical. They have been restored from the same backup. Only differences are the actual hardware running the system (both are x86) and one of them has all automations and Nabu Casa disabled and doesn’t do a backup every night. That’s the system that works.
edit: My bad, I just realized that only the system that doesn’t work with 2024.7 has years of sensor data history recorded. I have this on configuration.yaml on both instances:
recorder:
purge_keep_days: 365
Why on earth do you find it so hard to help people out by listing your custom integrations? Don’t come here and moan without being prepared to help.
1 Like
No wonder you are having performance issues. There’s a reason the default is set to 10 days.
I also have the problem. Can’t see that I’m running any of the mentioned integrations. Don’t really know how to list integrations, I guess this screen dump might suffice.
Anyway, since the issue forces me to restart Home assistant every day, I of course have the full, not very long logs. Also, most of the logs are non-responding esphome things.
Here is home-assistant.log
2024-07-06 04:35:55.109 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-07-06 04:35:55.160 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=229 from 2024-07-05 20:38:04.861285)
2024-07-06 04:36:03.886 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.lightpi_tsl2591_actual_gain (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'None' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-06 04:36:09.228 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for everything-presence-one-fa2d4c @ 192.168.2.203: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.203', port=6053))]: [Errno 113] Connect call failed ('192.168.2.203', 6053) (SocketAPIError)
2024-07-06 04:36:09.230 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for shelley-plus-2pm-1 @ 192.168.2.176: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.176', port=6053))]: [Errno 113] Connect call failed ('192.168.2.176', 6053) (SocketAPIError)
2024-07-06 04:36:09.525 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_utetemp (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-06 04:36:11.063 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_dorrklocka (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-06 04:36:11.233 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_elmatare (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-06 04:36:11.979 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.rorelsedetektor_vardagsrum_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.980 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sangknapp_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.986 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hue_fjarr_1_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.987 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.ikea_tradfri_motion_sensor_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.988 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hue_motion_sensor_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.988 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.klimat_kok_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.990 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hallelement_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.992 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.element_vardagsrum_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.993 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.dorrsensor_toa_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.993 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sonoff_snzb_03_toa_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:11.994 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sonoff_snzb_03_hall_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-06 04:36:12.833 WARNING (MainThread) [homeassistant.components.homeassistant.triggers.numeric_state] Error initializing 'Luftrenare' trigger: In 'numeric_state' condition: unknown entity sensor.ikea_vindriktning_particulate_matter
2024-07-06 04:36:15.246 WARNING (MainThread) [homeassistant.components.kodi.media_player] Unable to connect to Kodi via websocket
2024-07-06 08:27:31.526 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
2024-07-06 09:36:09.960 WARNING (MainThread) [homeassistant.components.esphome.manager] Error getting setting up connection for 192.168.2.154: Timeout waiting for ListEntitiesDoneResponse, ListEntitiesAlarmControlPanelResponse, ListEntitiesBinarySensorResponse, ListEntitiesButtonResponse, ListEntitiesCameraResponse, ListEntitiesClimateResponse, ListEntitiesCoverResponse, ListEntitiesDateResponse, ListEntitiesDateTimeResponse, ListEntitiesEventResponse, ListEntitiesFanResponse, ListEntitiesLightResponse, ListEntitiesLockResponse, ListEntitiesMediaPlayerResponse, ListEntitiesNumberResponse, ListEntitiesSelectResponse, ListEntitiesSensorResponse, ListEntitiesServicesResponse, ListEntitiesSirenResponse, ListEntitiesSwitchResponse, ListEntitiesTextResponse, ListEntitiesTextSensorResponse, ListEntitiesTimeResponse, ListEntitiesUpdateResponse, ListEntitiesValveResponse after 60s
2024-07-06 09:36:19.963 ERROR (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: disconnect request failed: Timeout waiting for DisconnectResponse after 10.0s
2024-07-06 09:38:06.899 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 09:43:41.332 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 09:46:06.407 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 10:34:24.833 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 10:54:08.558 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
2024-07-06 10:54:41.304 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for ellevio @ 192.168.2.154: Handshake timed out after 30.0s (TimeoutAPIError)
2024-07-06 10:54:41.305 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 10:56:24.940 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
2024-07-06 11:02:18.193 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 11:20:38.200 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from localhost (127.0.0.1). Requested URL: '/api/websocket'. (Home Assistant/2024.6.1-12936 (Android 14; Pixel 7a))
2024-07-06 18:19:11.909 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 18:40:41.540 WARNING (MainThread) [homeassistant.components.http.ban] Login attempt or request with invalid authentication from localhost (127.0.0.1). Requested URL: '/auth/token'. (Home Assistant/2024.3.5-12540 (Android 13; Nokia T20))
2024-07-06 18:41:01.548 WARNING (MainThread) [homeassistant.components.websocket_api.http.connection] [547539029728] from 127.0.0.1 (Home Assistant/2024.3.5-12540 (Android 13; Nokia T20)): Disconnected: Did not receive auth message within 10 seconds
2024-07-06 18:47:16.796 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
2024-07-06 18:49:42.195 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 19:19:06.351 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
2024-07-06 19:28:43.695 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 19:31:15.242 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 20:50:47.012 WARNING (MainThread) [bluetooth_auto_recovery.recover] Could not reset the power state of the Bluetooth adapter hci0 [E4:5F:01:46:33:C4] due to timeout after 5 seconds
2024-07-06 20:50:49.536 WARNING (MainThread) [bluetooth_auto_recovery.recover] Could not cycle the Bluetooth adapter hci0 [E4:5F:01:46:33:C4]: [Errno 110] Operation timed out
2024-07-06 20:50:54.538 WARNING (MainThread) [bluetooth_auto_recovery.recover] Could not reset the power state of the Bluetooth adapter hci0 [E4:5F:01:46:33:C4] due to timeout after 5 seconds
2024-07-06 20:50:54.552 WARNING (MainThread) [habluetooth.scanner] hci0 (E4:5F:01:46:33:C4): Successful fall-back to passive scanning mode after active scanning failed (4/4)
2024-07-06 20:52:36.960 WARNING (MainThread) [bluetooth_auto_recovery.recover] Bluetooth adapter hci0 [E4:5F:01:46:33:C4] successfully turned back ON
2024-07-06 21:20:28.724 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 21:22:43.276 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 21:22:46.332 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for ellevio @ 192.168.2.154: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.154', port=6053))]: [Errno 113] Connect call failed ('192.168.2.154', 6053) (SocketAPIError)
2024-07-06 21:23:25.466 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:24:02.618 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:25:50.779 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:26:40.826 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:28:47.903 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:32:20.590 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 21:33:32.908 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-06 21:39:25.580 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: Ping response not received after 90.0 seconds
2024-07-06 21:40:26.112 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for ellevio @ 192.168.2.154: Timeout while connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.154', port=6053))] (TimeoutAPIError)
2024-07-06 21:41:08.060 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:43:04.891 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:43:47.510 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:46:10.635 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:47:40.653 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:49:10.668 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:50:41.704 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 21:52:13.759 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: Connection lost
2024-07-06 23:51:18.037 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: [Errno 104] Connection reset by peer
And this is my home-assistant.log.1:
2024-07-05 22:38:22.951 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.lightpi_tsl2591_actual_gain (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'None' which is not a valid unit for the device class ('illuminance') it is using; expected one of ['lx']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-05 22:38:26.986 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for everything-presence-one-fa2d4c @ 192.168.2.203: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.203', port=6053))]: [Errno 113] Connect call failed ('192.168.2.203', 6053) (SocketAPIError)
2024-07-05 22:38:26.988 WARNING (MainThread) [aioesphomeapi.reconnect_logic] Can't connect to ESPHome API for shelley-plus-2pm-1 @ 192.168.2.176: Error connecting to [AddrInfo(family=<AddressFamily.AF_INET: 2>, type=<SocketKind.SOCK_STREAM: 1>, proto=6, sockaddr=IPv4Sockaddr(address='192.168.2.176', port=6053))]: [Errno 113] Connect call failed ('192.168.2.176', 6053) (SocketAPIError)
2024-07-05 22:38:27.451 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_utetemp (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-05 22:38:27.472 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_dorrklocka (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-05 22:38:28.655 WARNING (MainThread) [homeassistant.components.sensor] Entity sensor.wifi_signal_procent_elmatare (<class 'homeassistant.components.esphome.sensor.EsphomeSensor'>) is using native unit of measurement 'Signal %' which is not a valid unit for the device class ('signal_strength') it is using; expected one of ['dB', 'dBm']; Please update your configuration if your entity is manually configured, otherwise create a bug report at https://github.com/home-assistant/core/issues?q=is%3Aopen+is%3Aissue+label%3A%22integration%3A+esphome%22
2024-07-05 22:38:29.381 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.rorelsedetektor_vardagsrum_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.381 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sangknapp_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.387 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hue_fjarr_1_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.388 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.ikea_tradfri_motion_sensor_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.389 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hue_motion_sensor_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.389 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.klimat_kok_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.391 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.hallelement_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.393 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.element_vardagsrum_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.394 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.dorrsensor_toa_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.396 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sonoff_snzb_03_toa_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:29.397 WARNING (MainThread) [homeassistant.components.group.sensor] Unable to use state. Only numerical states are supported, entity sensor.sonoff_snzb_03_hall_battery with value unavailable excluded from calculation in sensor.zigbee_batterier
2024-07-05 22:38:30.824 WARNING (MainThread) [homeassistant.components.homeassistant.triggers.numeric_state] Error initializing 'Luftrenare' trigger: In 'numeric_state' condition: unknown entity sensor.ikea_vindriktning_particulate_matter
2024-07-05 22:38:33.664 WARNING (MainThread) [homeassistant.components.kodi.media_player] Unable to connect to Kodi via websocket
2024-07-05 23:47:38.375 WARNING (MainThread) [aioesphomeapi.connection] ellevio @ 192.168.2.154: Connection error occurred: ellevio @ 192.168.2.154: EOF received
2024-07-05 23:56:16.399 WARNING (MainThread) [homeassistant.components.automation.soffkub] Soffkub: Already running
2024-07-05 23:57:26.456 WARNING (MainThread) [homeassistant.components.automation.soffkub] Soffkub: Already running
2024-07-05 23:57:47.007 WARNING (MainThread) [homeassistant.components.automation.soffkub] Soffkub: Already running
2024-07-06 04:34:37.611 WARNING (MainThread) [homeassistant.helpers.script] Stopping scripts running too long after shutdown: Wake up light
2024-07-06 04:34:40.785 WARNING (MainThread) [homeassistant.core] Timed out waiting for final writes to complete, the shutdown will continue
2024-07-06 04:34:40.785 WARNING (MainThread) [homeassistant.core] Shutdown stage 'final write': still running: <Task pending name='Task-147210' coro=<Recorder._async_shutdown() running at /usr/src/homeassistant/homeassistant/components/recorder/core.py:480> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, <1 more>, Task.task_wakeup()]> cb=[set.remove()]>
2024-07-06 04:35:10.813 WARNING (MainThread) [homeassistant.core] Timed out waiting for close event to be processed, the shutdown will continue
2024-07-06 04:35:10.813 WARNING (MainThread) [homeassistant.core] Shutdown stage 'close': still running: <Task pending name='Task-147577' coro=<Recorder._async_close() running at /usr/src/homeassistant/homeassistant/components/recorder/core.py:472> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, <1 more>, Task.task_wakeup()]> cb=[set.remove()]>
2024-07-06 04:35:10.814 WARNING (MainThread) [homeassistant.core] Shutdown stage 'close': still running: <Task pending name='Task-147210' coro=<Recorder._async_shutdown() running at /usr/src/homeassistant/homeassistant/components/recorder/core.py:480> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, <1 more>, Task.task_wakeup()]> cb=[set.remove()]>
2024-07-06 04:35:10.847 WARNING (Thread-2 (_do_shutdown)) [homeassistant.util.executor] Thread[SyncWorker_54] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:10.864 WARNING (Thread-2 (_do_shutdown)) [homeassistant.util.executor] Thread[SyncWorker_36] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:11.363 WARNING (Thread-2 (_do_shutdown)) [homeassistant.util.executor] Thread[SyncWorker_54] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:11.862 WARNING (Thread-2 (_do_shutdown)) [homeassistant.util.executor] Thread[SyncWorker_36] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:20.835 WARNING (MainThread) [homeassistant.util.executor] Thread[SyncWorker_54] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:20.852 WARNING (MainThread) [homeassistant.util.executor] Thread[SyncWorker_36] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:21.352 WARNING (MainThread) [homeassistant.util.executor] Thread[SyncWorker_54] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
2024-07-06 04:35:21.851 WARNING (MainThread) [homeassistant.util.executor] Thread[SyncWorker_36] is still running at shutdown: File "/usr/local/lib/python3.12/threading.py", line 1030, in _bootstrap
self._bootstrap_inner()
File "/usr/local/lib/python3.12/threading.py", line 1073, in _bootstrap_inner
self.run()
File "/usr/local/lib/python3.12/threading.py", line 1010, in run
self._target(*self._args, **self._kwargs)
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 92, in _worker
work_item.run()
File "/usr/local/lib/python3.12/concurrent/futures/thread.py", line 58, in run
result = self.fn(*self.args, **self.kwargs)
File "/usr/local/lib/python3.12/threading.py", line 1147, in join
self._wait_for_tstate_lock()
File "/usr/local/lib/python3.12/threading.py", line 1167, in _wait_for_tstate_lock
if lock.acquire(block, timeout):
1 Like
How big is your recorder database?
You also have a bunch of misconfigured devices and groups you should fix.
1.8 GB, it seems. And sure, things are misconfigured, but the auto-purge still worked fine until I upgraded to 2024.7.
core-ssh config]$ ls -lh home-assistant_v2.db
-rw-r--r-- 1 root root 1.8G Jul 7 02:00 home-assistant_v2.db
1 Like
Okay, that’s not huge.
Try disabling this script: Wake up light and restart.
Nope, disabling Wake up light ddin’t fix the issue.