System:
HAOS 12.0
Core 2024.3.0
sqlite database 16.9 Gb
Everytime recorder.purge runs I get the following error:
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) Could not decode to UTF-8 column 'attributes_id' with text '0g��S��|)('
(Background on this error at: https://sqlalche.me/e/20/e3q8)
2024-03-10 20:33:14.096 WARNING (Recorder) [homeassistant.components.recorder.util] Error executing purge: (sqlite3.OperationalError) Could not decode to UTF-8 column 'attributes_id' with text '0g��S��|)('
(Background on this error at: https://sqlalche.me/e/20/e3q8)
Result is that the database is discarted (home-assistant-v2.db.corrupt), a new database is grown and all my statistics data of the last years is… gone.
So killing the database and have HA generate a new one is not the answer I am looking for.
Please advise on a way to find this “faulty record”, delete it and save my statistics data.
Kind regards Han