Thread: Corrupt database and no metadata_pre_restore.db'
View Single Post
Old 02-24-2019, 03:12 PM   #2
DNSB
Bibliophagist
DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.DNSB ought to be getting tired of karma fortunes by now.
 
DNSB's Avatar
 
Posts: 47,092
Karma: 169815798
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Quote:
Originally Posted by helibird View Post
Help, I've screwed things up!
I opened Calibre, All books appeared OK with their metadata but when I tried to update one I got the following
c
Spoiler:
alibre, version 3.30.0
ERROR: Failed to set data: Could not set data, click Show Details to see why.

Traceback (most recent call last):
File "site-packages\calibre\gui2\library\models.py", line 1091, in setData
File "site-packages\calibre\gui2\library\models.py", line 1117, in _set_data
File "site-packages\calibre\gui2\library\models.py", line 1080, in set_custom_column_data
File "site-packages\calibre\db\legacy.py", line 659, in set_custom
File "site-packages\calibre\db\cache.py", line 1092, in set_field
File "site-packages\calibre\db\write.py", line 544, in set_books
File "site-packages\calibre\db\write.py", line 228, in one_one_in_other
File "site-packages\calibre\db\backend.py", line 855, in executemany
File "c:\t\t\apsw-bdov6u\apsw-3.23.1-r1\src\cursor.c", line 236, in resetcursor
CantOpenError: CantOpenError: unable to open database file

I tried several times to restore the database and finally spotted I had another Calibre Library with one author.
I told it to forget this library but the database is still coming up corrupt.
The restore is coming up with
Spoiler:
ERROR: Failed: Restoring database failed, click Show details to see details
Traceback (most recent call last):
File "site-packages\calibre\db\restore.py", line 127, in run
File "site-packages\calibre\db\restore.py", line 279, in replace_db
File "shutil.py", line 83, in copyfile
IOError: [Errno 2] No such file or directory: u'C:\\Users\\helen\\Documents\\MyBooks\\Calibre Library\\metadata_pre_restore.db'

and it is right there is no such file in either of the Calibre libraries
The restore creates a tiny db file and when I click to open Calibre it flashed up something and then closes. If I put the old db back I get back to the original postion - can see all my books but can't save anything!

I assume I will have to create a new blank library somewhere else and re import all my books (only about 3500 so not too bad).
Will I lose my user meta data (telling be which ones I've read and their rating).
Can someone poit me at where I can find instructions for the best way to get Calibre back up with minimal loss.
Before getting too involved with destroying and recreating your library, I would suggest checking your AV program. Several people have had issues with libraries in the Documents folder under Windows where their AV has attempted to protect those files.

You can also restart your computer in safe mode and then open calibre. This will keep other programs that may cause issues with calibre from running.

One you get the issue worked out, I would suggest copying your existing libraries out of the Documents folder (I placed mine in the root of my User directory after running into an issue with folder protection).
DNSB is offline   Reply With Quote