View Single Post
Old 07-03-2010, 12:44 AM   #4
peterdeegan
Junior Member
peterdeegan began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jun 2010
Device: Kindle v2
DatabaseError: malformed database schema (author_insert_trg) - no such table: authors

Kovid,

So the question is ... what caused the db corruption? Especially since the restored db quickly became corrupted again.

I'm running Windows 7 attached to Windows Server - the My Documents folder gets synchronized to server storage using a Sync Center app in the Control Panel. The Calibre Library location is a network url eg //<machine>/<user>/My Documents/Calibre Library but it's stored on the local machine.

metadata.db is part of the sync but yields a sync error 'The process cannot access the file because it is being used by another process'. That happens sometimes with open documents etc and isn't usually a problem.

But for some reason this is a problem with Calibre and the db keeps getting corrupted. Maybe something to do with the file/db lock?

I'll fix this by moving the Calibre Library to a non-sync'd location which isn't optimal but will do.

But I thought you should know in case it happens to others.

Cheers,

Peter D/
peterdeegan is offline   Reply With Quote