github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-09 19:52:56 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

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

New Issue
Closed
opened 2026-02-28 19:59:39 -06:00 by GiteaMirror · 7 comments
GiteaMirror commented 2026-02-28 19:59:39 -06:00
Owner
Copy Link

Originally created by @delize on GitHub (Mar 9, 2025).

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:

Image

When looking at the browser console after the error:

Image

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

Originally created by @delize on GitHub (Mar 9, 2025). ### Verified issue does not already exist? - [x] 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: <img width="440" alt="Image" src="https://github.com/user-attachments/assets/cbbaea04-f6f5-407f-a09c-965a05873ce9" /> When looking at the browser console after the error: <img width="1657" alt="Image" src="https://github.com/user-attachments/assets/d474025f-e5e1-4a8c-aead-c1c85bc23808" /> 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
GiteaMirror added the bug label 2026-02-28 19:59:39 -06:00
GiteaMirror commented 2026-02-28 19:59:40 -06:00
Author
Owner
Copy Link

@youngcw commented on GitHub (Mar 10, 2025):

Try doing incremental updates instead of a big jump.

@youngcw commented on GitHub (Mar 10, 2025): Try doing incremental updates instead of a big jump.
GiteaMirror commented 2026-02-28 19:59:40 -06:00
Author
Owner
Copy Link

@delize commented on GitHub (Mar 15, 2025):

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

Image

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): Well, according to my docker-compose file, I was on `latest` with this issue happening. <img width="540" alt="Image" src="https://github.com/user-attachments/assets/c7faf75d-b112-42db-877b-1bc490646bbb" /> 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.
GiteaMirror commented 2026-02-28 19:59:40 -06:00
Author
Owner
Copy Link

@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.

@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.
GiteaMirror commented 2026-02-28 19:59:41 -06:00
Author
Owner
Copy Link

@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?

@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?
GiteaMirror commented 2026-02-28 19:59:41 -06:00
Author
Owner
Copy Link

@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 (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.
GiteaMirror commented 2026-02-28 19:59:41 -06:00
Author
Owner
Copy Link

@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): Downgrading to 25.1.0 works. When trying to upgrade to 25.2.0, it fails.
GiteaMirror commented 2026-02-28 19:59:42 -06:00
Author
Owner
Copy Link

@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.

@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.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#1951
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?