Average sensor unavailable with Quick Reload

[MisfitPunisher]

System Health details

System Information

version	core-2024.6.3
installation_type	Home Assistant OS
dev	false
hassio	true
docker	true
user	root
virtualenv	false
python_version	3.12.2
os_name	Linux
os_version	6.6.28-haos-raspi
arch	aarch64
timezone	Europe/Andorra
config_dir	/config

Home Assistant Community Store

GitHub API | ok -- | -- GitHub Content | ok GitHub Web | ok GitHub API Calls Remaining | 4846 Installed Version | 1.34.0 Stage | running Available Repositories | 1464 Downloaded Repositories | 26

Home Assistant Cloud

logged_in | false -- | -- can_reach_cert_server | ok can_reach_cloud_auth | ok can_reach_cloud | ok

Home Assistant Supervisor

host_os | Home Assistant OS 12.3 -- | -- update_channel | stable supervisor_version | supervisor-2024.06.0 agent_version | 1.6.0 docker_version | 25.0.5 disk_total | 219.4 GB disk_used | 16.6 GB healthy | true supported | true host_connectivity | true supervisor_connectivity | true ntp_synchronized | true virtualization | board | rpi4-64 supervisor_api | ok version_api | ok installed_addons | Check Home Assistant configuration (3.11.0), DHCP server (1.4.0), Duck DNS (1.17.0), File editor (5.8.0), Home Assistant Google Drive Backup (0.112.1), Let's Encrypt (5.0.18), Samba share (12.3.1), Terminal & SSH (9.14.0), WireGuard (0.10.2), chrony (3.0.1), Log Viewer (0.17.0), Piper (1.5.0), Whisper (2.1.0)

Dashboards

dashboards | 3 -- | -- resources | 14 views | 32 mode | storage

Recorder

oldest_recorder_run | June 9, 2024 at 16:31 -- | -- current_recorder_run | June 17, 2024 at 19:39 estimated_db_size | 2719.51 MiB database_engine | sqlite database_version | 3.44.2

Checklist

• [X] I have enabled debug logging for my installation.
• [X] I have filled out the issue template to the best of my ability.
• [X] This issue only contains 1 issue (if you have multiple issues, open one issue for each issue).
• [X] This issue is not a duplicate issue of any previous issues..

Describe the issue

Hi guys,

All my average sensors are unavailable when I perform a Quick Reload of HA. I need no perform a full reload to do it work.

Reproduction steps

1. I removed average sensor from HACS
2. rebooted
3. Reinstalled
4. The issue keeps appearing ...

Debug logs

I dont know how to perform it

Diagnostics dump

I have not it.

[vodkapmp]

Some of my average sensors become unavailable, but it makes no sense as to why or how.

For me, a quick reload actually makes them come back.

[t2029]

I have same issue, but rebooting doesn't help at all. However I can revive the sensors if I remove .replace(minute=0).replace(second=0) from the end time binding.

[hardweb-it]

I have the same issue

[vodkapmp]

Some of my average sensors become unavailable, but it makes no sense as to why or how.

For me, a quick reload actually makes them come back.

I solved my issue, my database was over 40GB, after reconfiguring recorder to only actually record things I want history for and then purging the database I've since not that this issue anymore.