I have a problemi with mariadb on table states
In the log of HA I recive this error
sqlalchemy.exc.OperationalError: (MySQLdb.OperationalError) (1712, ‘Index states is corrupted’)
In the log of db
024-12-16 0:18:18 18 [ERROR] Got error 180 when reading table ‘./homeassistant/states’
I try to connect to db from external machine
MariaDB [homeassistant]> check table states;
±---------------------±------±---------±--------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±---------------------±------±---------±--------------------------------------------------------------+
| homeassistant.states | check | Warning | InnoDB: Index ix_states_context_id_bin is marked as corrupted |
| homeassistant.states | check | error | Corrupt
I try to repair
MariaDB [homeassistant]> repair tables states;
±---------------------±-------±---------±--------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±---------------------±-------±---------±--------------------------------------------------------+
| homeassistant.states | repair | note | The storage engine for the table doesn’t support repair |
±---------------------±-------±---------±--------------------------------------------------------+
For recovery the table have you any idea?
The states table is for few day of data , for me important access to table for next data information
thanks