Library Error |*Can't Delete "books_fts_stemmed"

lvsass · 01-22-2023, 05:17 PM

Hi!

For a while now I cannot delete books from my library. When I try, Calibre is giving me the error "CorruptError: vtable constructor failed: books_fts_stemmed", full error message below.

I tried rebuilding the database but the error is persisting.

Can't find anything about this error message on the forums. Does anybody know a fix or what's going on?

Thx!

Quote:

calibre, version 6.11.0
ERROR: Unhandled exception: <b>CorruptError</b>:CorruptError: vtable constructor failed: books_fts_stemmed

calibre 6.11 embedded-python: True
macOS-13.0.1-x86_64-i386-64bit Darwin ('64bit', '')
('Darwin', '22.1.0', 'Darwin Kernel Version 22.1.0: Sun Oct 9 20:14:54 PDT 2022; root:xnu-8792.41.9~2/RELEASE_X86_64')
Python 3.10.1
OSX: ('13.0.1', ('', '', ''), 'x86_64')
Interface language: None
Successfully initialized third party plugins: Annotations (1, 17, 13) && BookFusion Plugin (0, 7, 0) && Comicvine (0, 14, 1) && Comments Cleaner (1, 8, 0) && DNB_DE (3, 2, 1) && Douban Books (3, 2, 0) && Embed Comic Metadata (1, 6, 4) && Extract ISBN (1, 6, 0) && Goodreads (1, 7, 2) && Goodreads_Rating (4, 0, 0) && Job Spy (1, 0, 198) && Library Codes (1, 0, 54) && Zotero Metadata Importer (1, 0, 78)
Traceback (most recent call last):
File "calibre/gui2/actions/delete.py", line 439, in delete_books
File "calibre/gui2/actions/delete.py", line 410, in do_library_delete
File "calibre/gui2/library/models.py", line 459, in delete_books_by_id
File "calibre/db/cache.py", line 77, in call_func_with_lock
File "calibre/db/cache.py", line 2034, in remove_books
File "calibre/db/backend.py", line 1845, in remove_books
File "calibre/db/backend.py", line 1033, in executemany
apsw.CorruptError: CorruptError: vtable constructor failed: books_fts_stemmed

ownedbycats · 01-22-2023, 05:54 PM

That's a problem with the SQLite database. related to the full-text search, I think.

You've tried rebuilding the database, but have you also try running Library > Library Maintenance > Check library?

kovidgoyal · 01-22-2023, 09:23 PM

that's definitely a corrupt database. Delete the full-text-search.db file in your calibre library folder and you should be fine. You will need to re-enable full text search after doing so.

lvsass · 01-23-2023, 06:16 AM

Quote:

Originally Posted by kovidgoyal

that's definitely a corrupt database. Delete the full-text-search.db file in your calibre library folder and you should be fine. You will need to re-enable full text search after doing so.

Great, that did fix it, thank you.

01-22-2023, 05:54 PM	#2
ownedbycats Custom User Title Posts: 10,847 Karma: 74203799 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	That's a problem with the SQLite database. related to the full-text search, I think. You've tried rebuilding the database, but have you also try running Library > Library Maintenance > Check library? Last edited by ownedbycats; 01-22-2023 at 05:58 PM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search and Replace; delete "author" name from "serie"	roosten	Library Management	6	12-17-2015 11:38 AM
OK to delete "Calibre Library deleted" folder?	LaGringa	Library Management	3	10-26-2013 02:19 PM
Can I delete books after Calibre is done "adding" them to the library?	Kuram	Library Management	3	08-18-2013 12:15 PM
Touch Help! Can't delete "expired" library books!	tiniree	Barnes & Noble NOOK	1	01-05-2013 10:23 AM
"Protect Page" error with Public Library EPUB books	DojoPat	Sony Reader	28	07-13-2010 12:09 AM

01-22-2023, 09:23 PM	#3
kovidgoyal creator of calibre Posts: 45,269 Karma: 27111060 Join Date: Oct 2006 Location: Mumbai, India Device: Various	that's definitely a corrupt database. Delete the full-text-search.db file in your calibre library folder and you should be fine. You will need to re-enable full text search after doing so.

Advert