Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

database locked (when on Dropbox, Google Drive or other network drives) #633

Closed
iffy opened this issue Nov 8, 2021 · 5 comments
Closed
Labels
bug Things that prevent or seriously impede people from doing their budget. included in next release The work is done, it's just waiting to be released.

Comments

@iffy
Copy link
Contributor

iffy commented Nov 8, 2021

Version: 0.62.0 (node: v12.4.0)
OS: win32 10.0.19042 x64
Lang: en English
Loc: file:///C:/Program%20Files/Buckets%20Beta/resources/app.asar/src/wwwroot/misc/wizard.html

[2021-11-05 12:02:39.041] [info] (core) INFO Opening file C:\Users\USERNAME\Dropbox\Mac Documents\Budgets\2021 Fresh.buckets
[2021-11-05 12:02:39.041] [info] (core) INFO (dbpatch) start
[2021-11-05 12:02:39.076] [error] (files) Error opening file: C:\Users\USERNAME\Dropbox\Mac Documents\BUdgets\2021 Fresh.buckets
[2021-11-05 12:02:39.079] [error] (files) Error: database is locked (5)
    at BucketsBackendRPCWrap.<anonymous> (C:\Program Files\Buckets Beta\resources\app.asar\node_modules\buckets-common\dist\src\backend-base.js:128:40)
...
@iffy iffy added the bug Things that prevent or seriously impede people from doing their budget. label Nov 8, 2021
@iffy
Copy link
Contributor Author

iffy commented Nov 29, 2021

Version: 0.62.0 (node: v12.4.0)
OS: win32 10.0.19043 x64
Lang: en English
Loc: file:///C:/Program%20Files/Buckets%20Beta/resources/app.asar/src/wwwroot/misc/wizard.html
Error: database is locked (5)
    at BucketsBackendRPCWrap.<anonymous> (C:\Program Files\Buckets Beta\resources\app.asar\node_modules\buckets-common\dist\src\backend-base.js:128:40)

@dpendolino
Copy link

Same thing happening to me when my buckets file is stored on an NFS share:

❯ buckets
(persistent) Loading persistent state...
[15:11:17.119] [info] (main)

STARTING v0.60.0

[15:11:17.121] [info] (main)  Log level: silly
[15:11:17.121] [info] (main) Local date: 2022-01-14
[15:11:17.121] [info] (main) Local time: 2022-01-14 15:11:17-05:00
[15:11:17.121] [info] (main)   UTC time: 2022-01-14T20:11:17Z
[15:11:17.122] [info] (main)   NODE_ENV: undefined
[15:11:17.122] [info] (main)        pid: 356001
Fontconfig warning: "/usr/share/fontconfig/conf.avail/05-reset-dirs-sample.conf", line 6: unknown element "reset-dirs"
[15:11:17.238] [info] (buckets-node) ProcessBackend starting...
[15:11:17.248] [info] locale set to: en
[15:11:17.249] [info] number format set: {"group":",","group_regex":{},"decimal":".","decimal_regex":{}}
[15:11:17.251] [info] (i18n) date format set
[15:11:17.337] [info] (main) Checking for updates...
[15:11:17.347] [info] (core) INFO (bucketsproc) started
[15:11:17.347] [info] (core) INFO Piping notification to RPC
[15:11:17.347] [info] (core) INFO (bucketsproc) ready for input
[15:11:17.347] [info] (core) INFO (dbpatch) start
[15:11:17.347] [info] (core) DEBUG (dbpatch) existing patches: @["0001-initial"]
[15:11:17.347] [info] (core) DEBUG (dbpatch) patch 0001-initial already applied
[15:11:17.347] [info] (core) INFO (dbpatch) end
[15:11:17.347] [info] (core) DEBUG (peddler) loop starting ...
[15:11:17.366] [info] (main) window opened to file:///opt/Buckets/resources/app.asar/src/wwwroot/misc/wizard.html
[15:11:25.616] [info] (files) opening /mnt/bigdata/Buckets/Test.buckets
[15:11:25.617] [info] (core) INFO Opening file /mnt/bigdata/Buckets/Test.buckets
[15:11:25.618] [info] (core) INFO (dbpatch) start
[15:11:25.620] [info] (core) DEBUG (dbpatch) existing patches: @["0001-initial", "0002-import_balance", "0003-deletetrans", "0004-dearhacker", "0005-bankmacro", "0006-closeaccount", "0007-notes", "0008-csvimport", "0009-triggercontrol-andundo", "0010-postedtolocal", "0011-nullamounttriggers", "0012-settings", "0013-offbudget", "0014-cleared", "0015-debt-accounts", "0016-null_general_cat_cleanup", "0017-transaction_linked_id_posted_index"]
[15:11:25.620] [info] (core) DEBUG (dbpatch) patch 0001-initial already applied
[15:11:25.620] [info] (core) DEBUG (dbpatch) patch 0002-import_balance already applied
[15:11:25.620] [info] (core) DEBUG (dbpatch) patch 0003-deletetrans already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0004-dearhacker already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0005-bankmacro already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0006-closeaccount already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0007-notes already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0008-csvimport already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0009-triggercontrol-andundo already applied
[15:11:25.621] [info] (core) DEBUG (dbpatch) patch 0010-postedtolocal already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0011-nullamounttriggers already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0012-settings already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0013-offbudget already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0014-cleared already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0015-debt-accounts already applied
[15:11:25.622] [info] (core) DEBUG (dbpatch) patch 0016-null_general_cat_cleanup already applied
[15:11:25.623] [info] (core) DEBUG (dbpatch) patch 0017-transaction_linked_id_posted_index already applied
[15:11:25.623] [info] (core) INFO (dbpatch) end
[15:11:25.623] [info] (core) INFO Touched local budget file: 3
[15:11:25.623] [info] (core) DEBUG initializing undo...
[15:11:25.623] [info] (core) DEBUG initializing events...
[15:11:25.623] [info] (core) DEBUG enabling undo...
[15:11:25.626] [info] (core) DEBUG enabling events...
[15:11:25.634] [info] (core) DEBUG Done opening budget file
[15:11:25.649] [info] (files) SQLite: 3.35.0
[15:11:25.657] [error] (dbsetup) Error enabling triggers
[15:11:25.659] [error] (dbsetup) Error: database is locked (5)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:128:40)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.rpcResultReceived (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:119:16)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:112:26)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.handleSingleBackendMessage (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:104:16)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:97:56)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.handleBackendOutput (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:82:16)
    at NetstringParser.handler (/opt/Buckets/resources/app.asar/node_modules/buckets-node/dist/main.js:221:35)
