mirror of
https://github.com/actualbudget/actual.git
synced 2026-07-15 22:54:03 -05:00
[Bug]: Unable to open / download planbook budget, SQL Migration Failure #1951
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/actual#1951
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @delize on GitHub (Mar 9, 2025).
Verified issue does not already exist?
What happened?
Upgraded from 2024 release to docker image:
actualbudget/actual-server latest 5a848d552f34After 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 commented on GitHub (Mar 10, 2025):
Try doing incremental updates instead of a big jump.
@delize commented on GitHub (Mar 15, 2025):
Well, according to my docker-compose file, I was on
latestwith 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 commented on GitHub (Mar 15, 2025):
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 commented on GitHub (Mar 15, 2025):
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 commented on GitHub (Mar 16, 2025):
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.
@delize commented on GitHub (Apr 5, 2025):
Downgrading to 25.1.0 works.
When trying to upgrade to 25.2.0, it fails.
@delize commented on GitHub (Apr 5, 2025):
Downgraded to 25.1, backed up data
Moved folder, then tried to restore.
Would absolutely prefer SQL Migrations be handled in a way that doesn't cause a mass destruction setup.