DatabaseError: malformed database schema (author_insert_trg) - no such table: authors

[peterdeegan]

I have Calibre 0.7.6 and am now getting the error in the subject line (full error later in this message). On Windows 7 linked to a Kindle 2.

I'm afraid I can't say if this happened after 0.7.6 was installed or was later - not paying attention.

Copying books to a device no longer works.

I tried 'Check database integrity' and got the same error.

I can't think of anything else to try and throw myself on your mercy!

Thanks

Peter Deegan


ERROR: ERROR: Unhandled exception: <b>DatabaseException</b>:malformed database schema (author_insert_trg) - no such table: authors
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 157, in run
File "site-packages\calibre\library\sqlite.py", line 89, in get
DatabaseError: malformed database schema (author_insert_trg) - no such table: authors

Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 263, in dispatch
File "site-packages\calibre\gui2\device.py", line 774, in metadata_downloaded
File "site-packages\calibre\gui2\device.py", line 1398, in set_books_in_library
File "site-packages\calibre\library\database2.py", line 461, in get_metadata
File "site-packages\calibre\library\database2.py", line 969, in authors_sort_strings
File "site-packages\calibre\library\sqlite.py", line 193, in run
DatabaseException: malformed database schema (author_insert_trg) - no such table: authors
RemoteTraceback (most recent call last):
File "site-packages\calibre\library\sqlite.py", line 157, in run
File "site-packages\calibre\library\sqlite.py", line 89, in get
DatabaseError: malformed database schema (author_insert_trg) - no such table: authors

[kovidgoyal]

You appear to have a corrupted database. If you have a backup try to restore your calibre library from that.

[peterdeegan]

D'oh - of course. Silly me.

Copied a recent backup of metadata.db back to the Calibre folder. then I used Add books from directories to rescan the library folders and add books to Calibre that I'd acquired since the last db backup.

Thanks for the quick reply.

[peterdeegan]

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/