Problem when saving to disk (database locked)

[gargoyle]

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:

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]

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.