MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Calibre keeps restoring database?

Notices

Reply
 
Thread Tools Search this Thread
Old 10-26-2022, 12:58 PM   #1
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Calibre keeps restoring database?
This morning I opened Calibre and it decided the database is corrupt. So I let it restore the database. The problem is once it finishes and says the restoration was successful, it immediately pops a message up saying the database is no good and wants to restore it. I have done this over and over and over.

How can I just have Calibre rescan the Calibre library folder and rebuild the library?
ZodWallop is offline   Reply With Quote
Old 10-26-2022, 05:44 PM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,724
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by ZodWallop View Post
This morning I opened Calibre and it decided the database is corrupt. So I let it restore the database. The problem is once it finishes and says the restoration was successful, it immediately pops a message up saying the database is no good and wants to restore it. I have done this over and over and over.

How can I just have Calibre rescan the Calibre library folder and rebuild the library?
That's what a database restore does, it rebuilds the database from the metadata.opf files in the book folders.

Where is the library, on a local disk or a network drive of some sort - i.e. a server, a NAS, a Cloud provider?

Did the message at the end have any warnings? Example:

Code:
calibre, version 6.7.1
WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details. The old database was saved as: D:\Calibre\Libraries\CopyTest\metadata_pre_restore.db

The following custom columns have conflicting definitions and were not fully restored:
	#float
	used:	Float, float, False, {'number_format': '{0:,.5f}', 'description': '', 'decimals': 5}
	other:	Float, float, False, {'description': '', 'number_format': None}
	other:	Float, float, False, {'number_format': '{0:,.5f}', 'description': ''}
BR
BetterRed is online now   Reply With Quote
Advert
Old 10-26-2022, 06:11 PM   #3
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Quote:
Originally Posted by BetterRed View Post
That's what a database restore does, it rebuilds the database from the metadata.opf files in the book folders.
Yes. That is not the issue.

Quote:
Where is the library, on a local disk or a network drive of some sort - i.e. a server, a NAS, a Cloud provider?
The library is on an external hard drive. A Western Digital My Passport.

Quote:
Did the message at the end have any warnings? Example:

Code:
calibre, version 6.7.1
WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details. The old database was saved as: D:\Calibre\Libraries\CopyTest\metadata_pre_restore.db

The following custom columns have conflicting definitions and were not fully restored:
	#float
	used:	Float, float, False, {'number_format': '{0:,.5f}', 'description': '', 'decimals': 5}
	other:	Float, float, False, {'description': '', 'number_format': None}
	other:	Float, float, False, {'number_format': '{0:,.5f}', 'description': ''}
BR
Yes, it gave me exactly that "WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details." message.

When I click "Okay" it then immediately pops up the "Database is corrupted" message again and reruns database restore, where I again get "WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details" click "Okay" and then immediately "Database is corrupted" pops up again. I've run it something like seven times today already.

I'm wondering if there is a way to delete all the database files and make Calibre think the Calibre folder is a new library.
ZodWallop is offline   Reply With Quote
Old 10-26-2022, 06:14 PM   #4
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 79,750
Karma: 145864619
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Have you validated the database outside of Calibre to see if it really is corrupt?
JSWolf is offline   Reply With Quote
Old 10-26-2022, 08:09 PM   #5
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Quote:
Originally Posted by JSWolf View Post
Have you validated the database outside of Calibre to see if it really is corrupt?
No. How would I do that? I don't usually mess around with such things.
ZodWallop is offline   Reply With Quote
Advert
Old 10-26-2022, 08:36 PM   #6
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,724
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by ZodWallop View Post
Yes, it gave me exactly that "WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details." message.
When it does that, press Show Details, then press Copy to Clipboard, and paste the clipboard here.

Ordinarily there are no warnings - the ones I posted were created deliberately.

Quote:
Originally Posted by ZodWallop View Post
I'm wondering if there is a way to delete all the database files and make Calibre think the Calibre folder is a new library.
That's what restore does - if you look in the library folder you will see a file named metadata_pre_restore.db