[15:11:25.659] [error] (files) Error opening file: /mnt/bigdata/Buckets/Test.buckets
[15:11:25.659] [error] (files) Error: database is locked (5)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:128:40)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.rpcResultReceived (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:119:16)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:112:26)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.handleSingleBackendMessage (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:104:16)
    at BucketsBackendRPCWrap.<anonymous> (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:97:56)
    at step (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:33:23)
    at Object.next (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:14:53)
    at /opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:8:71
    at new Promise (<anonymous>)
    at __awaiter (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:4:12)
    at BucketsBackendRPCWrap.handleBackendOutput (/opt/Buckets/resources/app.asar/node_modules/buckets-common/dist/src/backend-base.js:82:16)
    at NetstringParser.handler (/opt/Buckets/resources/app.asar/node_modules/buckets-node/dist/main.js:221:35)
[15:11:30.883] [info] (main) saving last_opened_windows []

I'm able to open the file as a sqlite database without issue and I can't find anything to point to why the database is reported as being locked.

@iffy
Copy link
Contributor Author

iffy commented Feb 1, 2022

Another report: 20211104-nMpzscpS
Version: 0.62.0 (node: v12.4.0)
OS: win32 10.0.19042 x64
Lang: en English

@iffy iffy changed the title database locked (when on Dropbox or Google Drive) database locked (when on Dropbox, Google Drive or other network drives) Oct 31, 2022
@iffy
Copy link
Contributor Author

iffy commented Oct 31, 2022

Version: 0.68.0 (node: v12.4.0)
OS: win32 10.0.22000 x64
Lang: en English
Loc: file:///C:/Program%20Files/Buckets%20Beta/resources/app.asar/src/wwwroot/misc/wizard.html
Error: BucketsLib not started (pid:24996)

[2022-10-28 14:04:46.366] [info] (core) db.nim(179)              raiseErr
[2022-10-28 14:04:46.366] [info] (core) Error: unhandled exception: database is locked (5) [DbError]
[2022-10-28 14:04:46.366] [info] (buckets-node) ProcessBackend exit 1 null
[2022-10-28 14:04:46.366] [error] (core) Error: BucketsLib bin died: 1/null
    at ChildProcess.<anonymous> (C:\Program Files\Buckets Beta\resources\app.asar\node_modules\buckets-node\dist\main.js:280:44)
    at ChildProcess.emit (events.js:200:13)
    at Process.ChildProcess._handle.onexit (internal/child_process.js:272:12)

@iffy iffy added the included in next release The work is done, it's just waiting to be released. label Jan 4, 2024
@iffy
Copy link
Contributor Author

iffy commented Jan 5, 2024

Included in v0.73.0 release (AUTOMATED COMMENT)

@iffy iffy closed this as completed Jan 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Things that prevent or seriously impede people from doing their budget. included in next release The work is done, it's just waiting to be released.
Projects
None yet
Development

No branches or pull requests

2 participants