github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-05-08 12:59:01 -05:00
Code Issues 1.6k Packages Projects Releases 55 Wiki Activity

[GH-ISSUE #4969] [Bug]: Unable to Re-Download Budget after Resetting Sync (Nightly) #43772

New Issue
Closed
opened 2026-04-26 04:27:48 -05:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-04-26 04:27:48 -05:00
Owner
Copy Link

Originally created by @duplaja on GitHub (May 10, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/4969

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

After resetting sync, I'm unable to download my budget file on any device. Latest nightly, as of 5/10/25

  • Have cleared local cache, etc.
  • It did download once but then couldn't sync (kept spinning / trying to sync)

Log is full of this error:

actual  | 2025-05-10T11:39:44.272Z info: GET 304 /sync/list-user-files
actual  | 2025-05-10T11:39:46.469Z info: GET 304 /sync/download-user-file
actual  | 2025-05-10T11:39:46.475Z info: GET 304 /sync/get-user-file-info
actual  | Rejection: SqliteError: no such table: messages_binary
actual  |     at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
actual  |     at WrappedDatabase.all (file:///app/src/db.js:11:30)
actual  |     at Module.sync (file:///app/src/sync-simple.js:53:28)
actual  |     at file:///app/src/app-sync.js:76:46
actual  |     at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
actual  |     at next (/app/node_modules/express/lib/router/route.js:149:13)
actual  |     at Route.dispatch (/app/node_modules/express/lib/router/route.js:119:3)
actual  |     at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
actual  |     at /app/node_modules/express/lib/router/index.js:284:15
actual  |     at Function.process_params (/app/node_modules/express/lib/router/index.js:346:12) {
actual  |   code: 'SQLITE_ERROR'
actual  | }

If I do get it to load, exporting and re-importing gives the following error:

actual  | 2025-05-10T11:48:46.202Z info: POST 200 /sync/upload-user-file
actual  | 2025-05-10T11:48:46.288Z info: GET 304 /account/validate
actual  | Rejection: Error: ENOENT: no such file or directory, open '/app/src/sql/messages.sql'
actual  |     at Object.openSync (node:fs:596:3)
actual  |     at readFileSync (node:fs:464:35)
actual  |     at getGroupDb (file:///app/src/sync-simple.js:12:21)
actual  |     at Module.sync (file:///app/src/sync-simple.js:52:16)
actual  |     at file:///app/src/app-sync.js:76:46
actual  |     at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
actual  |     at next (/app/node_modules/express/lib/router/route.js:149:13)
actual  |     at Route.dispatch (/app/node_modules/express/lib/router/route.js:119:3)
actual  |     at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5)
actual  |     at /app/node_modules/express/lib/router/index.js:284:15 {
actual  |   errno: -2,
actual  |   syscall: 'open',
actual  |   code: 'ENOENT',
actual  |   path: '/app/src/sql/messages.sql'
actual  | }

My other budget file works as expected

How can we reproduce the issue?

  • Reset sync on mobile (how I did it at least)
  • It spun repeatedly, then sent a time-out alert / popup, with the error above in the logs
  • Cleared site data to re-download (both mobile and laptop)
  • See the error above, often with the site timeout error
  • Sometimes, refreshing after that will load the budget file on screen, but "sync" will be continually spinning.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox, Chrome

Operating System

Linux

Originally created by @duplaja on GitHub (May 10, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/4969 ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? After resetting sync, I'm unable to download my budget file on any device. Latest nightly, as of 5/10/25 * Have cleared local cache, etc. * It did download once but then couldn't sync (kept spinning / trying to sync) Log is full of this error: ``` actual | 2025-05-10T11:39:44.272Z info: GET 304 /sync/list-user-files actual | 2025-05-10T11:39:46.469Z info: GET 304 /sync/download-user-file actual | 2025-05-10T11:39:46.475Z info: GET 304 /sync/get-user-file-info actual | Rejection: SqliteError: no such table: messages_binary actual | at Database.prepare (/app/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21) actual | at WrappedDatabase.all (file:///app/src/db.js:11:30) actual | at Module.sync (file:///app/src/sync-simple.js:53:28) actual | at file:///app/src/app-sync.js:76:46 actual | at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5) actual | at next (/app/node_modules/express/lib/router/route.js:149:13) actual | at Route.dispatch (/app/node_modules/express/lib/router/route.js:119:3) actual | at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5) actual | at /app/node_modules/express/lib/router/index.js:284:15 actual | at Function.process_params (/app/node_modules/express/lib/router/index.js:346:12) { actual | code: 'SQLITE_ERROR' actual | } ``` If I do get it to load, exporting and re-importing gives the following error: ``` actual | 2025-05-10T11:48:46.202Z info: POST 200 /sync/upload-user-file actual | 2025-05-10T11:48:46.288Z info: GET 304 /account/validate actual | Rejection: Error: ENOENT: no such file or directory, open '/app/src/sql/messages.sql' actual | at Object.openSync (node:fs:596:3) actual | at readFileSync (node:fs:464:35) actual | at getGroupDb (file:///app/src/sync-simple.js:12:21) actual | at Module.sync (file:///app/src/sync-simple.js:52:16) actual | at file:///app/src/app-sync.js:76:46 actual | at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5) actual | at next (/app/node_modules/express/lib/router/route.js:149:13) actual | at Route.dispatch (/app/node_modules/express/lib/router/route.js:119:3) actual | at Layer.handle [as handle_request] (/app/node_modules/express/lib/router/layer.js:95:5) actual | at /app/node_modules/express/lib/router/index.js:284:15 { actual | errno: -2, actual | syscall: 'open', actual | code: 'ENOENT', actual | path: '/app/src/sql/messages.sql' actual | } ``` My other budget file works as expected ### How can we reproduce the issue? * Reset sync on mobile (how I did it at least) * It spun repeatedly, then sent a time-out alert / popup, with the error above in the logs * Cleared site data to re-download (both mobile and laptop) * See the error above, often with the site timeout error * Sometimes, refreshing after that will load the budget file on screen, but "sync" will be continually spinning. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox, Chrome ### Operating System Linux
GiteaMirror added the bug label 2026-04-26 04:27:48 -05:00
GiteaMirror commented 2026-04-26 04:27:51 -05:00
Author
Owner
Copy Link

@duplaja commented on GitHub (May 10, 2025):

Reverting back 24 hours (right before I updated) was not able to fix the issue. Reverting back to the 7th did fix it for me, but I can't say for sure when I updated prior to that (I'd guess a few days)

<!-- gh-comment-id:2868779103 --> @duplaja commented on GitHub (May 10, 2025): Reverting back 24 hours (right before I updated) was not able to fix the issue. Reverting back to the 7th did fix it for me, but I can't say for sure when I updated prior to that (I'd guess a few days)
GiteaMirror commented 2026-04-26 04:27:52 -05:00
Author
Owner
Copy Link

@MikesGlitch commented on GitHub (May 10, 2025):

This was fixed here: https://github.com/actualbudget/actual/pull/4968

It should go in with the next edge tonight.

<!-- gh-comment-id:2869000533 --> @MikesGlitch commented on GitHub (May 10, 2025): This was fixed here: https://github.com/actualbudget/actual/pull/4968 It should go in with the next edge tonight.
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#43772
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?