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 05-14-2014, 02:52 AM   #1
scissors
Addict
scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.
 
Posts: 233
Karma: 1001369
Join Date: Sep 2010
Device: prs300, kindle keyboard 3g
intermittent problem

Hi All

every so often when calibre does an unattended news download, next time i wake my pc i'm greeted by an error alert with the following

Spoiler:

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

calibre 1.20 isfrozen: True is64bit: False
Windows-Vista-6.0.6002-SP2 Windows ('32bit', 'WindowsPE')
('Windows', 'Vista', '6.0.6002')
Python 2.7.5
Windows: ('Vista', '6.0.6002', 'SP2', 'Multiprocessor Free')
Traceback (most recent call last):
File "site-packages\calibre\gui2\__init__.py", line 393, in dispatch
File "site-packages\calibre\gui2\actions\fetch_news.py", line 62, in scheduled_recipe_fetched
File "site-packages\calibre\gui2\library\models.py", line 315, in add_news
File "site-packages\calibre\db\legacy.py", line 268, in add_news
File "site-packages\calibre\db\adding.py", line 162, in add_news
File "site-packages\calibre\db\cache.py", line 1379, in create_book_entry
File "site-packages\calibre\db\cache.py", line 1145, in set_metadata
File "site-packages\calibre\db\cache.py", line 1140, in set_field
File "site-packages\calibre\db\cache.py", line 961, in set_field
File "site-packages\calibre\db\write.py", line 513, in set_books
File "site-packages\calibre\db\write.py", line 187, in set_title
File "site-packages\calibre\db\write.py", line 178, in one_one_in_books
File "site-packages\calibre\db\backend.py", line 291, in executemany
SQLError: SQLError: no such savepoint: _apsw-0



The jobs reports 4 papers downloaded, yet the mirror is still on yesterdays date in the database.



I noticed this morning i have a windows update notice, which may have downloaded at the same time. I have noticed some of these windows update scans etc do hammer my cpu and it is often 100%. could this be the cause?
Attached Thumbnails
Click image for larger version

Name:	calibre.jpg
Views:	112
Size:	79.0 KB
ID:	122950  
scissors is offline   Reply With Quote
Old 05-14-2014, 03:07 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: 34,534
Karma: 11409410
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
That's a strange error, it implies that something is changing the metadata.db file while calibre is writing to it. Since sqlite (which calibre uses) locks the db file, I dont see how that is possible. Hardware errors?
kovidgoyal is offline   Reply With Quote
Advert
Old 05-14-2014, 01:01 PM   #3
scissors
Addict
scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.scissors ought to be getting tired of karma fortunes by now.
 
Posts: 233
Karma: 1001369
Join Date: Sep 2010
Device: prs300, kindle keyboard 3g
Quote:
Originally Posted by kovidgoyal View Post
That's a strange error, it implies that something is changing the metadata.db file while calibre is writing to it. Since sqlite (which calibre uses) locks the db file, I dont see how that is possible. Hardware errors?
hmm. did a chkdsk. okay.

just tried to change some metadata on a book and got

Spoiler:

calibre, version 1.20.0
ERROR: Permission denied: Could not change the on disk location of this book. Is it open in another program?

Locked file: d:\dropbox\public\daniel manus pinkwater\mrs. noodlekugel and four blind mic (7241)\cover.jpg

Traceback (most recent call last):
File "site-packages\calibre\gui2\metadata\basic_widgets.py", line 102, in commit
File "site-packages\calibre\db\legacy.py", line 814, in func
File "site-packages\calibre\db\cache.py", line 57, in call_func_with_lock
File "site-packages\calibre\db\cache.py", line 968, in set_field
File "site-packages\calibre\db\cache.py", line 979, in update_path
File "site-packages\calibre\db\backend.py", line 1418, in update_path
File "site-packages\calibre\utils\filenames.py", line 370, in __init__
IOError: [Errno 13] File is open in another process: u'd:\\dropbox\\public\\daniel manus pinkwater\\mrs. noodlekugel and four blind mic (7241)\\cover.jpg'



clicked ok. tried immediately again and it worked.
scissors is offline   Reply With Quote
Old 05-14-2014, 01:11 PM   #4
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: 34,534
Karma: 11409410
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
You need to pause dropbox while you are using calibre. http://manual.calibre-ebook.com/faq....rked-drive-nas
kovidgoyal 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
Kindle SD Intermittent tonyc46 Devices 14 04-01-2011 11:44 PM
calibre 0.7.48 - intermittent failure to start on Win7 64bit ndeb123 Devices 3 03-14-2011 03:45 PM
Debugging intermittent failures, how to? guterm Recipes 9 01-16-2011 01:20 AM
Intermittent Database Exception jt421 Calibre 7 12-22-2009 04:41 AM


All times are GMT -4. The time now is 12:59 PM.


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