Is it normal, that database upgrade runs since 6h?
System performance will temporarily degrade during the database upgrade. Do not power down or restart the system until the upgrade completes. Integrations that read the database, such as logbook, history, and statistics may return inconsistent results until the upgrade completes. This notification will be automatically dismissed when the upgrade completes.
How big is your database and what hardware are you running it on?
My 1.5GB database took about 3-4 minutes to convert on a core i7-1165G7.
thanks for the infoā¦
Mine is around 10GBā¦ and started 20min agoā¦ so I should wait (20min and still not finished)
letĀ“s see after an hour if itĀ“s already finished 
10GB 
Be paitent.
Mine is app. 2GB. MariaDB running on a Synology NAS. And sorry I upgraded to Core 2024.8.0
Database is 6gb and running as maria db on my synology nas since more than 6h 
and still not finished
Thatās not super surprising if you are using the default maria config. Maria works much better with more RAM allocated to it.
Just let it run, check on it in a day.
yupā¦ I knowā¦ 
(even with quite a few excludes in the recorderā¦ but Iām a kpi freakā¦I must confess)
I hope it wonĀ“t break anythingā¦ Iām using mariaDB btwā¦ itās supposed to be more robust (I hope)
finished!!! 
How long did it take for how many GB?
I am in the same boat. I have approx. 12gbās and I am storing it in a MariaDB. and I am running HA in a VM with 2 cores and 4GB of ram, so far it has been running for 1 hour. the issue is I donāt care how long it takes but the issue is that I am lossing sensor data. and also there is no way I can monitor it.
UPDATE: for me it progress take 2 hours for 20gb
Thatās probably going to take quite a while.
You will be notified in the log when it finishes.
is there a way to add a āProgress barā or something so that the user can see how long it will take, or check on the progress
Alomost 1.5 days for 58GB =)
my Database is 3,1gb and the upgrade has been running for 18 hours now.
I would have to restart my HA, but Iām not allowed to restart as long as the upgrade is running.
When I enter this command in phpmyAdmin
show full processlist;
It shows:
command Time state Info Process
Query 4182 copy to tmp table ALTER TABLE states ADD FOREIGN KEY(old_state_id) Rā¦ 22.563
The rest is set to sleep and process 0
Is that normal? Can I do anything?
This post tells you precisely what to do.
I read that, of course. But my database is not 10GB. And I read from others with about 3GB that it was finished after a few hours.
I just want to rule out that there is a problem with my upgrade and I need to do something
Any chance to get the energy dashboard history during the DB upgrade?
My upgrade is running over 24 hours now,
Is it normal that the energy Dashboard is not working during the upgrade.
Unlikely as itās completely driven off computed data f om the database thays being upgradedā¦
See previous.
Be patient for how long though? With no progress indicator of any form, we have no way of knowing whatās ānormal, wait longerā and whatās āitās stuck and never going to finishā
So do I be patient for an hour? a day? a week? a month? a year? a decade? at what point do I call it broken? and if it is, what do I do about it?
In the meantime, Iām told not to restart, but I have 2 integrations and an add-on that wonāt work until I do a restart. so basically Iām at the mercy of something that I have no way of knowing if itās even doing anything. and a broken HA instance until it finishes, which it may never do.