MobileRead Forums - View Single Post

BookJunkieLI · 08-15-2021, 10:18 AM

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

I've also noticed the same message periodically when using the FanFicFare plugin but I don't think it's a plugin issue.

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:18 AM	#1
BookJunkieLI 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 I've also noticed the same message periodically when using the FanFicFare plugin but I don't think it's a plugin issue. Spoiler: calibre, version 5.23.0 ERROR: Error Updating Metadata: <p>An error has occurred while FanFicFare was updating calibre's metadata for <a href='https://archiveofourown.org/works/6859174'>Born This Way</a>.</p>The ebook has been updated, but the metadata has not. 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_plugins.fanficfare_plugin.fff_plugin" , line 2185, in set_custom File "calibre\db\legacy.py", line 769, in set_custom File "calibre\db\cache.py", line 1233, in set_field File "calibre\db\cache.py", line 1159, in mark_as_dirty File "calibre\db\cache.py", line 1152, in update_last_modified File "calibre\db\write.py", line 543, in set_books File "calibre\db\write.py", line 197, in one_one_in_books File "calibre\db\backend.py", line 949, in executemany apsw.SQLError: SQLError: no such savepoint: _apsw-0 During handling of the above exception, another exception occurred: Traceback (most recent call last): File "calibre_plugins.fanficfare_plugin.fff_plugin" , line 1784, in update_books_loop File "calibre_plugins.fanficfare_plugin.fff_plugin" , line 2300, in update_metadata File "calibre_plugins.fanficfare_plugin.fff_plugin" , line 2194, in set_custom File "calibre_plugins.fanficfare_plugin.fff_plugin" , line 2183, in raise_exception Exception: Trying to set entry (numWords) value(2691) to column (#words) failed (SQLError: no such savepoint: _apsw-0) 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.