[Solved] HA db only history in it?

Installation
1

Hi

Following reinstall of system from a backup (hassio archive), everything is running fine excepted I have that error at ha start in logs:

Error executing query: (sqlite3.DatabaseError) database disk image is malformed [SQL: ‘INSERT INTO events (event_type, event_data, origin, time_fired, created, context_id, context_user_id) VALUES (?, ?, ?, ?, ?, ?, ?)’] [parameters: (‘service_registered’, ‘{“domain”: “recorder”, “service”: “purge”}’, ‘LOCAL’, ‘2019-02-04 10:59:43.912612’, ‘2019-02-04 11:00:08.912099’, ‘83b51b324b514fb6847ddc60765dfcd2’, None)] (Background on this error at: Error Messages — SQLAlchemy 2.0 Documentation)

Looks like HA db is corrupted no ? Is is always safe (with HA stopped for sure) to just delete it ? and HA will restart it automatically at next start ?
I have also no history of any sensors in web interface as it’s probably unable to record history in db no ?

Thanks

2

Yes, just delete it and db will be recreated on next HA restart. But you will lose all history data until that point.

3

Exactly what I wanted and it’s doing the job :wink: thanks