I seem to be experiencing this error at least once a week now. I’m not entirely sure how to investigate what might be causing it. I’ve searched around here and the only other posts I’ve found were all relating to an issue caused by a change to DST or during a scheduled backup. Mine backs up at 9am every morning, backup file size was 732MB today and the database is 1.8GB (MariaDB).
I’m running Home Assistant 2023.8.1, OS 10.4 in a Proxmox 8 VE on a Lenovo M93p with an Intel i5 and a 250MB SSD.
So, CPU useage usually sits at around 6%, but is around 53% when this happens. It doesn’t happen every time cpu useage is high, but when it does happen, cpu useage is higher than normal. The time of day varies, but it usually happens mid-late afternoon when home assistant seems to be just ticking along. In terms of hardware, what are the chances that it’s a hard drive problem, and other than replacing the hard drive, and therefore reconfiguring the whole installation, is there any other way of conducting further investigation.
Logger: homeassistant.components.recorder.core
Source: components/recorder/core.py:384
Integration: Recorder (documentation, issues)
First occurred: 18:20:42 (1 occurrences
Last logged: 18:20:42
The recorder backlog queue reached the maximum size of 697313 events; usually, the system is CPU bound, I/O bound, or the database is corrupt due to a disk problem; The recorder will stop recording events to avoid running out of memory
Thanks for any help.