Hello everyone, I’m a relatively new user to Home Assistant and I’ve been enjoying setting up my smart home ecosystem. However, I’ve encountered a significant issue after upgrading to the latest version of Home Assistant. The upgrade process triggered a database migration, which unfortunately failed. This has resulted in some functionalities, such as the logbook and energy dashboard, not working as expected. Grafana seems to be receiving data correctly, but the internal database issues are causing some headaches.
I’ve been running Home Assistant with MariaDB and InfluxDB, and the error logs indicate a problem with the ‘states’ table, specifically mentioning a corrupt index. I’ve tried restarting both MariaDB and InfluxDB, as well as Home Assistant itself, but the issue persists. The migration process keeps failing with the same error, and I’m not sure how to proceed further.
Has anyone else encountered similar issues during a database migration? I’m particularly concerned about losing any important data or configurations. I’m considering reverting to a previous backup, but I’m hoping there’s a way to resolve this without losing progress. Any advice or guidance on troubleshooting this would be greatly appreciated. I’m happy to provide more details or logs if needed to help diagnose the problem.