Thanks for the prompt reply, Kovid.
Unfortunately, your suggestion did not help. I exited Calibre and deleted 'metadata.db' (I also had a 'metadata_pre_restore.db' and a 'metadata_db_prefs_backup.json', that I deleted as well).
Upon re-opening Calibre, I was asked whether I wanted to rebuild my corrupted database or open an empty one. The accompanying error message was:
calibre, version 0.8.66
Corrupted database: The library database at /Volumes/Everyday Companion 1.5 TB/---Calibre Library appears to be corrupted. Do you want calibre to try and rebuild it automatically? The rebuild may not be completely successful. If you say No, a new empty calibre library will be created.
Traceback (most recent call last):
File "site-packages/calibre/gui2/main.py", line 192, in initialize_db
File "site-packages/calibre/library/database2.py", line 198, in __init__
File "site-packages/calibre/library/database2.py", line 152, in connect
File "site-packages/calibre/library/database2.py", line 545, in initialize_database
File "site-packages/calibre/library/sqlite.py", line 314, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages/calibre/library/sqlite.py", line 271, in run
OperationalError: unable to open database file
I click 'Yes' and initiate a rebuild process that takes a few hours on my MacBook Air (the library has over 16000 books). The rebuild process seems to succeed with no apparent interruptions, yet when it's over I'm back to square one, with exactly the same symptoms that I described in my first post.
Do I have any options left to salvage my library and its metadata or is my only choice to create a fresh empty library and reimport all the 16k+ books from the current Calibre database folder?
Thanks in advance. W.