Does anyone else have a problem with their file size sensor working for a while and then just not updating anymore? Mine works for a day or two, and then just stops updating the file size. It looks like it should be working, according to the “last updated”, and there are no errors in the log. But the file size currently is 147328.0 kb.
If I delete the database and restart HA, it starts working again, and then the same thing happens. This has been happening for several versions of HA - I’m currently on hass.io 0.70.1, but it was happening on the 0.69 versions as well, and possibly before.
Mine looks the same, but I think what is happening is that the history db reaches the purge interval and the file size no longer increases. The size is correct.
I don’t understand this. My database file does the same…grows and then hits some level and stops growing. But isn’t there constantly new entries put into the database, and then its purged of old data every once in a while. So shouldn’t we see constant growth and then every once in a while spike down in size?
Yeah, I couldn’t find any other posts that describe this behavior. I’ve been recently exploring why my DB is so enormous and am doing a deep dive. I haven’t gotten around to switching to a different DB type although I’ve heard that is a good idea.
Its just odd that sometimes it plateaus for a while, it does seem to line up with the actual file size when I look at it in a file explorer. But I suppose it could be the file size sensor but I kind of doubt it.