statistics blocks Home Assistant from wrapping up the start up phase

[Juffle74]

The problem

After 2024.8.0 update, in log:

Something is blocking Home Assistant from wrapping up the start up phase. We're going to continue anyway. Please report the following info...

What version of Home Assistant Core has the issue?

2024.8.0

What was the last working version of Home Assistant Core?

2024.7.4

What type of installation are you running?

Home Assistant OS

Integration causing the issue

No response

Link to integration documentation on our website

No response

Diagnostics information

No response

Example YAML snippet

No response

Anything in the logs that might be useful for us?

Enregistreur: homeassistant.core
Source: core.py:552
S'est produit pour la première fois: 19:34:41 (1 occurrences)
Dernier enregistrement: 19:34:41

Something is blocking Home Assistant from wrapping up the start up phase. We're going to continue anyway. Please report the following info at https://github.com/home-assistant/core/issues: wled.light, shelly.update, tuya.scene, logger, matter, tradfri, hue.binary_sensor, hassio.sensor, scene, matter.lock, co2signal, network, mobile_app.sensor, shelly.button, intent, statistics.sensor, tuya.sensor, group.binary_sensor, environment_canada, logbook, webostv, search, input_number, ping.binary_sensor, environment_canada.weather, homekit_controller.button, timer, template.fan, mobile_app, hacs, hacs.sensor, tradfri.light, backup, person, matter.fan, tuya.fan, scrape.sensor, onboarding, matter.switch, tplink.switch, esphome.sensor, midea_ac_lan.light, midea_ac_lan, nest.climate, broadlink, blueprint, hardkernel, hassio.binary_sensor, tplink.binary_sensor, switch, tuya.button, frontend, tplink.light, wled.sensor, midea_ac_lan.sensor, vacuum, upnp.sensor, esphome.button, homekit_controller, dhcp, mqtt.binary_sensor, system_health, event, valve, system_log, esphome, broadlink.sensor, mqtt, midea_ac_lan.fan, mqtt.switch, group.switch, upnp.binary_sensor, speedtestdotnet.sensor, tuya, energy, nut, waqi, hue.scene, template.sensor, config, http, alarm_control_panel, tradfri.sensor, water_heater, oralb.sensor, hassio, stt, shelly.binary_sensor, wake_word, number, nanoleaf, media_player, tuya.climate, homeassistant_alerts, tuya.select, tplink.number, midea_ac_lan.number, mobile_app.binary_sensor, media_source, hue.event, shelly.cover, template, wled.update, mqtt.button, waqi.sensor, tuya.siren, google_translate.tts, tradfri.fan, nanoleaf.button, device_tracker, webostv.media_player, hardware, input_datetime, ping.sensor, matter.binary_sensor, ping.device_tracker, image_upload, systemmonitor, watchman.sensor, tuya.number, tplink.sensor, counter, ffmpeg, hue, application_credentials, midea_ac_lan.switch, update, tplink.climate, file_upload, google_translate, shelly, hue.light, xiaomi_ble, automation, humidifier, watchman, wled, tplink.button, tplink.select, upnp, group, conversation, default_config, homekit_controller.binary_sensor, oralb, tts, environment_canada.camera, select, scrape, matter.number, input_text, nest.sensor, speedtestdotnet, group.light, cover, systemmonitor.sensor, dnsip, shelly.light, climate, tag, homeassistant.scene, mobile_app.notify, ping, xiaomi_ble.event, sun.sensor, usb, mobile_app.device_tracker, shelly.event, midea_ac_lan.humidifier, wled.switch, webhook, matter.select, text, sun, co2signal.sensor, mqtt.number, broadlink.switch, diagnostics, shelly.switch, assist_pipeline, input_boolean, recorder, hacs.update, tuya.alarm_control_panel, google_assistant_sdk, weather, zeroconf, input_select, thread, auth, esphome.update, zone, map, shelly.select, esphome.binary_sensor, ssdp, midea_ac_lan.select, min_max.sensor, webostv.notify, wled.select, min_max, persistent_notification, cloud.tts, tplink, broadlink.remote, matter.sensor, tuya.vacuum, matter.climate, nest.camera, siren, fan, my, lock, wled.button, light, matter.event, hassio.update, binary_sensor, tuya.camera, device_automation, tradfri.switch, wled.number, tuya.binary_sensor, shelly.climate, mqtt.light, tuya.switch, midea_ac_lan.water_heater, homeassistant, tradfri.cover, tplink.fan, matter.light, systemmonitor.binary_sensor, nanoleaf.light, schedule, hue.sensor, sql.sensor, environment_canada.sensor, camera, xiaomi_ble.binary_sensor, shelly.sensor, nanoleaf.event, midea_ac_lan.climate, shelly.valve, mqtt.sensor, matter.update, analytics, tuya.humidifier, lovelace, input_button, shelly.text, nest, notify, tuya.cover, cast.media_player, uptime.sensor, esphome.fan, homekit_controller.sensor, history, manual.alarm_control_panel, midea_ac_lan.binary_sensor, button, cast, bluetooth_adapters, matter.cover, energy.sensor, websocket_api, tuya.light, script, shelly.number, sensor, sql, uptime, repairs, api, bluetooth, remote, dnsip.sensor, trace, hue.switch, xiaomi_ble.sensor, google_assistant_sdk.notify, nut.sensor, cloud, midea_ac_lan.lock, stream The system is waiting for tasks: {<Task finished name='Task-2486' coro=<StatisticsSensor._initialize_from_database() done, defined at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:634> result=None>, <Task pending name='Task-2483' coro=<StatisticsSensor._initialize_from_database() running at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:644> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, Task.task_wakeup()]> cb=[set.remove()]>, <Task pending name='Task-2485' coro=<StatisticsSensor._initialize_from_database() running at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:644> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, Task.task_wakeup()]> cb=[set.remove()]>}

Additional information

No response

[bdraco]

{<Task finished name='Task-2486' coro=<StatisticsSensor._initialize_from_database() done, defined at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:634> result=None>, <Task pending name='Task-2483' coro=<StatisticsSensor._initialize_from_database() running at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:644> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, Task.task_wakeup()]> cb=[set.remove()]>, <Task pending name='Task-2485' coro=<StatisticsSensor._initialize_from_database() running at /usr/src/homeassistant/homeassistant/components/statistics/sensor.py:644> wait_for=<Future pending cb=[_chain_future.<locals>._call_check_cancel() at /usr/local/lib/python3.12/asyncio/futures.py:387, Task.task_wakeup()]> cb=[set.remove()]>}

[home-assistant]

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

Code owner commands

Code owners of statistics 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 statistics 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)}}

---

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

[garry0garry]

that's an issue in HACS and unrelated to this issue

Thanks!
hacs/integration#4002

[unfug-at-github]

Could it be that you are loading a very large amount of data for the statistics? It would be helpful to provide some more details: e.g. the definition of the sensor as well as the frequency of changes for the input sensor.

[garry0garry]

Home Assistant 2024.10.0, HACS 2.0.1 - nothing has changed. Every time I reboot HA I get this warning. Detailed data is presented here.