1.1.0 - Check Library Error

nynaevelan · 08-30-2013, 05:33 AM

I am receiving the following error when trying to check the library on a portable version within a dropbox folder:

calibre, version 1.1.0
ERROR: Failed: Database integrity check failed, click Show details for details.

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\check_library.py", line 54, in dump_and_restore
File "site-packages\calibre\db\cache.py", line 56, in ans
File "site-packages\calibre\db\cache.py", line 1710, in dump_and_restore
File "site-packages\calibre\db\backend.py", line 1001, in dump_and_restore
File "site-packages\calibre\db\backend.py", line 287, in execute
File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor
ConstraintError: ConstraintError: column key is not unique

Is there something on my system I need to check/change that could correct this?

kovidgoyal · 08-30-2013, 05:40 AM

It indicates a problem in your database.

First backup the metadata.db file from your calibre library folder. Then open a command prompt, change to the calibre library folder and run

calibre-debug --reinitialize-db metadata.db

That might be able to auto-fix your database.

The other alternative is to rebuild the database by clicking the calibre button on the toolbar and choosing Library maintenance->Restore database

nynaevelan · 08-31-2013, 02:33 AM

Thank you Kovid, restoring the database fixed it right up!

08-30-2013, 05:33 AM	#1
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	1.1.0 - Check Library Error I am receiving the following error when trying to check the library on a portable version within a dropbox folder: calibre, version 1.1.0 ERROR: Failed: Database integrity check failed, click Show details for details. Traceback (most recent call last): File "site-packages\calibre\gui2\dialogs\check_library.py", line 54, in dump_and_restore File "site-packages\calibre\db\cache.py", line 56, in ans File "site-packages\calibre\db\cache.py", line 1710, in dump_and_restore File "site-packages\calibre\db\backend.py", line 1001, in dump_and_restore File "site-packages\calibre\db\backend.py", line 287, in execute File "c:\cygwin\home\kovid\sw\build\apsw-3.7.17-r1\src\cursor.c", line 231, in resetcursor ConstraintError: ConstraintError: column key is not unique Is there something on my system I need to check/change that could correct this?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extra Titles Error Persists in Check Library	GeekyGal	Library Management	2	12-10-2011 10:13 AM
epub check error help	jenny clarkson	ePub	1	10-19-2011 09:26 AM
Check Library Error	nynaevelan	Calibre	2	06-05-2011 11:41 AM
Epub check error. Please help.	ronaldhart	ePub	1	12-21-2010 10:26 PM
Error on Check Database Integrity	Filigree	Calibre	1	01-09-2010 01:21 AM

08-30-2013, 05:40 AM	#2
kovidgoyal creator of calibre Posts: 45,598 Karma: 28548962 Join Date: Oct 2006 Location: Mumbai, India Device: Various	It indicates a problem in your database. First backup the metadata.db file from your calibre library folder. Then open a command prompt, change to the calibre library folder and run calibre-debug --reinitialize-db metadata.db That might be able to auto-fix your database. The other alternative is to rebuild the database by clicking the calibre button on the toolbar and choosing Library maintenance->Restore database

08-31-2013, 02:33 AM	#3
nynaevelan eBook Junkie Posts: 1,526 Karma: 1464018 Join Date: May 2010 Location: USA Device: Kindle Fire 2020, Kindle PW2	Thank you Kovid, restoring the database fixed it right up!