[Bug]: New server: Failed to copy SQL file from /default-db.sqlite #2362

Closed
opened 2026-02-28 20:11:54 -06:00 by GiteaMirror · 7 comments
Owner

Originally created by @diegodemorais on GitHub (Aug 6, 2025).

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

A bug happened!
I just installed ther server version on a Windows 2016 Standard, with no error (some warnings).
After starting the service and trying to access the http://localhost:5006, I was able to define my password and than to choose between "Demo" or "Fresh start". Both of options give me the error:
Something internally went wrong. You may want to restart the app if anything looks wrong. Please report this as a new issue on Github"
And, on the page, says "Creating budget" forever.

I verified about this issue and I wasn't able to find any answer. Sorry if there is.
Thanks in advance!

Diego

How can we reproduce the issue?

How can we reproduce the issue?

Where are you hosting Actual?

None

What browsers are you seeing the problem on?

No response

Operating System

None

Originally created by @diegodemorais on GitHub (Aug 6, 2025). ### Verified issue does not already exist? - [ ] I have searched and found no existing issue ### What happened? A bug happened! I just installed ther server version on a Windows 2016 Standard, with no error (some warnings). After starting the service and trying to access the http://localhost:5006, I was able to define my password and than to choose between "Demo" or "Fresh start". Both of options give me the error: Something internally went wrong. You may want to restart the app if anything looks wrong. Please report this as a new issue on Github" And, on the page, says "Creating budget" forever. I verified about this issue and I wasn't able to find any answer. Sorry if there is. Thanks in advance! Diego ### How can we reproduce the issue? How can we reproduce the issue? ### Where are you hosting Actual? None ### What browsers are you seeing the problem on? _No response_ ### Operating System None
GiteaMirror added the needs infobug labels 2026-02-28 20:11:54 -06:00
Author
Owner

@matt-fidd commented on GitHub (Aug 6, 2025):

Hey! Could you try and open the console window and have a look at the logs please? F12 in the browser, and then click over to the console tab should show some errors in red. Could you send them in here?

@matt-fidd commented on GitHub (Aug 6, 2025): Hey! Could you try and open the console window and have a look at the logs please? F12 in the browser, and then click over to the console tab should show some errors in red. Could you send them in here?
Author
Owner

@diegodemorais commented on GitHub (Aug 6, 2025):

Hey matt, thanks for your answer.
Image:
Image

Text:
Sure, here it goes:
index.ts:113 Backend: Trying to connect to client
index.ts:49 Backend: Client connected
index.ts:2 [Exception] Error: Failed to copy SQL file from /default-db.sqlite to /documents/Actual/My-Finances-6c29e19/db.sqlite: Cannot read properties of undefined (reading 'filepath')
at copyFile (index.web.ts:342:15)
at async app_createBudget (app.ts:428:3)
captureException @ index.ts:2
(anonymous) @ index.ts:86
Promise.then
(anonymous) @ index.ts:57
index.web.ts:342 Uncaught (in promise) Error: Failed to copy SQL file from /default-db.sqlite to /documents/Actual/My-Finances-6c29e19/db.sqlite: Cannot read properties of undefined (reading 'filepath')
at copyFile (index.web.ts:342:15)
at async app_createBudget (app.ts:428:3)
copyFile @ index.web.ts:342
await in copyFile
app_createBudget @ app.ts:428
await in app_createBudget
runHandler @ mutators.ts:67
(anonymous) @ index.ts:57

Thanks in advance.

@diegodemorais commented on GitHub (Aug 6, 2025): Hey matt, thanks for your answer. Image: <img width="1414" height="665" alt="Image" src="https://github.com/user-attachments/assets/c8c0f7c1-4162-4f8b-9387-131ffc642266" /> Text: Sure, here it goes: index.ts:113 Backend: Trying to connect to client index.ts:49 Backend: Client connected index.ts:2 [Exception] Error: Failed to copy SQL file from /default-db.sqlite to /documents/Actual/My-Finances-6c29e19/db.sqlite: Cannot read properties of undefined (reading 'filepath') at copyFile (index.web.ts:342:15) at async app_createBudget (app.ts:428:3) captureException @ index.ts:2 (anonymous) @ index.ts:86 Promise.then (anonymous) @ index.ts:57 index.web.ts:342 Uncaught (in promise) Error: Failed to copy SQL file from /default-db.sqlite to /documents/Actual/My-Finances-6c29e19/db.sqlite: Cannot read properties of undefined (reading 'filepath') at copyFile (index.web.ts:342:15) at async app_createBudget (app.ts:428:3) copyFile @ index.web.ts:342 await in copyFile app_createBudget @ app.ts:428 await in app_createBudget runHandler @ mutators.ts:67 (anonymous) @ index.ts:57 Thanks in advance.
Author
Owner

@youngcw commented on GitHub (Aug 7, 2025):

@MikesGlitch Any thoughts?

@youngcw commented on GitHub (Aug 7, 2025): @MikesGlitch Any thoughts?
Author
Owner

@MikesGlitch commented on GitHub (Aug 7, 2025):

@MikesGlitch Any thoughts?

No idea, but I'm assuming it's indexdb related/something isn't stored when it should be.

Results in an undefined here: e21256e7a2/packages/loot-core/src/platform/server/fs/index.web.ts (L170)

@diegodemorais How are you running the server? Are you using CLI tool/Docker? Have you tried other browsers?

@MikesGlitch commented on GitHub (Aug 7, 2025): > [@MikesGlitch](https://github.com/MikesGlitch) Any thoughts? No idea, but I'm assuming it's indexdb related/something isn't stored when it should be. Results in an undefined here: https://github.com/actualbudget/actual/blob/e21256e7a20abedf8edb86def838506399e61552/packages/loot-core/src/platform/server/fs/index.web.ts#L170 @diegodemorais How are you running the server? Are you using CLI tool/Docker? Have you tried other browsers?
Author
Owner

@diegodemorais commented on GitHub (Aug 7, 2025):

Hi guys.
Thank you for the attention.
I have downloaded the source and built from there.
The SO is a Windows Server 2016 Standard. Is it Windows-compatible?
I guess the problem is related to configuration file, reading the 'filepath'.

@diegodemorais commented on GitHub (Aug 7, 2025): Hi guys. Thank you for the attention. I have downloaded the source and built from there. The SO is a Windows Server 2016 Standard. Is it Windows-compatible? I guess the problem is related to configuration file, reading the 'filepath'.
Author
Owner

@joel-jeremy commented on GitHub (Sep 11, 2025):

@diegodemorais Were you able to do a yarn build:browser before running? It looks like the default db file was not copied over to the data directory.

@joel-jeremy commented on GitHub (Sep 11, 2025): @diegodemorais Were you able to do a `yarn build:browser` before running? It looks like the default db file was not copied over to the data directory.
Author
Owner

@github-actions[bot] commented on GitHub (Oct 7, 2025):

This issue has been automatically closed because there have been no comments for 7 days after the "needs info" label was added. If you still need help, please feel free to reopen the issue with the requested information.

@github-actions[bot] commented on GitHub (Oct 7, 2025): This issue has been automatically closed because there have been no comments for 7 days after the "needs info" label was added. If you still need help, please feel free to reopen the issue with the requested information.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#2362