#Would someone have hints for debugging

1 messages · Page 1 of 1 (latest)

sacred arch
#

Occurence was random earlier but as I have added more stuff, it has become nightly and clearly seems to happen during the recorder "purge" process which starts 04:12 according to the docs

#

Matches with when the queue starts to cumulate:

# 
2022-12-15 04:10:00.471 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 0
2022-12-15 04:20:00.472 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 7434
2022-12-15 04:30:00.473 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 16817
2022-12-15 04:40:00.474 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 25983
2022-12-15 04:50:00.475 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 35208
2022-12-15 05:00:00.476 DEBUG (MainThread) [homeassistant.components.recorder.core] Recorder queue size is: 44206
#

Memory seems ok, 1G free all the time. Load average tells significant amount of processing happens but does not skyrocket over the count of cores.

#

I have enabled MariaDB slow query log which results 144 minutes total length of slow queries, whereas the queue overflows at 50 minutes
https://pastebin.com/fYPejz8X