Problem when saving to disk (database locked)

gargoyle · 12-05-2010, 12:00 PM

Hi,

I'm having a problem when trying to save books to disk from my Calibre library... it appears to get stuck... sometimes it writes a few books, but never all of the ones I selected.

Using calibre-debug I captured the following:

Code:

MattMac:MacOS matt$ calibre-debug -g
Starting up...
Started up in 9.05119800568
Job: 2 Save books (1 of 8) finished
Save books (1 of 8)
        Python function terminated unexpectedly: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked
        Traceback (most recent call last):
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 147, in main
            return run_entry_point()
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 116, in run_entry_point
            return getattr(pmod, func)()
          File "site-packages/calibre/utils/ipc/worker.py", line 107, in main
          File "site-packages/calibre/ebooks/metadata/worker.py", line 263, in save_book
          File "site-packages/calibre/library/database2.py", line 133, in __init__
          File "site-packages/calibre/library/database2.py", line 187, in initialize_dynamic
          File "site-packages/calibre/library/sqlite.py", line 231, in run
        calibre.library.sqlite.DatabaseException: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked

Job: 2 Save books (1 of 8) finished
Save books (1 of 8)
        Python function terminated unexpectedly: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked
        Traceback (most recent call last):
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 147, in main
            return run_entry_point()
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 116, in run_entry_point
            return getattr(pmod, func)()
          File "site-packages/calibre/utils/ipc/worker.py", line 107, in main
          File "site-packages/calibre/ebooks/metadata/worker.py", line 263, in save_book
          File "site-packages/calibre/library/database2.py", line 133, in __init__
          File "site-packages/calibre/library/database2.py", line 187, in initialize_dynamic
          File "site-packages/calibre/library/sqlite.py", line 231, in run
        calibre.library.sqlite.DatabaseException: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked

Job: 2 Save books (1 of 8) finished
Save books (1 of 8)
        Python function terminated unexpectedly: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked
        Traceback (most recent call last):
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 147, in main
            return run_entry_point()
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 116, in run_entry_point
            return getattr(pmod, func)()
          File "site-packages/calibre/utils/ipc/worker.py", line 107, in main
          File "site-packages/calibre/ebooks/metadata/worker.py", line 263, in save_book
          File "site-packages/calibre/library/database2.py", line 133, in __init__
          File "site-packages/calibre/library/database2.py", line 187, in initialize_dynamic
          File "site-packages/calibre/library/sqlite.py", line 231, in run
        calibre.library.sqlite.DatabaseException: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked

Job: 2 Save books (1 of 8) finished
Save books (1 of 8)
        Python function terminated unexpectedly: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked
        Traceback (most recent call last):
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 147, in main
            return run_entry_point()
          File "/Applications/calibre.app/Contents/Resources/Python/lib/python2.7/site.py", line 116, in run_entry_point
            return getattr(pmod, func)()
          File "site-packages/calibre/utils/ipc/worker.py", line 107, in main
          File "site-packages/calibre/ebooks/metadata/worker.py", line 263, in save_book
          File "site-packages/calibre/library/database2.py", line 133, in __init__
          File "site-packages/calibre/library/database2.py", line 187, in initialize_dynamic
          File "site-packages/calibre/library/sqlite.py", line 231, in run
        calibre.library.sqlite.DatabaseException: database is locked
                RemoteTraceback (most recent call last):
                  File "site-packages/calibre/library/sqlite.py", line 195, in run
                OperationalError: database is locked

The above error is then just repeated over and over until I hit abort.

I've done a check database integrity, and even done a calibredb restore, but neither have helped.

Any ideas?

I'm using Calibre 0.7.32 on OSX 10.6.4 with a library of just over 14,000 ebooks loaded in Calibre.

kovidgoyal · 12-05-2010, 08:00 PM

quit calibre, start it, leave it running for about two hours and then retry the save to disk.

calibre is backing up your database in the background (a new feature introduced recently) and since you have a large database, it will take some time.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ipaq 211: Saving to disk	grnlady2	Calibre	7	08-31-2010 07:57 AM
Problem "saving to disk" pdf files	lucone	Calibre	1	06-28-2010 05:29 AM
Question about saving to disk	Xenophon	Calibre	2	10-23-2009 11:10 AM
Saving to disk	htaylor	Calibre	2	01-04-2009 08:29 PM
Saving to Disk issues	scruffy	Calibre	5	09-03-2008 12:10 AM

12-05-2010, 08:00 PM	#2
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	quit calibre, start it, leave it running for about two hours and then retry the save to disk. calibre is backing up your database in the background (a new feature introduced recently) and since you have a large database, it will take some time.

Advert