intermittent problem

[scissors]

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?

[kovidgoyal]

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?

[scissors]

Originally Posted by kovidgoyal

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.

[kovidgoyal]

You need to pause dropbox while you are using calibre. http://manual.calibre-ebook.com/faq....rked-drive-nas