hi there
just wonder where to find the release changes of database schemas. specifically i was interested in the difference between version 47 and 48 but wasn’t able to find this information in the release change log. any hint where i could find this documentation or the respective migration script?
thank you and kind regards
1 Like
not sure whether this forum is the right place to get an answer on the above question. please advise.
the reason i posted it is beside curiosity an issue with the upgrade from 2024.10 to 2025.2 for which the db upgrade appeared to have worked fine according to the logs but the system could still not be used anymore because of ongoing 100% cpu usage of the db server after the upgrade. this is one of the issues open in github and required me to roll back to 2024.10. so getting details on the script which is performing the upgrade of schema version 47 to 48 would hopefully help to find out what went wrong and how to fix it.
I’m not sure if they are actually documented in the release notes (at least not as database schema migrations), but you can always look in the code if you’re into that.
core/homeassistant/components/recorder/migration.py at f8ffbf0506c168ee87df85df113c6f42e9e8bc51 · home-assistant/core · GitHub Here you can find the migrations that have been created, with the highlighted one being the latest one.
1 Like
thank you - very much appreciated!