View Single Post
Old 12-21-2009, 01:17 PM   #1
jt421
Junior Member
jt421 began at the beginning.
 
Posts: 5
Karma: 10
Join Date: Dec 2009
Device: Calibre
Intermittent Database Exception

First, let me thank you for an outstanding program. Calibre has made the task of maintaining and organizing my e-book library a pleasure.

Recently, I upgraded my computer from Vista to Windows 7 and brought my library with me. Since then, I have been having intermittent, but frequent issues trying to make metadata changes and add books.

Specifically, when making a change ~50% of the time I get an Unhandled exception and the change fails. If I am editing a book individually, Calibre stays on the edit screen and I can try again. This usually works after trying 2-3 times. If I am doing a bulk change, or importing multiple books, the change/import fails and only some portion of the books gets the change. (See below for an example of the error message)

I have looked through the forum and bug tracker, and I have eliminated some of the easy answers (spaces in path, clean reinstall, Advanced->Check database integrity, anti-virus/backup software, etc.).

Since the problem occurs most frequently when I am doing multiple changes quickly, either via bulk change or typing fast, it looks like a database access problem.

Even with the database integrity check could it be a corrupted database? Can I rebuild the database without loosing all of my information?

Any help would be MUCH appreciated!

------------
The error:

ERROR: ERROR: Unhandled exception: <b>DatabaseException</b>:unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 142, in run
OperationalError: unable to open database file

Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\metadata_bulk.py", line 106, in sync
File "site-packages\calibre\library\database2.py", line 1216, in set_publisher
File "site-packages\calibre\library\sqlite.py", line 171, in run
DatabaseException: unable to open database file
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 142, in run
OperationalError: unable to open database file
jt421 is offline   Reply With Quote