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

• I have enabled debug logging for my installation.
• I have filled out the issue template to the best of my ability.
• This issue only contains 1 issue (if you have multiple issues, open one issue for each issue).
• 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.