I have setup HomeAssistant more than half a year ago. Part of my setup is the recorder, which stores data on my NAS. On my NAS I have setup a MariaDB10 database.
This worked perfectly well until June 25 (latest entry in the DB is from that date)
Since I upgraded HA, or the OS (I’m not sure), I get an error that the recorder does not work.
I have upgraded HA and the OS to the latest version. But recorder still does not work.
In the log file I see many many lines that have to do with the database and the recorder.
The first is Database is about to upgrade. Schema version: 7
second error is
2020-07-19 20:38:56 ERROR (Recorder) [homeassistant.components.recorder.util] Error executing query: (MySQLdb._exceptions.OperationalError) (1296, "Got error 64 'Temp file write failure' from InnoDB") [SQL: ALTER TABLE events ADD context_parent_id CHARACTER(36)] (Background on this error at: http://sqlalche.me/e/e3q8)
This error is repeated many times.
Can anyone help?