Hallo zusammen,
meine Home Assistant läuft auf einem Intel NUC und seit einiger Zeit nutze ich MariaDB.
Jetzt wollte ich wieder zurück zu SQLlite wechseln und habe die Anleitung von Simon befolgt. Bei der Migration kommt dann die Fehlermeldung:
2024-08-20 12:15:54 INFO Transferring table events
1034 (HY000): Index for table 'events' is corrupt; try to repair it
Folgendes habe ich dann anschließend herausgefunden:
MariaDB [homeassistant]> CHECK TABLE events;
+----------------------+-------+----------+----------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+-------+----------+----------------------------------------------------------------------------+
| homeassistant.events | check | Warning | InnoDB: The B-tree of index PRIMARY is corrupted. |
| homeassistant.events | check | Warning | InnoDB: Index ix_events_context_id_bin is marked as corrupted |
| homeassistant.events | check | Warning | InnoDB: Index ix_events_event_type_id_time_fired_ts is marked as corrupted |
| homeassistant.events | check | Warning | InnoDB: Index ix_events_time_fired_ts is marked as corrupted |
| homeassistant.events | check | Warning | InnoDB: Index ix_events_data_id is marked as corrupted |
| homeassistant.events | check | error | Corrupt |
+----------------------+-------+----------+----------------------------------------------------------------------------+
6 rows in set (0.061 sec)
MariaDB [homeassistant]> optimize table events;
+----------------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+----------+----------+-------------------------------------------------------------------+
| homeassistant.events | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| homeassistant.events | optimize | error | Can't open table |
| homeassistant.events | optimize | status | Operation failed |
+----------------------+----------+----------+-------------------------------------------------------------------+
3 rows in set, 1 warning (0.034 sec)
MariaDB [homeassistant]> REPAIR TABLE events;
+----------------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+---------------------------------------------------------+
| homeassistant.events | repair | note | The storage engine for the table doesn't support repair |
+----------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.001 sec)
Ich habe eigentlich keine Ahnung vin der SQL-Thematik und habe mich bisher nur mit Hilfe von google durchgetastet.
Kann mir hier vielleicht irgendjemand helfen wie ich meine DB wieder repariert bekomme?
Gerne stelle ich auch weiter Daten zur Verfügung.
Danke und viele Grüße
Benjamin