Issues after 2022.6 upgrade

Configuration
1

Hi, as soon as 2022.6.0 was available I decided to upgrade my HA, since there were no breaking changes of interest with my setup.
The upgrade seems to going well, the system restarted and I know to expect some delay, due to the database changes. Thus, after hours, the system was not fully started: sensors and automations weren’t yet ready. So, after the whole day, I decided to restart HA, but it still saying that the system cannot restart while a database upgrade is in progress. I rebooted the Raspberry, but nothing changed: it’s apparently still stuck on upgrading the database, partially working.
Now I don’t know what to do.

The system is Home Assistant Supervised (supervisor-2022.05.3) on a Raspberry Pi 4.

2

What’s the database file’s size and is the RPi4 using an SD card?

3

The DB file size is 1,29 GB and the last modification is from three days ago (when I launched the upgrade).
The RPi4 is using a 64 GB SD card with 45 GB free.

4

So it’s a large database file on a very slow storage medium. That contributes to a long conversion time but, admittedly, an entire day seems awfully long.

After restarting it the way you did, I don’t know if it picked up from where it left off or started all over again. Maybe someone else knows the answer.

5

I renamed the database to _old and created a new database…

6

I tried it, but nothing changed: it’s still stuck with the DB and only half of the integration are loaded (and no automations).

7

I’m in the same boat. 2022.4 to 2022.7 update here, however, my .db file is only 659MB last updated when the update was initiated.

Did you figure any other options out? I’m also wary of restarting the Pi (3B+ in my case) but I did notice a couple other things: a .db-wal file (write ahead log maybe?) possibly used for the migration. And one other symptom, recorder is unresponsive, but I haven’t seen any specific errors that point to an in-progress DB upgrade.

8

I restarted multiple times the host, I thought it could be a SD card issue, so I tried a new SD card with a new installation and I imported the last working backup. It worked just fine, but when I tried to upgrade, same issue.
At this point I just reinstalled everything and started from scratch.

9

Thanks for your clarification. I’m willing to spend a few hours to avoid reinstalling everything from scratch, as this would probably take a few days to get everything back to normal (unless I restore from a previous backup).

I woke up today and everything was back to normal. I guess the update was complete but I am curious how to do more troubleshooting on the SQLite database. Since I’m running on a RPi3b+ I understand MariaDB is not suitable for my hardware.