View Single Post
Old 07-08-2010, 06:46 PM   #3
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,153
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Gary_M_Mugford View Post
Hello all,

First time poster, please by gentile

After a couple of mis-starts, I really started moving a fair number of book listings into Calibre (updated regularly). I have a couple thousand books entered. But, I was noticing a book by Alastair Reynolds was always sorting to the top on startup. Normally, I have the books listed in reverse date entered order and the book should have been mid-list. This went on for a couple of days. I also noticed a bit of sloth creeping into the start and normal working mode. So I ran the integrity check and got this:

---------------------------
ERROR: Error
---------------------------
Failed to check database integrity
---------------------------
OK Copy to Clipboard Hide Details...
---------------------------
Traceback (most recent call last):
File "site-packages\calibre\gui2\dialogs\config\__init__.py", line 912, in run
File "site-packages\calibre\library\database2.py", line 1941, in check_integrity
WindowsError: [Error 32] The process cannot access the file because it is being used by another process: u'N:\\GaryELib\\metadata.db'

I subsequently looked through the manual and encountered the information about calibre-debug --reinitialize-db. I quit calibre. I assumed the program was a standalone and created a shortcut to it. A DOS window opened and I got what I assumed was a command prompt ending in 1. I typed in reinitialize-db and (subsequently) every variation I could think of with single and double hyphens. None seemed to work.

At which point, I turned to this august forum to beg for help.

I am running WinXPSP3 (uptodate). I have a Sony Clie as a reader, but do not have it listed as the reader in calibre. I have a non-standard list of columns, having added a text column called FOR and a DateReviewed date column (I occasionally write book reviews in my blog). The program is installed to the default location. The data is stored on a centralized drive in the server on my home network and backed up nightly to a hard drive in my main machine. Although calibre is not currently running, I notice a that there is a metadata.db.tmp that is dated today, while metadata.db is from yesterday. The older file is a slight bit bigger at 3.0 MB compared to 2.9 MB for the newer tmp file. So, I went back into calibre and added a book. And then exited. I looked for the new folder (it was there). The metadata.db was now updated to the second of my last update to calibre. I can only surmise that the tmp file is part of the data integrity testing process.

That's about the limit I have to offer as information. Hope it's enough to guide me on my way back to full calibre happiness.

Thanks in advance, GM
What version Calibre? (there was a early 0.2.x version that did not play nice with custom columns. was fixed)
theducks is offline   Reply With Quote