Any way to recover from "apsw.BusyError: BusyError: database is locked"?

QU2C371FcY · 05-06-2024, 07:37 AM

I googled this issue, and looks like I made a mistake by starting my library on a NAS. I spent half my weekend setting things up and fixing the tags in my books, and now after a reboot I can't open my library.

The error I get is below and I would appreciate any help you can provide. I would hate to have to start over, especially because I was aggressively deleting things after adding them to Calibre.

Code:

calibre, version 7.10.0
ERROR: Failed to repair library: Restoring database failed, click "Show details" to see details

Traceback (most recent call last):
  File "calibre/db/restore.py", line 156, in run
  File "calibre/db/restore.py", line 284, in create_cc_metadata
  File "calibre/db/restore.py", line 56, in __init__
  File "calibre/db/backend.py", line 485, in __init__
  File "calibre/db/backend.py", line 1443, in initialize_database
  File "src/cursor.c", line 240, in resetcursor
apsw.BusyError: BusyError: database is locked

chaley · 05-06-2024, 08:50 AM

Reboot both the NAS and your computer. If you are using Windows, reboot the computer in safe mode with networking. Then without starting calibre, copy the library from the NAS to a local disk. Reboot in normal mode if needed, then use calibre to open the local library. Immediately run calibre's "check library" to see what damage you are facing.

If calibre can't open the local library then try to rebuild it, as you apparently already tried to do with the NAS copy.

QU2C371FcY · 05-06-2024, 02:16 PM

I was able to copy the library locally, and it seems to be intact. Thank you for you help.

I am going to set up calibre on my NAS right away.

05-06-2024, 07:37 AM	#1
QU2C371FcY Enthusiast Posts: 33 Karma: 10 Join Date: Apr 2009 Device: none	Any way to recover from "apsw.BusyError: BusyError: database is locked"? I googled this issue, and looks like I made a mistake by starting my library on a NAS. I spent half my weekend setting things up and fixing the tags in my books, and now after a reboot I can't open my library. The error I get is below and I would appreciate any help you can provide. I would hate to have to start over, especially because I was aggressively deleting things after adding them to Calibre. Code: calibre, version 7.10.0 ERROR: Failed to repair library: Restoring database failed, click "Show details" to see details Traceback (most recent call last): File "calibre/db/restore.py", line 156, in run File "calibre/db/restore.py", line 284, in create_cc_metadata File "calibre/db/restore.py", line 56, in __init__ File "calibre/db/backend.py", line 485, in __init__ File "calibre/db/backend.py", line 1443, in initialize_database File "src/cursor.c", line 240, in resetcursor apsw.BusyError: BusyError: database is locked

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Database is locked" - can't use network folders	robertseetzen	Library Management	15	11-30-2022 02:17 PM
Recover "Modified" column values after adding new coluns in library	John Maverick	Library Management	11	07-27-2022 05:34 PM
Calibre 4.1 BusyError: database is locked	Tanjamuse	Calibre	3	10-10-2019 12:53 PM
How to fix "Extra Titles" in Database in " Check Library - Problems Found	millan	Library Management	33	07-16-2015 07:12 AM
SONY pocket edition: "Device locked" + "charge battery" obstacles?	hermes	Devices	3	06-02-2011 03:32 AM

05-06-2024, 08:50 AM	#2
chaley Grand Sorcerer Posts: 11,765 Karma: 7029857 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	Reboot both the NAS and your computer. If you are using Windows, reboot the computer in safe mode with networking. Then without starting calibre, copy the library from the NAS to a local disk. Reboot in normal mode if needed, then use calibre to open the local library. Immediately run calibre's "check library" to see what damage you are facing. If calibre can't open the local library then try to rebuild it, as you apparently already tried to do with the NAS copy.

05-06-2024, 02:16 PM	#3
QU2C371FcY Enthusiast Posts: 33 Karma: 10 Join Date: Apr 2009 Device: none	I was able to copy the library locally, and it seems to be intact. Thank you for you help. I am going to set up calibre on my NAS right away.