Recorder no longer working

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?

How important is the data?

You could remove and reinstall MariaDB but you would lose all your history.

Not really important now. But the whole idea of storing my data on a NAS is that I may want to do stuff like using historical data to find the relation between outside temperature and heating consumption or the like.

What is error 64 ? perror says the following:

$ perror 64
OS error code  64:  Machine is not on the network

The ALTER TABLE command is create a temp file with the new compression. However, it is trying to create a temp file but it cannot write to the directory tmpdir is mapped to.

1 Like

Thank you for thinking along. I decided to delete all tables from my database. After a restart, the recorder works again.