home-assistant[bot]
commented
1 day ago 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)
The problem
Upon restart, I get warnings related to sqlite3 database, recorder and statistics. The log message encouraged me to post the error in this forum.
What version of Home Assistant Core has the issue?
core-2024.9.3
What was the last working version of Home Assistant Core?
core-2024.9.3
What type of installation are you running?
Home Assistant Container
Integration causing the issue
Recorder or Statistics sensor
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?
2024-10-20 09:39:45.191 WARNING (Recorder) [homeassistant.components.recorder.util] The system could not validate that the sqlite3 database at //config/home-assistant_v2.db was shutdown cleanly2024-10-20 09:39:47.525 WARNING (Recorder) [homeassistant.components.recorder.util] Ended unfinished session (id=338 from 2024-10-14 21:06:27.024187)2024-10-20 09:40:55.949 WARNING (MainThread) [homeassistant.core] 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: zone, lovelace, radio_browser, sun.sensor, sensor, image_upload, input_select, opensky, binary_sensor, history_stats.sensor, sagemcom_fast.device_tracker, search, icloud3.device_tracker, remote_homeassistant.sensor, owntracks, hardware, hass_agent, scrape, google_assistant_sdk.notify, google_geocode.sensor, template.sensor, zha.sensor, template, number, rest.sensor, python_script, zha.light, aurora.sensor, met, switch, intent, moon, remote, zha.fan, remote_homeassistant, config, tts, media_player, smhi, ping.binary_sensor, persistent_notification, smtp.notify, tailscale.binary_sensor, ssdp, bluetooth, statistics.sensor, version.sensor, spotify, local_todo.todo, tag, met.weather, conversation, uptime.sensor, esphome.sensor, spotify.media_player, button, todo, uptime, stream, cloud, diagnostics, rest_command, usb, file_upload, command_line, pyscript, garmin_connect, mobile_app.sensor, analytics, zha.binary_sensor, zha.cover, recorder, zha.siren, stt, version.binary_sensor, onboarding, google_assistant_sdk, icloud3.sensor, tailscale.sensor, frontend, input_datetime, homeassistant.scene, fan, blueprint, history, iphonedetect.device_tracker, mobile_app.binary_sensor, zha.lock, zha.number, group, siren, cloud.tts, zha.button, repairs, light, downloader, mqtt.button, timer, zha.device_tracker, zha, sagemcom_fast.button, multiscrape, google_translate.tts, bayesian.binary_sensor, update, template.binary_sensor, backup, tailscale, swedish_calendar, alarm_control_panel, opensky.sensor, webrtc, local_todo, schedule, moon.sensor, google.calendar, zha.select, energy, local_calendar.calendar, zeroconf, system_log, systemmonitor.sensor, mobile_app.device_tracker, ffmpeg, hass_agent.notify, samsungtv.media_player, local_calendar, command_line.sensor, climate, counter, swedish_calendar.sensor, ping.sensor, input_text, default_config, map, homeassistant, calendar, media_source, sun, logbook, multiscrape.button, network, wake_word, script, dhcp, zha.alarm_control_panel, systemmonitor, file, device_automation, cover, hacs, input_boolean, device_tracker, my, http, websocket_api, google, lock, file.notify, mobile_app.notify, system_health, esphome, zha.update, mqtt.sensor, notify, sagemcom_fast, aurora, select, group.sensor, auth, energy.sensor, scrape.sensor, rest.notify, webhook, homeassistant_alerts, nmap_tracker, icloud3, weather, automation, swedish_calendar.calendar, ping.device_tracker, logger, github.sensor, scene, api, systemmonitor.binary_sensor, zwift.sensor, zha.switch, person, application_credentials, samsungtv, camera, nmap_tracker.device_tracker, trace, input_number, garmin_connect.sensor, file.sensor, mqtt.binary_sensor, ffmpeg_motion.binary_sensor, rest, zha.climate, mobile_app, version, shell_command, ping, mqtt_flespi_message.device_tracker, aurora.binary_sensor, mqtt, input_button, wake_on_lan, github, smhi.weather, hass_agent.media_player, assist_pipeline, hacs.sensor, filter.sensor, owntracks.device_tracker, samsungtv.remote The system is waiting for tasks: {<Task pending name='Task-2759' 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-2761' 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