Recorder no longer working

Installation Home Assistant OS
1

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?

2

How important is the data?

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

3

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.

4

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
5

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