Intermittent Database Exception

[jt421]

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>Database Exception?</b>:unable to open database file Remote Traceback? (most recent call last): File "site-packages\calibre\library\sqlite.py", line 142, in run Operational Error?: 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 Database Exception?: unable to open database file Remote Traceback? (most recent call last): File "site-packages\calibre\library\sqlite.py", line 142, in run Operational Error?: unable to open database file

[kovidgoyal]

Fixed in branch trunk. The fix will be in the next release.