08-15-2021, 10:18 AM | #1 |
Evangelist
Posts: 435
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,
|
Error message when deleting books
I've recently been working on combining all of the various libraries I've created over the years and getting rid of duplicates. Of which there are a lot.
In the last couple weeks I've started running into the following error message when deleting files. Code:
calibre, version 5.23.0 ERROR: Failed to delete: Failed to delete some books, click the "Show details" button for details. ==> Man and Brother Traceback (most recent call last): File "calibre\db\backend.py", line 949, in executemany apsw.IOError: IOError: disk I/O error During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre\gui2\actions\delete.py", line 66, in delete_one File "calibre\db\legacy.py", line 459, in delete_book File "calibre\db\cache.py", line 76, in call_func_with_lock File "calibre\db\cache.py", line 1785, in remove_books File "calibre\db\tables.py", line 272, in remove_books File "calibre\db\backend.py", line 949, in executemany apsw.SQLError: SQLError: no such savepoint: _apsw-0 Spoiler:
Since it is a disk I/O error I immediately suspected hard drive issues but two Disk Checks have come up completely clean and I haven't noticed issues in any of the other programs I use. I also did a Check Library that came back with no significant issues. My machine specs are: Windows 10 Pro 64-bit 8gb RAM Calibre 5.23 (64-bit) 595GB free on a 1TB hard drive. Any help would be greatly appreciated. |
08-15-2021, 10:43 AM | #2 |
creator of calibre
Posts: 44,381
Karma: 23766374
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
Its an I/O error which means reading/writing to the disk is failing. If itsnt hardware failure then the other thing that can cause it is programs that intefere. You can try running in sfe mode and/or excluding the library directories from all file sync/antivirus and similar programs.
|
Advert | |
|
08-15-2021, 08:46 PM | #3 |
Evangelist
Posts: 435
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,
|
Thanks, Kovid.
I restarted in Safe Mode and I suspect the issue is that this is my old work computer that is no longer connected to the network. Once in Safe Mode I couldn't access My Documents because it's a redirected folder that I'm guessing technically lived on the server but was mirrored to the workstation. I'll have to try dropping everything onto an external drive and see if that solves the problem. |
08-16-2021, 02:28 AM | #4 |
Custom User Title
Posts: 9,332
Karma: 63265021
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
|
Calibre doesn't handle NAS drives very well, and I suspect network drives are the same.
|
08-16-2021, 10:58 AM | #5 |
Evangelist
Posts: 435
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,
|
|
Advert | |
|
08-16-2021, 11:02 AM | #6 |
Evangelist
Posts: 435
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,
|
I moved the libraries over to an external drive and now I'm getting a new SQL error message and it seems like it won't delete books at all. I'm using Calibre Portable directly on the external drive. I've pretty much always used Calibre Portable so that I could just copy everything to a drive and not lose my settings.
Code:
calibre, version 3.47.1 ERROR: Unhandled exception: <b>SQLError</b>:SQLError: no such module: fts5 calibre 3.47.1 Portable embedded-python: True is64bit: False Windows-10-10.0.16299-SP0 Windows ('32bit', 'WindowsPE') 32bit process running on 64bit windows ('Windows', '10', '10.0.16299') Python 2.7.15+ Windows: ('10', '10.0.16299', 'SP0', u'Multiprocessor Free') Interface language: None Successfully initialized third party plugins: Favourites Menu (1, 0, 4) && Fantastic Fiction Adults (1, 0, 4) && FictionDB (1, 0, 10) && Find Duplicates (1, 6, 3) && EpubMerge (2, 6, 0) && Quality Check (1, 9, 11) && FanFicFare (3, 13, 0) && SmartEject (2, 2, 0) && Count Pages (1, 9, 0) && Barnes & Noble (1, 2, 15) && View Manager (1, 4, 3) && CalibreSpy (1, 0, 75) && EpubSplit (2, 8, 0) && Manage Series (1, 2, 8) && Ex Libris (1, 0, 19) && Job Spy (1, 0, 169) && Generate Cover (1, 5, 21) && Kindle Collections (1, 7, 24) && Modify ePub (1, 4, 0) && Library Splitter (1, 0, 1) && Reading List (1, 6, 6) && Goodreads (1, 4, 0) && Consolidate All Library Metadata (2, 0, 33) && Fantastic Fiction (1, 2, 0) Traceback (most recent call last): File "site-packages\calibre\gui2\actions\copy_to_library.py", line 393, in choose_library File "site-packages\calibre\gui2\actions\copy_to_library.py", line 446, in copy_to_library File "site-packages\calibre\gui2\actions\copy_to_library.py", line 512, in do_copy File "site-packages\calibre\gui2\library\models.py", line 415, in delete_books_by_id File "site-packages\calibre\db\cache.py", line 62, in call_func_with_lock File "site-packages\calibre\db\cache.py", line 1647, in remove_books File "site-packages\calibre\db\backend.py", line 1676, in remove_books File "site-packages\calibre\db\backend.py", line 886, in executemany File "c:\t\t\apsw-zu_bhl\apsw-3.27.2-r1\src\cursor.c", line 1136, in APSWCursor_executemany.sqlite3_prepare File "c:\t\t\apsw-zu_bhl\apsw-3.27.2-r1\src\statementcache.c", line 386, in sqlite3_prepare SQLError: SQLError: no such module: fts5 |
08-16-2021, 11:07 AM | #7 |
creator of calibre
Posts: 44,381
Karma: 23766374
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
You are running too old a version of calibre, update to at least 4.23
|
08-16-2021, 11:33 AM | #8 |
Evangelist
Posts: 435
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Kobo Libra 2, Kindle 4, Nook Gl4, Nook STR, REB 1100, Ebookwise 1500,
|
And this is why I'm trying to get everything consolidated properly. That fixed it. Thank you, Kovid. |
04-18-2024, 07:50 PM | #9 |
Junior Member
Posts: 3
Karma: 10
Join Date: Apr 2024
Device: none
|
Savepoint error
I get a similar error. 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. Here's the error message:
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 |
05-01-2024, 11:07 AM | #10 |
Resident Curmudgeon
Posts: 76,002
Karma: 134368292
Join Date: Nov 2006
Location: Roslindale, Massachusetts
Device: Kobo Libra 2, Kobo Aura H2O, PRS-650, PRS-T1, nook STR, PW3
|
You need to right click on the database name on the toolbar and select Library maintenance and then select Restore database as your database has been corrupted.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calibre 64 bit error message when deleting book | teresac | Calibre | 12 | 01-19-2021 07:15 AM |
Resinstate alert message for deleting books | maybedog | Library Management | 2 | 04-15-2017 07:01 PM |
Error in Adding/Deleting Books | toomuchreading | Calibre | 10 | 10-15-2013 05:30 AM |
Calibre Error Message - Now I have NO BOOKS | SmiLynnLady | Calibre | 10 | 07-14-2011 05:12 AM |