sqlite3.OperationalError: database is locked
I can't add new documents anymore. The adding was sometimes buggy in the past. Now it doesn't work anymore.
It seems to be a problem with python.
Edit: 2022-04-02 I find out that the issue has something to do with changing the working directory and yes there are multiple processes.
terminal output
[INFO ] [paperwork_backend.guesswork.orientation.pyocr] Using OCR to guess orientation of page 0 of file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36
[INFO ] [paperwork_backend.guesswork.orientation.pyocr] Orientation guessing: Will use tool 'Tesseract (sh)'
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'cropping' has started (0 already active)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'orientation_guesser' has started (1 already active)
[INFO ] [paperwork_backend.guesswork.ocr.pyocr] Running OCR on page 0 of file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36
[INFO ] [paperwork_backend.guesswork.ocr.pyocr] Will use tool 'Tesseract (sh)' on file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36 p0 (file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36/paper.1.jpg)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'orientation_guesser' has ended
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'orientation_guesser' has ended (1 remaining)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'ocr' has started (1 already active)
[INFO ] [paperwork_gtk.mainwindow.docview.pageview] URL for file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36 p0: file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36/paper.1.jpg
[INFO ] [paperwork_gtk.mainwindow.docview.pageview] Page 0: size 2556 x 3513
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'loading_page_sizes' has started (2 already active)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'boxes' has started (3 already active)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'ocr' has ended
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'ocr' has ended (3 remaining)
[INFO ] [paperwork_gtk.mainwindow.docview.pageview] Page 0: size 2556 x 3513
[INFO ] [paperwork_backend.guesswork.label.sklearn] Guessing labels on file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36
[INFO ] [paperwork_backend.guesswork.label.sklearn] (1, 18855) features extracted
[INFO ] [paperwork_backend.guesswork.label.sklearn] Documents contains 64 features
[INFO ] [openpaperwork_core.spatial.rtree] Loading 80 boxes in rtree
[INFO ] [paperwork_gtk.mainwindow.docview.pageview.boxes] Page 20220204_1510_36 0: 18 line boxes loaded
[ERROR ] [paperwork_backend.sync ] Transactions have failed
Traceback (most recent call last):
File "/usr/lib/python3.10/site-packages/paperwork_backend/sync.py", line 261, in _transaction_simple
transaction.add_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 573, in add_doc
self._upd_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 609, in _upd_doc
self._del_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 588, in _del_doc
self.cursor.execute("DELETE FROM labels WHERE doc_id = ?", (doc_id,))
sqlite3.OperationalError: database is locked
[INFO ] [paperwork_backend.index.whoosh] Canceling transaction
[WARNING] [openpaperwork_core.promise ] === caught exception in promise ===
Traceback (most recent call last):
File "/usr/lib/python3.10/site-packages/openpaperwork_core/promise.py", line 233, in _threaded_do
our_r = self.func(*args, **self.kwargs)
File "/usr/lib/python3.10/site-packages/paperwork_backend/sync.py", line 261, in _transaction_simple
transaction.add_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 573, in add_doc
self._upd_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 609, in _upd_doc
self._del_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 588, in _del_doc
self.cursor.execute("DELETE FROM labels WHERE doc_id = ?", (doc_id,))
sqlite3.OperationalError: database is locked
[WARNING] [openpaperwork_core.promise ] promise.func=.notify_end at 0x7f3717528790>
[WARNING] [openpaperwork_core.promise ] promise.args=(0, '20220204_1510_36')
[WARNING] [openpaperwork_core.promise ] promise.kwargs={}
[WARNING] [openpaperwork_core.promise ] promise.parent=ThreadedPromise<>>(139874943755856)
[WARNING] [openpaperwork_core.promise ] promise.parent_promise_return=None
[WARNING] [openpaperwork_core.promise ] === Promise was created by ===
[WARNING] [openpaperwork_core.promise ] 0: /usr/lib/python3.10/threading.py: L 966: _bootstrap
[WARNING] [openpaperwork_core.promise ] 1: /usr/lib/python3.10/threading.py: L 1009: _bootstrap_inner
[WARNING] [openpaperwork_core.promise ] 2: /usr/lib/python3.10/site-packages/openpaperwork_core/thread/pool.py: L 27: run
[WARNING] [openpaperwork_core.promise ] 3: /usr/lib/python3.10/site-packages/openpaperwork_core/thread/__init__.py: L 27: do
[WARNING] [openpaperwork_core.promise ] 4: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 233: _threaded_do
[WARNING] [openpaperwork_core.promise ] 5: /usr/lib/python3.10/site-packages/paperwork_backend/docscan/scan2doc.py: L 134: run_transactions
[WARNING] [openpaperwork_core.promise ] 6: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 53: then
[WARNING] [openpaperwork_core.promise ] 7: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 35: __init__
[INFO ] [openpaperwork_gtk.fs.gio ] Deleting file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36 ...
[INFO ] [openpaperwork_gtk.fs.gio ] file:///mnt/veracrypt1/Dokumente/Paperwork/Steuerrechtliches/20220204_1510_36 deleted
[ERROR ] [openpaperwork_gtk.mainloop.glib] Main loop: uncaught exception (.cancel at 0x7f37175281f0>) !
Traceback (most recent call last):
File "/usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py", line 159, in decorator
func(*args, **kwargs)
File "/usr/lib/python3.10/site-packages/paperwork_backend/docscan/scan2doc.py", line 122, in cancel
raise exc
File "/usr/lib/python3.10/site-packages/openpaperwork_core/promise.py", line 233, in _threaded_do
our_r = self.func(*args, **self.kwargs)
File "/usr/lib/python3.10/site-packages/paperwork_backend/sync.py", line 261, in _transaction_simple
transaction.add_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 573, in add_doc
self._upd_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 609, in _upd_doc
self._del_doc(doc_id)
File "/usr/lib/python3.10/site-packages/paperwork_backend/guesswork/label/sklearn/__init__.py", line 588, in _del_doc
self.cursor.execute("DELETE FROM labels WHERE doc_id = ?", (doc_id,))
sqlite3.OperationalError: database is locked
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'loading_page_sizes' has ended
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'loading_page_sizes' has ended (2 remaining)
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'boxes' has ended
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'boxes' has ended (1 remaining)
[WARNING] [openpaperwork_gtk.widgets.progress] Got 2 notifications of end of task for 'label_guesser'
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'cropping' has ended
[INFO ] [openpaperwork_gtk.widgets.progress] Task 'cropping' has ended (0 remaining)
[WARNING] [openpaperwork_gtk.widgets.progress] Got 2 notifications of end of task for 'orientation_guesser'
[WARNING] [openpaperwork_gtk.widgets.progress] Got 2 notifications of end of task for 'ocr'
[WARNING] [openpaperwork_gtk.widgets.progress] Got 2 notifications of end of task for 'index'
[WARNING] [openpaperwork_gtk.widgets.progress] Got 2 notifications of end of task for 'doctracker'
[WARNING] [openpaperwork_core.promise ] === caught exception in promise ===
Traceback (most recent call last):
File "/usr/lib/python3.10/site-packages/openpaperwork_core/promise.py", line 233, in _threaded_do
our_r = self.func(*args, **self.kwargs)
File "/usr/lib/python3.10/site-packages/openpaperwork_core/pillow/img.py", line 79, in url_to_pillow
with self.core.call_success("fs_open", file_url, mode='rb') as fd:
AttributeError: __enter__
[WARNING] [openpaperwork_core.promise ] promise.func=>
[WARNING] [openpaperwork_core.promise ] promise.args=()
[WARNING] [openpaperwork_core.promise ] promise.kwargs={}
[WARNING] [openpaperwork_core.promise ] promise.parent=Promise<>>(139874579041440)
[WARNING] [openpaperwork_core.promise ] promise.parent_promise_return=None
[WARNING] [openpaperwork_core.promise ] === Promise was created by ===
[WARNING] [openpaperwork_core.promise ] 0: /usr/bin/paperwork-gtk: L 33:
[WARNING] [openpaperwork_core.promise ] 1: /usr/lib/python3.10/site-packages/paperwork_gtk/main.py: L 216: main
[WARNING] [openpaperwork_core.promise ] 2: /usr/lib/python3.10/site-packages/paperwork_gtk/main.py: L 194: main_main
[WARNING] [openpaperwork_core.promise ] 3: /usr/lib/python3.10/site-packages/openpaperwork_core/__init__.py: L 454: call_one
[WARNING] [openpaperwork_core.promise ] 4: /usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py: L 65: mainloop
[WARNING] [openpaperwork_core.promise ] 5: /usr/lib/python3.10/site-packages/gi/overrides/GLib.py: L 497: run
[WARNING] [openpaperwork_core.promise ] 6: /usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py: L 159: decorator
[WARNING] [openpaperwork_core.promise ] 7: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 110: _do
[WARNING] [openpaperwork_core.promise ] 8: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 172: do
[WARNING] [openpaperwork_core.promise ] 9: /usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py: L 91: _run_next_promise_locked
[WARNING] [openpaperwork_core.promise ] 10: /usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py: L 85: _run_next_promise
[WARNING] [openpaperwork_core.promise ] 11: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 53: then
[WARNING] [openpaperwork_core.promise ] 12: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 35: __init__
[ERROR ] [openpaperwork_core.work_queue.default] === Promise was queued by ===
[ERROR ] [openpaperwork_core.work_queue.default] 0: /usr/bin/paperwork-gtk: L 33:
[ERROR ] [openpaperwork_core.work_queue.default] 1: /usr/lib/python3.10/site-packages/paperwork_gtk/main.py: L 216: main
[ERROR ] [openpaperwork_core.work_queue.default] 2: /usr/lib/python3.10/site-packages/paperwork_gtk/main.py: L 194: main_main
[ERROR ] [openpaperwork_core.work_queue.default] 3: /usr/lib/python3.10/site-packages/openpaperwork_core/__init__.py: L 454: call_one
[ERROR ] [openpaperwork_core.work_queue.default] 4: /usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py: L 65: mainloop
[ERROR ] [openpaperwork_core.work_queue.default] 5: /usr/lib/python3.10/site-packages/gi/overrides/GLib.py: L 497: run
[ERROR ] [openpaperwork_core.work_queue.default] 6: /usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py: L 159: decorator
[ERROR ] [openpaperwork_core.work_queue.default] 7: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 110: _do
[ERROR ] [openpaperwork_core.work_queue.default] 8: /usr/lib/python3.10/site-packages/openpaperwork_core/promise.py: L 172: do
[ERROR ] [openpaperwork_core.work_queue.default] 9: /usr/lib/python3.10/site-packages/paperwork_backend/cairo/pillow.py: L 288: _set_img_size
[ERROR ] [openpaperwork_core.work_queue.default] 10: /usr/lib/python3.10/site-packages/paperwork_backend/cairo/pillow.py: L 242: render
[ERROR ] [openpaperwork_core.work_queue.default] 11: /usr/lib/python3.10/site-packages/openpaperwork_core/__init__.py: L 503: call_success
[ERROR ] [openpaperwork_core.work_queue.default] 12: /usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py: L 139: work_queue_add_promise
[ERROR ] [openpaperwork_core.work_queue.default] 13: /usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py: L 59: add_promise
[ERROR ] [openpaperwork_core.work_queue.default] 14: /usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py: L 19: __init__
[ERROR ] [openpaperwork_gtk.mainloop.glib] Main loop: uncaught exception (>) !
Traceback (most recent call last):
File "/usr/lib/python3.10/site-packages/openpaperwork_gtk/mainloop/glib.py", line 159, in decorator
func(*args, **kwargs)
File "/usr/lib/python3.10/site-packages/openpaperwork_core/work_queue/default.py", line 30, in _on_error
raise exc
File "/usr/lib/python3.10/site-packages/openpaperwork_core/promise.py", line 233, in _threaded_do
our_r = self.func(*args, **self.kwargs)
File "/usr/lib/python3.10/site-packages/openpaperwork_core/pillow/img.py", line 79, in url_to_pillow
with self.core.call_success("fs_open", file_url, mode='rb') as fd:
AttributeError: __enter__
More Logs logs.zip
Edited by Jerome Flesch