BR
Last edited by BetterRed; 10-26-2022 at 08:41 PM.
BetterRed is online now   Reply With Quote
Old 10-26-2022, 11:49 PM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,345
Karma: 27182818
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
I dont see how the database could be corrupt immediately after a restore again, it's likely something else is going on try running calibre like this


calibre-debug -g


from a command prompt that should give us more information about the error.

And f you just want create a new library and re-import the books, you can simply rename the calibre library folder, then on next start calibre will create a new empty one, then right click the add books button and choose add from folders and sub-folders->one book per folder and pick the old calibre library folder. You library will be recreated with all basic metadata but no custom columns. If you want custom column metadata as well, first re-create the custom columns in the new library before using add books.
kovidgoyal is offline   Reply With Quote
Old 10-27-2022, 07:41 AM   #8
JSWolf
Resident Curmudgeon
JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.JSWolf ought to be getting tired of karma fortunes by now.
 
JSWolf's Avatar
 
Posts: 79,750
Karma: 145864619
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
Quote:
Originally Posted by ZodWallop View Post
No. How would I do that? I don't usually mess around with such things.
Use SQLite to check. https://www.sqlite.org/index.html

Here is the documentation on the command needed to do this. https://www.sqlite.org/pragma.html#p...ntegrity_check
JSWolf is offline   Reply With Quote
Old 10-27-2022, 10:19 AM   #9
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Quote:
Originally Posted by kovidgoyal View Post
And f you just want create a new library and re-import the books, you can simply rename the calibre library folder, then on next start calibre will create a new empty one, then right click the add books button and choose add from folders and sub-folders->one book per folder and pick the old calibre library folder. You library will be recreated with all basic metadata but no custom columns. If you want custom column metadata as well, first re-create the custom columns in the new library before using add books.
Thanks man. I will give that a go.

BTW: Thank you SO much for your hard work on Calibre. Without it, my e-reading life would be very different.
ZodWallop is offline   Reply With Quote
Old 10-27-2022, 12:14 PM   #10
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Okay, ran the database rebuild one more time. There's what I got as a message:

Code:
calibre, version 6.7.0
WARNING: Success: Restoring the database succeeded with some warnings click "Show details" to see the details. The old database was saved as: D:\Books\Calibre Portable\Calibre Library\metadata_pre_restore.db

