I'm following my energy usage through home-assistant and it was working perfectly fine
This until 2 days ago when i did an unwanted modification on one of my integrations and wanted to revert back.
My home-assistant is running under proxmox, I stopped it and restored it from the proxmox backup/restore feature.
Since then in the energy dashboard, my Zlinky_TIC is still showing my overall consumption usage in the "Electricity usage" tile, and Individual "devices total usage" is still working as well.
However, the individual devices detail usage stays empty (cf enclosed screenshot)
I searched across the web as much as possible, and couldn't find any similar cases.
I'm not finding any logs in "settings" -> "system" linked to this (ie database logs)
I still tried to repair the database following this guide: https://seanblanchfield.com/2024/07/restore-corrupted-ha-database
I'm running out of ideas here.
Any help would be greatly appreciated.
An ungraceful restart of my Home Assistant host left me with a corrupted sqlite3 database. This is the database where Home Assistant core stores the history of all entity state and long-term statistics, like energy and power readings. I could have deleted the old database and started over, but a better solution is to fix it. Here’s how I fixed i...