[Bug]: Unable to open / download planbook budget, SQL Migration Failure

[delize]

Verified issue does not already exist?

• I have searched and found no existing issue

What happened?

Upgraded from 2024 release to docker image:
actualbudget/actual-server latest 5a848d552f34

After upgrading, I am no longer able to open or download files. Which just produces this message:

When looking at the browser console after the error:

It seems there is a database migration trying to run and it fails the SQL changes.

Tried clearing cookies & cache

How can we reproduce the issue?

Run a database from ~2024.9
Upgrade to 2025.2>
Try to open file
File fails

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome

Operating System

Mac OSX

[youngcw]

Try doing incremental updates instead of a big jump.

[delize]

Well, according to my docker-compose file, I was on latest with this issue happening.

My previous change to my file was in January, and I try to update routinely every week. I only recently (last week) changed it to ghcr registry due to release notes for 25.3. So likely was on a more recent DB setup.

[delize]

And unfortunately, now I can't load my DB file at all. I will reach back out on Discord, but, I don't think this is user error or a jump in version situation.

[youngcw]

Is there a reason you moved away from docker hub? Those docker containers are still up to date

If you go back to the previous version do things work?

[delize]

I've been trying to move most of my stuff to GitHub as 99% of the containers I use are hosted there.

I also misunderstood the release notes announcement and thought you would be stopping releases on docker for Actual-Server.

I tried that last night, but I didn't see a difference in the previous version. Or it didn't spin up, will try again today.