I wanted to delete 8 rows from states to clean some invalid data using Home Assistant Community Add-on: SQLite Web and after that HA found the sqlite database as corrupted and instantiated a new DB.
[SQL: INSERT INTO states (entity_id, state, attributes, event_id, last_changed, last_changed_ts, last_updated, last_updated_ts, old_state_id, attributes_id, context_id, context_user_id, context_parent_id, origin_idx, context_id_bin, context_user_id_bin, context_parent_id_bin, metadata_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) RETURNING state_id]
[parameters: (None, 'unavailable', None, None, None, None, None, 1711625571.869187, 64566985, 913713, None, None, None, 0, <memory at 0x7f37f34340>, None, None, 712)]
(Background on this error at: https://sqlalche.me/e/20/gkpj)
I recovered from backup but lost 2 days of data. I can browse the “corrupted” database and I’m asking if I can manually append the missing states in the recovered database.