Failed to restore the books in the following folders:
	D:\Books\Calibre Portable\Calibre Library\Dave Eggers\The Circle (11884) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 170, in scan_library
		  File "calibre\db\restore.py", line 192, in process_dir
		  File "calibre\ebooks\metadata\opf2.py", line 595, in __init__
		  File "calibre\ebooks\metadata\utils.py", line 42, in parse_opf
		  File "calibre\utils\xml_parse.py", line 26, in safe_xml_fromstring
		  File "src/lxml/etree.pyx", line 3254, in lxml.etree.fromstring
		  File "src/lxml/parser.pxi", line 1913, in lxml.etree._parseMemoryDocument
		  File "src/lxml/parser.pxi", line 1793, in lxml.etree._parseDoc
		  File "src/lxml/parser.pxi", line 1082, in lxml.etree._BaseParser._parseUnicodeDoc
		  File "src/lxml/parser.pxi", line 615, in lxml.etree._ParserContext._handleParseResultDoc
		  File "src/lxml/parser.pxi", line 725, in lxml.etree._handleParseResult
		  File "src/lxml/parser.pxi", line 654, in lxml.etree._raiseParseError
		  File "<string>", line 1
		lxml.etree.XMLSyntaxError: Document is empty, line 1, column 1

	D:\Books\Calibre Portable\Calibre Library\Larry Niven\Flatlander_ The Collected Tales of (8579) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 170, in scan_library
		  File "calibre\db\restore.py", line 192, in process_dir
		  File "calibre\ebooks\metadata\opf2.py", line 595, in __init__
		  File "calibre\ebooks\metadata\utils.py", line 39, in parse_opf
		ValueError: Empty file: D:\Books\Calibre Portable\Calibre Library\Larry Niven\Flatlander_ The Collected Tales of (8579)\metadata.opf

	D:\Books\Calibre Portable\Calibre Library\Mike Carey\The Naming of the Beasts (9982) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 170, in scan_library
		  File "calibre\db\restore.py", line 192, in process_dir
		  File "calibre\ebooks\metadata\opf2.py", line 595, in __init__
		  File "calibre\ebooks\metadata\utils.py", line 42, in parse_opf
		  File "calibre\utils\xml_parse.py", line 26, in safe_xml_fromstring
		  File "src/lxml/etree.pyx", line 3254, in lxml.etree.fromstring
		  File "src/lxml/parser.pxi", line 1913, in lxml.etree._parseMemoryDocument
		  File "src/lxml/parser.pxi", line 1793, in lxml.etree._parseDoc
		  File "src/lxml/parser.pxi", line 1082, in lxml.etree._BaseParser._parseUnicodeDoc
		  File "src/lxml/parser.pxi", line 615, in lxml.etree._ParserContext._handleParseResultDoc
		  File "src/lxml/parser.pxi", line 725, in lxml.etree._handleParseResult
		  File "src/lxml/parser.pxi", line 654, in lxml.etree._raiseParseError
		  File "<string>", line 1
		lxml.etree.XMLSyntaxError: Document is empty, line 1, column 1

	D:\Books\Calibre Portable\Calibre Library\Mike Carey\Vicious Circle (11502) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 170, in scan_library
		  File "calibre\db\restore.py", line 192, in process_dir
		  File "calibre\ebooks\metadata\opf2.py", line 595, in __init__
		  File "calibre\ebooks\metadata\utils.py", line 42, in parse_opf
		  File "calibre\utils\xml_parse.py", line 26, in safe_xml_fromstring
		  File "src/lxml/etree.pyx", line 3254, in lxml.etree.fromstring
		  File "src/lxml/parser.pxi", line 1913, in lxml.etree._parseMemoryDocument
		  File "src/lxml/parser.pxi", line 1793, in lxml.etree._parseDoc
		  File "src/lxml/parser.pxi", line 1082, in lxml.etree._BaseParser._parseUnicodeDoc
		  File "src/lxml/parser.pxi", line 615, in lxml.etree._ParserContext._handleParseResultDoc
		  File "src/lxml/parser.pxi", line 725, in lxml.etree._handleParseResult
		  File "src/lxml/parser.pxi", line 654, in lxml.etree._raiseParseError
		  File "<string>", line 1
		lxml.etree.XMLSyntaxError: Document is empty, line 1, column 1

	D:\Books\Calibre Portable\Calibre Library\Syd Moore\The Drowning Pool (11774) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 170, in scan_library
		  File "calibre\db\restore.py", line 199, in process_dir
		TypeError: int() argument must be a string, a bytes-like object or a real number, not 'NoneType'

	D:\Books\Calibre Portable\Calibre Library\Frank Herbert\The Heaven Makers (2) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Tom Wolfe\The Right Stuff (18) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robert E. Howard\Bran Mak Morn_ The Last King (465) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Richard Stark\Black Ice Score (466) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robert E. Howard\Sword Woman and Other Historical Ad (479) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Suzanne Weyn\Into The Dream (540) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ray Bradbury\Driving Blind (548) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Unknown\Suggested Reading Order (680) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Martin H Greenberg, Ed\Foundation's Friends (792) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Randall Garrett\Takeoff by Randall Garrett (822) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Joseph Conrad\Almayer's Folly_ A Story of an Eastern R (854) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Joseph Conrad\The Nigger Of The _Narcissus_ _ A Tale O (871) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\John W. Campbell Jr_\The Best of John W. Campbell (876) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Arms of Nemesis (876) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Catilina's Riddle (877) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Empire (878) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Gladiator Dies Only Once (879) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Gordianus - Something Fishy in Pompeii (880) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\House Of The Vestals (881) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Judgement of Caesar (882) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Last Seen in Massilia (883) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Mist of Prophecies (884) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Murder on the Appian Way (885) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Roma (886) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Roman Blood (887) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Rubicon (888) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Triumph Of Caesar (889) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Steven Saylor\Venus Throw (890) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Victor Gischler\Gun Monkeys (905) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Victor Gischler\Shotgun Opera (906) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Victor Gischler\Suicide Squeeze (907) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Victor Gischler\The Pistol Poets (908) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Victor Gischler\Vampire a Go-Go_ A Novel (909) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Vonnegut, Kurt\Slaughterhouse Five (966) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Stephenie Meyer\Twilight (992) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Stephenie Meyer\New Moon (993) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Stephenie Meyer\Eclipse (994) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Tony Burgess\Pontypool Changes Everything (1032) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Neil Gaiman;Terry Pratchett\Good Omens (1072) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Rick Hautala\Untcigahunk_ The Complete Little Brother (1109) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robert E. Howard\Conan the Barbarian_ The Chronicles of C (1204) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Peter Benchley\Peter Benchley's Creature (1219) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Paul Ernst\Dr Satan (1233) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Walter Greatshell\Xombies_ Apocalypso (1318) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Walter Greatshell\Xombies_ Apocalypse Blues (1319) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robbins, Tom\Even Cowgirls Get the Blues (1323) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Matthew Costello\Doom 3_ Maelstrom (1337) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Richard Dawkins\The Greatest Show on Earth (1383) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ray Bradbury\Fahrenheit 451 (1404) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Unknown\The Foundation Trilogy (1471) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Princess Delilah\Microsoft Word - Foundation and Chaos -  (1475) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Princess Delilah\Microsoft Word - Foundation's Fear - Gre (1481) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Princess Delilah\Microsoft Word - Foundation's Friends -  (1482) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\The Early Asimov\The Early Asimov (1550) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\R. H. Barlow\Weird Tales-October 1936 (1568) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Wilkie Collins\The Moonstone (1603) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\William Blatty\The Exorcist (1605) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Stephen Jones\The Mammoth Book of Best New Horror Vol  (1618) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robert B Parker\Gunman's Rhapsody (1727) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ronald Kelly\Hell Hollow (1730) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Robert B Parker\Resolution (1731) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ronald Kelly\Undertakers Moon (1776) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Thomas Kratman\Caliphate (1786) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ralph Compton\Ralph Compton Rio Largo (2015) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ralph Compton\A Wolf in the Fold (2016) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ralph Compton\Bluff City_ A Ralph Compton Novel (2017) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Ralph Compton\Ralph Compton the Palo Duro Trail (2105) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Otto Penzler\The Black Lizard Big Book of Pulps Paper (2476) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\David Sherman\Flashfire (2516) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\John Bellairs\The Letter, the Witch, and the Ring (3218) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robin Wayne Bailey\Shadowdance (6499) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Andre Norton\Snow Shadow (6519) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\The Alternative Detective (6577) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Pilgrimage to Earth_ Stories (6579) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Citizen in Space_ Stories (6580) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\The People Trap_ Stories (6581) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\The Robot Who Looked Like Me_ Stori (6582) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Shards of Space_ Stories (6583) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Is That What People Do__ Stories (6584) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Notions_ Unlimited_ Stories (6585) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Divine Intervention_ Stories (6587) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Draconian New York (6589) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Soma Blues (6591) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\White Death (6593) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Uncanny Tales_ Stories (6596) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Store of Infinity_ Stories (6597) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Robert Sheckley\Untouched by Human Hands_ Stories (6598) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2537, in restore_book
		  File "calibre\db\backend.py", line 2196, in restore_book
		  File "calibre\db\backend.py", line 1033, in executemany
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: data.book, data.format

	D:\Books\Calibre Portable\Calibre Library\Arthur C. Clarke\The Light of Other Days_ A Novel of (7983) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Voinov, Aleksandr\Skybound (8141) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Stephen Michell\Only the Devil Is Here (8293) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Peter Hedges\What's Eating Gilbert Grape (8294) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Pearl S. Buck\East Wind_ West Wind_ The Saga of a (8295) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Michael Phillip Cash\The After House (A Haunting on Long (8340) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\James Purdy\Cabot Wright Begins_ A Novel (8733) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id

	D:\Books\Calibre Portable\Calibre Library\Troy Denning\The Oath of Stonekeep (12012) with error:
		Traceback (most recent call last):
		  File "calibre\db\restore.py", line 259, in restore_books
		  File "calibre\db\cache.py", line 77, in call_func_with_lock
		  File "calibre\db\cache.py", line 2532, in restore_book
		  File "calibre\db\cache.py", line 1968, in create_book_entry
		  File "calibre\db\backend.py", line 1021, in execute
		apsw.ConstraintError: ConstraintError: UNIQUE constraint failed: books.id
