I noticed my HA “server” was running at 20w instead of the usual 10w, then I noticed python 3 was running at 100%, I stop the HA docker and it dropped back to normal levels… is anyone else seeing this?
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26293 root 20 0 294896 196452 38356 S 106.7 2.4 539:27.78 python3
4950 root 20 0 1205252 81856 29500 S 6.7 1.0 44:23.73 Main
16435 root 20 0 46656 3804 3192 R 6.7 0.0 0:00.01 top
25829 _apt 20 0 63952 10728 1664 S 6.7 0.1 5:35.19 mosquitto
if I try to roll back to 0.99 nothing loads but python is running at a normal threshold… funny it is python not python 3… so I loaded 0.89, same issue python 3 100% cpu
Just posting this in case anyone else suddenly has a problem… it was my mysql log files… they hadn’t purged for some reason and must have gone over a threshold, that made the i5 PC struggle… it was 2.5GB, cleared it and running normally again…
He probably meant home-assistant_v2.db file. I just had the same issue with 2024.7.1. The issue is temporarily resolved by resetting the HASS instance, but it can be reproduced when I manually trigger the Recorder purge. The CPU usage of the HASS process has been pegged to 100% for a long time, and I see recodings stopped at some point (missing history data).
The resolution was to delete home-assistant_v2.db file, and reset the HASS. But that loses all historical data.