"Database is locked" - can't use network folders

[robertseetzen]

Hello,

whenever I try to use a network directory as the Calibre Library Folder, the program reports a database error.

It doesn't matter if I try to choose the folder when starting Calibre the very first time after a fresh install or after "re-running" the startup wizard from the calibre menu. The network folder is empty, no books were imported.

The error messages follow at the end of this post.

The background / scenario is: I want to use Calibre on my desktop PC as well as on my Notebook and Netbook - only one at a time, no concurrent access. All machines are running Ubuntu. The eBooks shall reside on a server, which is (no jokes) a windows 7 install, so the network mounts use samba / cifs.

Any help would be very appreciated, since I really like Calibre.

Robert Seetzen

- The error messages:

Traceback (most recent call last):
File "site-packages/calibre/gui2/main.py", line 215, in initialize_db
File "site-packages/calibre/library/database2.py", line 216, in __init__
File "site-packages/calibre/library/database2.py", line 332, in initialize_dynamic
File "site-packages/calibre/library/sqlite.py", line 314, in run
DatabaseException: database is locked
RemoteTraceback (most recent call last):
File "site-packages/calibre/library/sqlite.py", line 271, in run
OperationalError: database is locked

[user_none]

Originally Posted by robertseetzen

Hello,
whenever I try to use a network directory as the Calibre Library Folder, the program reports a database error.

Putting the library on a network share is not supported. Some people have gotten this to work but it's not recommended. The SQLite db does not work well on a network share. I believed NFS doesn't work at all and SMB sometimes works.

[theducks]

Originally Posted by user_none

Putting the library on a network share is not supported. Some people have gotten this to work but it's not recommended. The SQLite db does not work well on a network share. I believed NFS doesn't work at all and SMB sometimes works.

And "sometimes" is the worst possible case, because "Sometimes" your Library goes bye-bye

Avoid placing your data at peril on "Sometimes it fails" systems. Even if you really-really want to do it that way

[ThR]

My calibre-database resides on a network share (NAS by Synology, accessing the database with three W7-PCs, no concurrent use, one after another) since I started with calibre. Sometimes I get "database is locked", but only if the laptop has lost its wlan-connection while calibre is running. Stopping and restarting calibre and the problem is gone.