Full Text Search error

[laurla]

Not sure if there is a specific sub-forum I should post this, so apologies if I'm in the wrong place.

I am getting error report when trying to use full text search in the library. It just started today - I successfully used the search a few days ago, but since then, I uploaded the KPX Output plug-in so that I could successfully convert KFX from Amazon download using Kindle4PC latest version rather than the work around I'd been using with an older Kindle4PC version. I was able to do the conversion but now my search feature says there is a database disk error. I've pasted the error report below. Appreciate any help!

calibre, version 7.16.0
ERROR: Unhandled exception: <b>CorruptError</b>:CorruptError: database disk image is malformed

calibre 7.16 embedded-python: True
Windows-10-10.0.22621-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.22621')
Python 3.11.5
Windows: ('10', '10.0.22621', 'SP0', 'Multiprocessor Free')
Interface language: None
EXE path: C:\Program Files\Calibre2\calibre.exe
Successfully initialized third party plugins: Gather KFX-ZIP (from KFX Input) (2, 15, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 15, 0) && Count Pages (1, 13, 6) && EpubCheck (0, 2, 5) && EpubMerge (3, 1, 0) && EpubSplit (3, 8, 0) && Generate Cover (2, 3, 4) && Goodreads (1, 8, 2) && KFX metadata reader (from KFX Input) (2, 15, 0) && From KFX (2, 15, 0) && KFX Input (2, 15, 0) && Set KFX metadata (from KFX Output) (2, 9, 0) && KFX Output (2, 9, 0) && KindleUnpack - The Plugin (0, 83, 1) && Manage Series (1, 5, 2) && Modify ePub (1, 8, 4) && MultiColumnSearch (1, 0, 96) && Quality Check (1, 13, 12)
Traceback (most recent call last):
File "calibre\gui2\fts\search.py", line 468, in search
File "calibre\gui2\fts\search.py", line 273, in search
File "calibre\db\cache.py", line 85, in call_func_with_lock
File "calibre\db\cache.py", line 659, in fts_search
File "calibre\gui2\fts\search.py", line 255, in construct
File "calibre\db\backend.py", line 1119, in fts_search
File "calibre\db\fts\connect.py", line 188, in search
File "calibre\db\backend.py", line 414, in execute
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.CorruptError: CorruptError: database disk image is malformed

[ownedbycats]

I've gotten that 2-3 times, the first time I asked Kovid but he wasn't sure what could cause it.

I think twice I ran a VACUUM on the full-text database (Check Library can do this) and it fixed it for some reason - another time I had to do a full reindex.

[laurla]

Originally Posted by ownedbycats

I've gotten that 2-3 times, the first time I asked Kovid but he wasn't sure what could cause it.

I think twice I ran a VACUUM on the full-text database (Check Library can do this) and it fixed it for some reason - another time I had to do a full reindex.

Thanks for the reply. I will try that....

[DNSB]

Also you need to install the KFX Input plugin not the KFX Output plugin to import KFX ebooks into calibre.

[laurla]

Originally Posted by DNSB

Also you need to install the KFX Input plugin not the KFX Output plugin to import KFX ebooks into calibre.

Yes, I have both installed. It's not the that the deDRM isn't working, it is. It's just that I noticed this issue with the full text search started after I had installed the plugin and started using that for Kindle ebooks vs the Transfer & Download workaround. Don't know that they are related but thought it was too much of a coincidence not to be.

However, after doing the Check Library (didn't work), re-indexing which then produced a different error but then deciding to run Check Library again just to try, it seems to be working again. So whether a coincidence or related, seems to be good for the moment.

Thanks again!!

[ownedbycats]

KFX Input/Output likely didn't have much to do with the error - when doing a bit of searching on it when it happened, I found there is (or was, not entirely clear) a few known glitches that can corrupt the FTS5 index.