Calibre database access issues

[barrymcsorley]

I'm having database access issues for a number of tasks in Calibre - the output from a simple move book between libraries is given below. I'm getting these issues on both a full install of Calibre plus a portable install on a work laptop that I do not have full admin rights on so wondering if this is related?

calibre, version 2.76.0
ERROR: Failed to copy books: Could not copy any books, click "Show Details" for more information.

Failed to copy a book, see below for details

Copying: Bone failed, with error:
Traceback (most recent call last):
File "site-packages\calibre\gui2\actions\copy_to_library.py", line 156, in _doit
File "site-packages\calibre\gui2\actions\copy_to_library.py", line 194, in do_one
File "site-packages\calibre\db\legacy.py", line 246, in import_book
File "site-packages\calibre\db\cache.py", line 1569, in add_books
File "site-packages\calibre\db\cache.py", line 61, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 1539, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1261, in set_metadata
File "site-packages\calibre\db\cache.py", line 1088, in update_path
File "site-packages\calibre\db\backend.py", line 1551, in update_path
File "site-packages\calibre\db\tables.py", line 135, in set_path
File "site-packages\calibre\db\backend.py", line 822, in execute
File "c:\cygwin64\home\kovid\sw\build\apsw-3.8.2-r1\src\cursor.c", line 231, in resetcursor
CantOpenError: CantOpenError: unable to open database file

[theducks]

One of the Libraries (Destination) is locked or in use (Local drive)

Network drives are iffy and officially not supported (see FAQ)

[barrymcsorley]

Thanks for the reply. My Calibre database is on my NAS on local network and never had any problems before - any way to unlock the database?

[BetterRed]

Originally Posted by barrymcsorley

Thanks for the reply. My Calibre database is on my NAS on local network and never had any problems before ...

Nor did the other folks who ran into problems running calibre over a network, some chose to ignore and others didn't bother reading the first line of this FAQ ==>> I am getting errors with my calibre library on a networked drive/NAS?

Originally Posted by barrymcsorley

...any way to unlock the database?

It may not be locked as such, could be corrupt, as the FAQ says, NAS file systems are often incomplete, flaky etc.

You could try moving the library onto a local drive and rebuilding the database at that location via Library Maintenance->Restore Database. Whether you then transfer the library back to the NAS is up to you. But your planning assumption should be that it won't work, and even if it does it may not be for long.

BR

[PeterT]

Also try a reboot of the NAS in case it's locked the files by mistake.

[barrymcsorley]

Thanks for the responses. I have rebooted my NAS but database is still locked. I'd like to use Calibre across multiple computers so will read the FAQ's and forums and investigate ways of making this work....

[BetterRed]

@barrymcsorley - the next major version of calibre (3.0) will be multi-user. You can take sneak peek at it, see post #2 in ==>> Calibre 3.0 changes and bèta release date?

BR

[barrymcsorley]

Originally Posted by BetterRed

@barrymcsorley - the next major version of calibre (3.0) will be multi-user. You can take sneak peek at it, see post #2 in ==>> Calibre 3.0 changes and bèta release date?

BR

Ah this looks great so will delve in now! I'm trying to have single application DB's on my NAS with multiple clients accessing it for all my media apps (ditto with Kodi for movies and TV) so that read/viewed status, pause/resume etc. are all in single place. It's a struggle but determined to get there and great to see the apps moving in that direction also.....