Hi All:
I have posted this question in r/Homeassistant as well.
I have (I think) set up my HA instance to use MariaDB as the recorder database. I am sending outside temperature data into HA through Mosquitto (MQTT). I can see the temperature data as I expect.
Except…
Here in SoCal, the temps have been over 100 degrees F for several days. When I look at the temperature history chart inside the HA application I can see that it’s recorded those temperatures. However, when I query the MariaDB database, it returns “99.9” for all those readings, not the 100+ numbers I’m expecting.
Here is an excerpt from the configuration.yaml:
Recorder.
recorder:
db_url: !secret mariadb_url
commit_interval: 30
purge_keep_days: 30
Settings changed 7/3/23
Is there another database inside HA? If I shell into the primary container, I see a “homeassistant_v2.db” file that was last updated in September of 2022, which seems about right.
Has anyone else experienced this phenomenon?
TIA,
Mike