Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre

Notices

Reply
 
Thread Tools Search this Thread
Old 08-15-2021, 10:18 AM   #1
BookJunkieLI
Evangelist
BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.
 
BookJunkieLI's Avatar
 
Posts: 423
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT
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.
BookJunkieLI is offline   Reply With Quote
Old 08-15-2021, 10:43 AM   #2
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 39,665
Karma: 17465128
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.
kovidgoyal is online now   Reply With Quote
Advert
Old 08-15-2021, 08:46 PM   #3
BookJunkieLI
Evangelist
BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.
 
BookJunkieLI's Avatar
 
Posts: 423
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT
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.
BookJunkieLI is offline   Reply With Quote
Old 08-16-2021, 02:28 AM   #4
ownedbycats
Wizard
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 2,940
Karma: 12800000
Join Date: Oct 2018
Device: Kobo Aura HD
Calibre doesn't handle NAS drives very well, and I suspect network drives are the same.
ownedbycats is online now   Reply With Quote
Old 08-16-2021, 10:58 AM   #5
BookJunkieLI
Evangelist
BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.
 
BookJunkieLI's Avatar
 
Posts: 423
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT
Quote:
Originally Posted by ownedbycats View Post
Calibre doesn't handle NAS drives very well, and I suspect network drives are the same.
Possibly but I never had any issues when it was connected to the network. Only now that it's been disconnected.
BookJunkieLI is offline   Reply With Quote
Advert
Old 08-16-2021, 11:02 AM   #6
BookJunkieLI
Evangelist
BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.
 
BookJunkieLI's Avatar
 
Posts: 423
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT
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
BookJunkieLI is offline   Reply With Quote
Old 08-16-2021, 11:07 AM   #7
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 39,665
Karma: 17465128
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You are running too old a version of calibre, update to at least 4.23
kovidgoyal is online now   Reply With Quote
Old 08-16-2021, 11:33 AM   #8
BookJunkieLI
Evangelist
BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.BookJunkieLI ought to be getting tired of karma fortunes by now.
 
BookJunkieLI's Avatar
 
Posts: 423
Karma: 572984
Join Date: Jan 2010
Location: Long Island
Device: Nook, REB 1100, Ebookwise 1500, Jb-Lite, PRS-650, PB302, Asus T-90MT

And this is why I'm trying to get everything consolidated properly.

That fixed it.

Thank you, Kovid.
BookJunkieLI is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 01:18 PM.


MobileRead.com is a privately owned, operated and funded community.