[KSlauson]

This error has been cropping up based on other threads for several years now, through various versions of Calibre. It's a great program, but this bug really cripples it use.

I've been trying various suggestions, including exporting the library and reimporting it to a different local drive. My library passes all the check library tests. I can add and edit books, but I cannot delete some books. There's a serious bug in Calibre somewhere. I don't know if it's specific to Windows, but I could test this on Linux if needed.

Here's the error message:

Spoiler:

calibre, version 7.8.0
ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such savepoint: _apsw-0

calibre 7.8 embedded-python: True
Windows-10-10.0.19045-SP0 Windows ('64bit', 'WindowsPE')
('Windows', '10', '10.0.19045')
Python 3.11.5
Windows: ('10', '10.0.19045', '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, 10, 0) && DeDRM (10, 0, 9) && Package KFX (from KFX Input) (2, 10, 0) && Amazon.com Multiple Countries (1, 0, 0) && Baen (1, 1, 0) && Barnes & Noble (1, 5, 4) && Clipboard Search (1, 5, 1) && Comments Cleaner (1, 13, 0) && Count Pages (1, 13, 6) && DOC Input (1, 0, 1) && Ebook Translator (2, 3, 3) && Editor Chains (1, 1, 6) && EpubMerge (2, 18, 0) && EpubSplit (3, 7, 0) && Extract ISBN (1, 6, 2) && FanFicFare (4, 33, 0) && Fantastic Fiction (1, 7, 0) && Fantastic Fiction Adults (1, 3, 1) && Favourites Menu (1, 3, 1) && FictionDB (1, 4, 2) && Find Duplicates (1, 10, 9) && Generate Cover (2, 3, 4) && Goodreads (1, 8, 1) && ISFDB3 (1, 2, 2) && KFX metadata reader (from KFX Input) (2, 10, 0) && From KFX (2, 10, 0) && KFX Input (2, 10, 0) && Kindle hi-res covers (0, 5, 1) && KindleUnpack - The Plugin (0, 83, 1) && Kobo Metadata (1, 5, 0) && Manage Series (1, 5, 2) && Modify ePub (1, 8, 3) && NASA STI Repository (1, 0, 2) && OverDrive Libby (0, 1, 9) && Overdrive Link (2, 57, 0) && Quality Check (1, 13, 10) && Quick Preferences (1, 7, 1) && Resize Cover (1, 2, 1) && Search The Internet (1, 11, 2) && Smashwords Metadata (1, 0, 2) && TTS to MP3 (0, 6, 0) && TextDiff (1, 2, 4) && Walk Search History (1, 5, 4) && Wikidata (2, 0, 0) && ePub Extended Metadata {Writer} (0, 11, 2) && ePub Extended Metadata {Reader} (0, 11, 2) && ePub Extended Metadata (0, 11, 2) && Overdrive Link Metadata Source (2, 57, 0)
Traceback (most recent call last):
File "calibre\db\backend.py", line 1159, in executemany
File "C:\t\t\apsw-42s16m2x\src\cursor.c", line 240, in resetcursor
apsw.ConstraintError: ConstraintError: constraint failed

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "calibre\gui2\actions\delete.py", line 459, in delete_books
File "calibre\gui2\actions\delete.py", line 436, in do_library_delete
File "calibre\gui2\library\models.py", line 459, in delete_books_by_id
File "calibre\db\cache.py", line 86, in call_func_with_lock
File "calibre\db\cache.py", line 2220, in remove_books
File "calibre\db\backend.py", line 2292, in remove_books
File "calibre\db\backend.py", line 1158, in executemany
apsw.SQLError: SQLError: no such savepoint: _apsw-0