So after the upgrade to 2024.8.0, my database (MySql with a few million state records) took around 3 days to upgrade. I am missing a day of statistics. Which is annoying, but sometimes necessary.
Come the 2024.8.2 upgrade, it started another migration. This one has been running for as least as long and still no end in sight.
[ homeassistant ] Query 29954 seconds
copy to tmp table ALTER TABLE states ADD FOREIGN KEY(metadata_id) REFERENCES states_meta (metadata_id)
Is this the last query to be run, or are any others coming?
Should I stop auto-upgrading until you figure this out and I can do them all in one go, or is this the last schema change for now?