ottopaulsen / node-red-contrib-power-saver

A Node-RED node to saver money by turning off when the power is most expensive
Other
70 stars 17 forks source link

WARNING - State attributes exceed maximum size of 16384 bytes. #161

Open jurasjo opened 1 year ago

jurasjo commented 1 year ago

Hi, after updating HA to the version 2023.3.x I can see warnings concerning your nodes. I don't know if this is something which should be addressed by you or it is some change in the HA or maybe it is not a problem at all. There was a change to db schema, maybe it is connected?

Logger: homeassistant.components.recorder.db_schema
Source: components/recorder/db_schema.py:491
Integration: Recorder ([documentation](https://www.home-assistant.io/integrations/recorder), [issues](https://github.com/home-assistant/home-assistant/issues?q=is%3Aissue+is%3Aopen+label%3A%22integration%3A+recorder%22))
First occurred: 5 March 2023 at 14:11:52 (11 occurrences)
Last logged: 14:11:52

    State attributes for sensor.powersaver_day exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored
    State attributes for sensor.powersaver_bojler exceed maximum size of 16384 bytes. This can cause database performance issues; Attributes will not be stored

Those two sensors are configure according to this description: https://powersaver.no/examples/example-visualize-on-off/example-visualize-on-off.html#installation

So output from Schedule Merger goes to Function Node which changes true/false to 1/0 and then there is the Sensor Node. Zrzut ekranu z 2023-03-06 15-42-32

I can provide more info, if needed.

ottopaulsen commented 1 year ago

My first guess is that it is not related to the Power Saver nodes, but rather the HA nodes updating the sensors, or something else HA-related. The example you refer to is created by Kim Storøy. I can ask if he has a solution.

kimstor1435 commented 1 year ago

Please see Erlends answer to the same issue: https://github.com/erlendsellie/priceanalyzer/issues/26

jurasjo commented 1 year ago

Ok, thank you guys. I will keep my eyes on this.