Mintplex-Labs/anything-llm
1
0
Fork 0
mirror of https://github.com/Mintplex-Labs/anything-llm.git synced 2026-07-22 10:05:25 -04:00
Code Issues 328 Packages Projects Releases 10 Wiki Activity

[GH-ISSUE #44] [lancedb] SQLITE_BUSY when embedding many documents #29

New Issue
Closed
opened 2026-02-22 18:17:33 -05:00 by yindo · 4 comments
yindo commented 2026-02-22 18:17:33 -05:00
Owner
Copy Link
Copy Source

Originally created by @danglingptr0x0 on GitHub (Jun 13, 2023).
Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/44

When embedding a larger number of docs (> 100 (>100k tokens)), the DB seems to lock itself during the process (using lancedb as vector db):

INSERT INTO document_vectors (docId, vectorId) VALUES ('f03e0ec4-1307-4928-b982-91a8a2e34563', '5a791ec8-f1be-4276-8928-5e129accc0d6')
{ result: 0 }
node:internal/process/promises:288
            triggerUncaughtException(err, true /* fromPromise */);
            ^

Error: SQLITE_BUSY: database is locked
--> in Statement#run([
  '4f09f8e7-b1a8-4c0b-82e0-bbde80473612',
  '05-26-2023-db4e845d-9c45-4d80-9581-73c53844132c.json',
  'custom-documents/05-26-2023-db4e845d-9c45-4d80-9581-73c53844132c.json',
  2,
  '{"id":"db4e845d-9c45-4d80-9581-73c53844132c","url":"file:///home/<username>/git/anything-llm/collector/hotdir/processed/05-26-2023.md","title":"05-26-2023.md","description":"a custom file uploaded by the user.","published":"2023-06-12 09:26:29","wordCount":12758,"token_count_estimate":2849}'
], [Function (anonymous)])
    at /home/<username>/git/anything-llm/server/node_modules/sqlite/build/Statement.js:80:23
    at new Promise (<anonymous>)
    at Statement.run (/home/<username>/git/anything-llm/server/node_modules/sqlite/build/Statement.js:78:16)
    at Object.addDocuments (/home/<username>/git/anything-llm/server/models/documents.js:89:12)
    at async /home/<username>/git/anything-llm/server/endpoints/workspaces.js:35:7 {
  errno: 5,
  code: 'SQLITE_BUSY',
  __augmented: true
}

Node.js v18.16.0
[nodemon] app crashed - waiting for file changes before starting...

Cannot tell if this is caused by the larger number of docs or if the issue is caused by token count (as in, the issue would be caused even with low doc but high token count).

Originally created by @danglingptr0x0 on GitHub (Jun 13, 2023). Original GitHub issue: https://github.com/Mintplex-Labs/anything-llm/issues/44 When embedding a larger number of docs (> 100 (>100k tokens)), the DB seems to lock itself during the process (using lancedb as vector db): ``` INSERT INTO document_vectors (docId, vectorId) VALUES ('f03e0ec4-1307-4928-b982-91a8a2e34563', '5a791ec8-f1be-4276-8928-5e129accc0d6') { result: 0 } node:internal/process/promises:288 triggerUncaughtException(err, true /* fromPromise */); ^ Error: SQLITE_BUSY: database is locked --> in Statement#run([ '4f09f8e7-b1a8-4c0b-82e0-bbde80473612', '05-26-2023-db4e845d-9c45-4d80-9581-73c53844132c.json', 'custom-documents/05-26-2023-db4e845d-9c45-4d80-9581-73c53844132c.json', 2, '{"id":"db4e845d-9c45-4d80-9581-73c53844132c","url":"file:///home/<username>/git/anything-llm/collector/hotdir/processed/05-26-2023.md","title":"05-26-2023.md","description":"a custom file uploaded by the user.","published":"2023-06-12 09:26:29","wordCount":12758,"token_count_estimate":2849}' ], [Function (anonymous)]) at /home/<username>/git/anything-llm/server/node_modules/sqlite/build/Statement.js:80:23 at new Promise (<anonymous>) at Statement.run (/home/<username>/git/anything-llm/server/node_modules/sqlite/build/Statement.js:78:16) at Object.addDocuments (/home/<username>/git/anything-llm/server/models/documents.js:89:12) at async /home/<username>/git/anything-llm/server/endpoints/workspaces.js:35:7 { errno: 5, code: 'SQLITE_BUSY', __augmented: true } Node.js v18.16.0 [nodemon] app crashed - waiting for file changes before starting... ``` Cannot tell if this is caused by the larger number of docs or if the issue is caused by token count (as in, the issue would be caused even with low doc but high token count).
yindo added the questionbug labels 2026-02-22 18:17:33 -05:00
yindo closed this issue 2026-02-22 18:17:33 -05:00
yindo commented 2026-02-22 18:17:33 -05:00
Author
Owner
Copy Link
Copy Source

@timothycarambat commented on GitHub (Jun 13, 2023):

connect #19

@timothycarambat commented on GitHub (Jun 13, 2023): connect #19
yindo commented 2026-02-22 18:17:33 -05:00
Author
Owner
Copy Link
Copy Source

@timothycarambat commented on GitHub (Jun 13, 2023):

This should be resolved now with #19!

Can you pull in an try again? Was a concurrency issue with SQLite

@timothycarambat commented on GitHub (Jun 13, 2023): This should be resolved now with #19! Can you pull in an try again? Was a concurrency issue with SQLite
yindo commented 2026-02-22 18:17:33 -05:00
Author
Owner
Copy Link
Copy Source

@danglingptr0x0 commented on GitHub (Jun 13, 2023):

This should be resolved now with #19!

Can you pull in an try again? Was a concurrency issue with SQLite

Will do! Thank you :-)

@danglingptr0x0 commented on GitHub (Jun 13, 2023): > This should be resolved now with #19! > > Can you pull in an try again? Was a concurrency issue with SQLite Will do! Thank you :-)
yindo commented 2026-02-22 18:17:33 -05:00
Author
Owner
Copy Link
Copy Source

@danglingptr0x0 commented on GitHub (Jun 14, 2023):

Seems to have been fixed! Closing as complete ...

Thanks

@danglingptr0x0 commented on GitHub (Jun 14, 2023): Seems to have been fixed! Closing as complete ... Thanks
yindo changed title from [lancedb] SQLITE_BUSY when embedding many documents to [GH-ISSUE #44] [lancedb] SQLITE_BUSY when embedding many documents 2026-06-05 14:33:05 -04:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
Desktop
Docker
Integration Request
Integration Request
OS: Linux
OS: Mobile
OS: Windows
UI/UX
blocked
bug
bug
core-team-only
documentation
duplicate
embed-widget
enhancement
feature request
github_actions
good first issue
investigating
needs info / can't replicate
possible bug
pull-request
Mirrored from GitHub Pull Request
 question
stage: specifications
wontfix
No Label bug question
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
yindo
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Mintplex-Labs/anything-llm#29
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?