Last edited by ZodWallop; 10-27-2022 at 12:16 PM.
ZodWallop is offline   Reply With Quote
Old 10-27-2022, 01:23 PM   #11
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: 46,190
Karma: 168983734
Join Date: Jul 2010
Location: Vancouver
Device: Kobo Sage, Libra Colour, Lenovo M8 FHD, Paperwhite 4, Tolino epos
Ughh... Looking at the output, your library is hooped.

The only time I saw a mess like that was when the library was stored in Dropbox. I'm wondering if your external hard drive is having issues considering the missing book files, duplicate book IDs, etc..

I'd suggest your best procedure is to close calibre, rename the library directory, open calibre, add a new library and import your old library to the new library using Add books => from folders and sub-folders. Not sure if the default assume books in the same folder are multiple formats of the same book should be on or off.

Perhaps running a search for your ebook file formats on the old library to see if the number of books that are imported to the new library comes close to matching the number in the old library.
DNSB is offline   Reply With Quote
Old 10-27-2022, 05:44 PM   #12
ZodWallop
Gentleman and scholar
ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.ZodWallop ought to be getting tired of karma fortunes by now.
 
ZodWallop's Avatar
 
Posts: 11,479
Karma: 111164374
Join Date: Jun 2015
Location: Space City, Texas
Device: Clara BW; Nook ST w/Glowlight, Paperwhite 3
Quote:
Originally Posted by DNSB View Post
I'd suggest your best procedure is to close calibre, rename the library directory, open calibre, add a new library and import your old library to the new library using Add books => from folders and sub-folders. Not sure if the default assume books in the same folder are multiple formats of the same book should be on or off.
I'm doing that now. I don't remember precisely what the book count was. Also, for now I told Calibre to go ahead and import books it sees as duplicates. Then I'll go through and see what sort of mess I have.

