Hi,
Since 2020-03-25 01:39:17 every data in my MySQL database is doubled. I have 500+ sensor data and all are doubled - twice same timestamp, same value in db. Sometimes timestamp second is different (+1), so it’s real data there. Is someone seen this behaviour or can explain it?
I made HA upgrade and server restart also during this period, but double amount of data continued to inserted to MySQL. Solution was HA uninstall and new install. Reason, why this happened is unclear. Everything worked, I didn’t notice performance slowdown.
I have also noticed since 0.108.0 (there was a notable database update failure in my first log after the update), I now have a database that has jumped to 1.4GB, when originally it never floated much higher than 700MB. I’m using an external Mariadb.
Stupidly I did not capture the error.
Edit: Now looking at the tables, I dont see an obvious doubling of data (data within the same second, are not duplicated at least), so mines probably got another explanation (though the error after update definitely occurred).
I think this started after 6 hours power outage on night at 25.03.
I have hundreds of sensor data recorded every 5 min, and (for testing) purge time was also 60 days.
One sensor data example (bold is moment of change):