I’ve started having issues both on startup and randomly while using HA on my RPi4.
Sometimes after start the recorder won’t start, I get several messages in the log, the final one I saw last was it gave up waiting after 300sec. Usually I just reboot a few times and suddenly it just works.
I’ve also noticed (just happened again) that my Tibber Pulse (power meeter) graph stops updating, it’s a websocket sensor that updates every few sec. While this happens I can see the actual sensor value updating but the graph has flatlined.
Now I tried restarting the MariaDB add-on and after that all “missing” values was back and the flatline was gone! Super strange.
I’m running 2022.12.1 but this has happened for at least a version or so back.
what’s your purge time for the database?
When this happens, you should check the status of the MariaDB Addon itself - if it is running or if the logs provide any kind of information that could help to investigate…
I’ve kept an eye on the add-on but never seen anything in the log unless I’ve manually restarted it, not have I seen it crash or with a high cpu or ram load. But that doesn’t say for sure it haven’t happened when I haven’t checked it.
Is 90 days too long? I have 1023 entities + 320 “not shown” according to the list.
It really depends how much storage you have.
90 days can cause a large Database - and running as addon within HomeAssistant it could cause the system to Crash when it doesn’t have space left… But Sure, that’s Just an asumption right now
What I would also recommend:
If you are running mariaDB as an addon, consider also to install phpMyAdmin
That will provide additional options to check your Database Status…
Personally, I have “outsourced” my MariaDB to another host - so the database is 100% independent from my HA instance and I can assign as much storage as I need without affecting my HA installation.
I ran it on another host before, but I like the convenience with all-in-one. I’m accessing it through Navicat and are currently running an optimize on the states table, looking at the hardware info it’s only using about 30% and 1.2/8GB memory so I presume the add-on is a bit limited.
Do you know if there is a way to expose things like storage usage etc as sensors? I saw someone having that, but no explanation on where he got from.
yes, that’s possible… one moment, I have to search…
(right now, I am running on local DB for evaluation - since I rebuilt my HA … the switch to mariaDB will take place on NewYears eve… so haven’t implemented that yet…
So, please give me some time - I need to do some other stuff first (else, my wife will get angry )
SELECT
table_schema AS db_name,
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS size_mb
FROM
information_schema.TABLES
WHERE
table_schema='homeassistant'
I also have this problem - still in Version 2024.1.5 - Sometime the recording stops - and then the Energy Dashboard also still has no data - and then after clicking on Data history or “Reloading” of Homassistant Core - the dataś will be recorded again.
…but the data they are missed they will not return again…
See picture of the enrergy dahsboard with missing data between the time of 11:00h - 2:00 PM …