What's an easy way to prompt Calibre to show me books it suspects are duplicates, once they've been added to the library?
ZodWallop is offline   Reply With Quote
Old 10-27-2022, 06:46 PM   #13
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Find Duplicates Plugin
theducks is offline   Reply With Quote
Old 10-27-2022, 07:53 PM   #14
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,724
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
I guess because I've never had to do a restore database in anger, I didn't release it preserved the book numbers (id) - I wrongly assumed they'd be re-generated.

But why was a auto-restore triggered ln the first instance, and why was another one triggered immediately after that auto-restore… ad-infinitum.

I suggest the OP does regular library checks, either manually via the GUI, or via a scheduled task that runs the calibredb check_library command.

I check my libraries once a week, I get an occasional error - but I always know why, and it is always something I did - usually editing a 'format file' in place with an external editor that left its dirty dishes in the sink when it crashed. Or I unpacked a CBZ to rotate some images and forgot to remove the unpacked folder after rezipping a replacement CBZ.

BR
Last edited by BetterRed; 10-27-2022 at 08:06 PM.
BetterRed is online now   Reply With Quote
Old 10-27-2022, 08:19 PM   #15
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,054
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
{id} is in metadata.opf
theducks is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Restoring database failed jstavene Library Management 3 02-27-2022 11:03 AM
Help needed restoring database rgc Calibre 2 06-26-2021 02:52 PM
Restoring Database Yusufbodrum Library Management 3 07-31-2015 07:49 PM
Help Restoring Calibre Database? Sydney's Mom Related Tools 3 04-29-2012 04:53 PM
Restoring database failed Lady Domino Calibre 2 03-23-2012 01:12 PM


All times are GMT -4. The time now is 11:41 PM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.