github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-07-16 07:04:23 -05:00
Code Issues 3.0k Packages Projects Releases 58 Wiki Activity

[Bug]: database disk image is malformed after SELECT * FROM kvcache #2189

New Issue
Closed
opened 2026-02-28 20:05:57 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-02-28 20:05:57 -06:00
Owner
Copy Link

Originally created by @tbekolay on GitHub (Jun 11, 2025).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

I am running two instances of ActualBudget on my home server. Both were running v25.5.0 and I upgraded them to v25.6.1. One of the installations no longer works after upgrading. docker compose log does not give me much information, but in the devtools console I see the following when I try to open up the budget file.

triggering sync because of visibility change index.DKFLRj7l.js:300:6999
Unknown locale en-US, falling back to en i18n.ts:60:14
Backend: Trying to connect to client kcab.worker.473433500a37746bffd1.js:121:30413
Backend: Client connected kcab.worker.473433500a37746bffd1.js:121:29393
MouseEvent.mozInputSource is deprecated. Use PointerEvent.pointerType instead. isVirtualEvent.mjs:16:4
Reading meta... 5fc9ada8-8164-412a-adbf-c8a41a6c16ab:1:7805
Got meta for documents-Actual-My-Finances-9be0934-db.sqlite: 
Object { size: 1060864 }
5fc9ada8-8164-412a-adbf-c8a41a6c16ab:1:7861
Opened! kcab.worker.473433500a37746bffd1.js:86:98
SELECT * FROM kvcache kcab.worker.473433500a37746bffd1.js:121:75954
[Exception] Error: database disk image is malformed
    handleError https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:84
    step https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:84
    runQuery https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:121
    loadSpreadsheet https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:221
    _loadBudget https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:432
kcab.worker.473433500a37746bffd1.js:121:26822

How can we reproduce the issue?

The budget file I'm trying to open is here, let me know if you need any of the other files. I'm comfortable modifying this manually if need be. I cannot see anything meaningfully different in this file versus the file in the other installation.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

Originally created by @tbekolay on GitHub (Jun 11, 2025). ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? I am running two instances of ActualBudget on my home server. Both were running v25.5.0 and I upgraded them to v25.6.1. One of the installations no longer works after upgrading. `docker compose log` does not give me much information, but in the devtools console I see the following when I try to open up the budget file. ``` triggering sync because of visibility change index.DKFLRj7l.js:300:6999 Unknown locale en-US, falling back to en i18n.ts:60:14 Backend: Trying to connect to client kcab.worker.473433500a37746bffd1.js:121:30413 Backend: Client connected kcab.worker.473433500a37746bffd1.js:121:29393 MouseEvent.mozInputSource is deprecated. Use PointerEvent.pointerType instead. isVirtualEvent.mjs:16:4 Reading meta... 5fc9ada8-8164-412a-adbf-c8a41a6c16ab:1:7805 Got meta for documents-Actual-My-Finances-9be0934-db.sqlite: Object { size: 1060864 } 5fc9ada8-8164-412a-adbf-c8a41a6c16ab:1:7861 Opened! kcab.worker.473433500a37746bffd1.js:86:98 SELECT * FROM kvcache kcab.worker.473433500a37746bffd1.js:121:75954 [Exception] Error: database disk image is malformed handleError https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:84 step https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:84 runQuery https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:121 loadSpreadsheet https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:221 _loadBudget https://budget.bekolay.org/kcab/kcab.worker.473433500a37746bffd1.js:432 kcab.worker.473433500a37746bffd1.js:121:26822 ``` ### How can we reproduce the issue? The budget file I'm trying to open is [here](https://drive.google.com/file/d/1uyc81lzqY326I_U0kKVByk1wLwvMJ730/view?usp=drive_link), let me know if you need any of the other files. I'm comfortable modifying this manually if need be. I cannot see anything meaningfully different in this file versus the file in the other installation. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox ### Operating System Linux
GiteaMirror added the needs infobug labels 2026-02-28 20:05:57 -06:00
GiteaMirror commented 2026-02-28 20:05:57 -06:00
Author
Owner
Copy Link

@alecbakholdin commented on GitHub (Jun 11, 2025):

I was able to import this file without issue on https://edge.actualbudget.com

Can you give a little more detail on when this issue is occurring? Is it occurring browser side?

2025-06-11-Test Budget 2.zip

@alecbakholdin commented on GitHub (Jun 11, 2025): I was able to import this file without issue on https://edge.actualbudget.com Can you give a little more detail on when this issue is occurring? Is it occurring browser side? [2025-06-11-Test Budget 2.zip](https://github.com/user-attachments/files/20691050/2025-06-11-Test.Budget.2.zip)
GiteaMirror commented 2026-02-28 20:05:58 -06:00
Author
Owner
Copy Link

@tbekolay commented on GitHub (Jun 11, 2025):

It was occurring on the browser, yes. I'm still not sure what happened, but perhaps there was some mismatch between something cached locally and the files on the server.

Since you were able to import it, I tried duplicating the file from the browser and that worked. I was then able to open the duplicated file. I still can't open the one that was giving me the error, but as long as this works around it I'm happy.

If anyone is experiencing a similar issue in the future, it's worth trying to duplicate the budget file that's having issues and seeing if you can open the duplicate.

Thanks @alecbakholdin!

@tbekolay commented on GitHub (Jun 11, 2025): It was occurring on the browser, yes. I'm still not sure what happened, but perhaps there was some mismatch between something cached locally and the files on the server. Since you were able to import it, I tried duplicating the file from the browser and that worked. I was then able to open the duplicated file. I still can't open the one that was giving me the error, but as long as this works around it I'm happy. If anyone is experiencing a similar issue in the future, it's worth trying to duplicate the budget file that's having issues and seeing if you can open the duplicate. Thanks @alecbakholdin!
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
tech-support
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug needs info
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#2189
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?