Open KaliPete opened 2 weeks ago
I found what I think might be a related error in the HA logs;
Log Details (WARNING) Logger: homeassistant.components.recorder.db_schema Source: components/recorder/db_schema.py:624 integration: Recorder (documentation, issues) First occurred: 18 October 2024 at 21:28:08 (2431 occurrences) Last logged: 21:57:14
State attributes for predbat.soc_kw_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.battery_cycle_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.load_power_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.best_load_energy exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.plan_html exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored
Also, attached are 2 examples where it took approx 12 mins to update to the new scheduled state
Ah, I can see in my last log that it's the recorder making the log so big - SO! Testing: Recorder reduced to 15 days. I will share the impact results.
I found what I think might be a related error in the HA logs;
Log Details (WARNING) Logger: homeassistant.components.recorder.db_schema Source: components/recorder/db_schema.py:624 integration: Recorder (documentation, issues) First occurred: 18 October 2024 at 21:28:08 (2431 occurrences) Last logged: 21:57:14
State attributes for predbat.soc_kw_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.battery_cycle_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.load_power_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.best_load_energy exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored State attributes for predbat.plan_html exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored
After updating the recorder to 15 days, I'm down to 90 seconds to change state now - so most likely was just this. Happy to close whenever you are.
I found what I think might be a related error in the HA logs;
Log Details (WARNING) Logger: homeassistant.components.recorder.db_schema Source: components/recorder/db_schema.py:624 integration: Recorder (documentation, issues) First occurred: 18 October 2024 at 21:28:08 (2431 occurrences) Last logged: 21:57:14
State attributes for predbat.soc_kw_best exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored
this is not the cause of your problem, this is a 'known limitation' of Predbat within HA and you can suppress these messages
But per your later comments, if you do store too much history data in the HA database it will affect things. Try to keep the database down to a manageable size
Note that I have been seeing this issue for a few days - I did just run the latest Octo & HomeAssistant updates but there doesn't appear to be any impact from those. I also ran a final test where I cleared all the manual charge/freeze slots I had configured before the next 30 min band - it looks like it still took about 12 mins to run, so maybe it just takes that long to run everytime any variable is changed? It did feel like that earlier today when I added some force idle and it seemed to take forever to apply - though I wasn't timing that. predbat.log