Clara HD database disk image error

[retro]

Originally Posted by geek1011

Or OverDrive.

That's interesting. I don't use Overdrive, but I did try it out once and downloaded a book. I have since deleted the book, but everytime I do a reset and login, I get a message that a book has expired. Odd since the book is not on the device and I don't see any reference to it in my Kobo account. And it's after a reset so it must be connected to my Kobo account.
Next time I might use a new Kobo account and see if that makes a difference.
Thanks for the idea!

[PeterT]

I can't help but think it might be a USB port issue; that the cable is coming loose and corrupting data transfers.

Sent from my SM-T290 using Tapatalk

[retro]

Following up, I have been using my Clara for about a week after a factory reset. Last night I finished a book and when I tried to remove it, it was not completely removed. The book still showed in the list but when selected, I get an error that I am not authorized to read the book.

I connected and tried to open the databases, KoboReader.sqlite opened and the test showed no problems but BookReader.sqlite gave this error.

Could not open database file
Reason: disk I/O error

When I did this after the reset, both were readable even though BookReader.sqlite required a password.

So I closed SQLitedatabasebrowser and opened calibre with no errors and calibre let me delete the file from the reader. When loading a couple of books, one loaded and the other threw an error. That book did show up in the folder on the reader but without a cover.

After the last reset, I made a copy of BookReader.sqlite, so I deleted the one on the reader and replaced it with the copy. This worked!

I know it's not the way to correctly troubleshoot and the disk I/O error points to the sd card, but after so many times going through this, I wanted to see if BookReader.sqlite was the culprit and it seems it is. Why it keeps happening is the real question and I guess I need to try yet another sd card.

So my issues are still ongoing.....

[compurandom]

Originally Posted by davidfor

I don't think it is a software issue. I think it is more likely that the file system was corrupt somehow, or possibly the SD card is failing.

I am convinced that calibre corrupted the database on my brand new forma at least 3x. Both times I restored the database from the kobo utilities backup and everything was ok. Once the forma reset itself and logged me out. I am very sure I ejected correctly every time, and at least one of the times I hadn't done anything on the kobo except import books between when the database was OK and when it was corrupted.

Whatever the problem was, it went away when I upgraded from 4.x to 5.2 and then upgraded all my plugins. Sorry, I didn't try to debug it.

It may have been a race condition between calibre modifying the sqlite database and a plugin modifying it.