[Cootey]

Alright. I've got a corrupt database again. I was working with Kobo tech over a different issue (Elipsa doesn't prompt to review or rate purchased books when they are finished). I was asked to connect my Elipsa to Kobo Desktop on my Mac. It synced fine. No books were added. I cmd-shift-i'd my log file. Then I got busy working on something else. When I ejected my Elipsa properly, it suddenly reimported EVERYTHING all over again. All my purchased downloads have disappeared, again.

I connected it to the Mac again, this time with Calibre. I immediately got the ERROR: Error dialog letting me know "Error communicating with device".

Here is the clipboard error output:

calibre, version 5.23.0
ERROR: Error: Error communicating with device

CorruptError: database disk image is malformed

Traceback (most recent call last):
  File "calibre/gui2/device.py", line 89, in run
  File "calibre/gui2/device.py", line 515, in _books
  File "calibre/devices/kobo/driver.py", line 1974, in books
apsw.CorruptError: CorruptError: database disk image is malformed

If I repair the account on the Kobo, I know it will be fixed. Then I have to redownload everything again. Instead, I have opted to try to check the database using Calibre.

Result of running 'PRAGMA integrity_check' on database on the Kobo device:

Spoiler:

*** in database main ***
On tree page 16876 cell 1: Rowid 393 out of order
On tree page 44734 cell 1: Rowid 348 out of order
On tree page 44734 cell 0: 2nd reference to page 49801
On tree page 51788 cell 1: 2nd reference to page 51790
On tree page 529 cell 2: Rowid 40093 out of order
Page 50211: btreeInitPage() returns error code 11
On tree page 29598 cell 103: Child page depth differs
On tree page 50155 cell 0: invalid page number 167850496
Page 1150: btreeInitPage() returns error code 11
Page 543: btreeInitPage() returns error code 11
Page 520: btreeInitPage() returns error code 11
Page 463: btreeInitPage() returns error code 11
Page 457: btreeInitPage() returns error code 11
Page 497: btreeInitPage() returns error code 11
On tree page 526 cell 3: invalid page number 218103808
Page 505: btreeInitPage() returns error code 11
On tree page 481 cell 0: invalid page number 218103808
Page 50171: btreeInitPage() returns error code 11
Page 971: btreeInitPage() returns error code 11
Page 964: btreeInitPage() returns error code 11
Page 50176: btreeInitPage() returns error code 11
Page 50204: btreeInitPage() returns error code 11
On tree page 130 cell 3: Rowid 39762 out of order
On tree page 130 cell 3: 2nd reference to page 50274
On tree page 50166 cell 39: Rowid 39672 out of order
On tree page 1260 cell 0: Rowid 41643 out of order
Page 50157: btreeInitPage() returns error code 11
Page 50215: btreeInitPage() returns error code 11
On tree page 1165 cell 5: invalid page number 218103808
On tree page 1165 cell 0: invalid page number 218103808
Page 319: btreeInitPage() returns error code 11
On tree page 978 cell 4: Rowid 41636 out of order
Page 539: btreeInitPage() returns error code 11
Page 8888: btreeInitPage() returns error code 11
Page 1134: btreeInitPage() returns error code 11
On tree page 50190 cell 5: Rowid 41611 out of order
On tree page 50190 cell 4: 2nd reference to page 51806
On tree page 50190 cell 3: 2nd reference to page 50269
On tree page 50262 cell 0: 2nd reference to page 579
Page 1129: btreeInitPage() returns error code 11
On tree page 50170 cell 5: Rowid 41605 out of order
On tree page 50170 cell 0: 2nd reference to page 640
On tree page 50260 cell 4: invalid page number 218103808
On tree page 50260 cell 1: invalid page number 218103808
On tree page 979 cell 2: Rowid 41572 out of order
On tree page 979 cell 2: 2nd reference to page 1290
On tree page 979 cell 1: 2nd reference to page 50171
Page 469: btreeInitPage() returns error code 11
Page 931: btreeInitPage() returns error code 11
Page 232: btreeInitPage() returns error code 11
Page 8893: btreeInitPage() returns error code 11
Page 566: btreeInitPage() returns error code 11
On tree page 50159 cell 2: Rowid 41559 out of order
On tree page 50159 cell 1: 2nd reference to page 566
Page 50172: btreeInitPage() returns error code 11
On tree page 50259 cell 0: 2nd reference to page 1485
On tree page 10131 cell 3: Rowid 41437 out of order
On tree page 10131 cell 3: invalid page number 218103808
Page 547: btreeInitPage() returns error code 11
On tree page 50258 cell 4: invalid page number 218103808
On tree page 50258 cell 3: 2nd reference to page 482
On tree page 50258 cell 1: 2nd reference to page 366
Page 230: btreeInitPage() returns error code 11
Page 2303: btreeInitPage() returns error code 11
On tree page 957 cell 4: Rowid 41536 out of order
Page 1198: btreeInitPage() returns error code 11
Page 1434: btreeInitPage() returns error code 11
Page 518: btreeInitPage() returns error code 11
Page 1348: btreeInitPage() returns error code 11
Page 509: btreeInitPage() returns error code 11
On tree page 476 cell 3: invalid page number 218103808
Page 1302: btreeInitPage() returns error code 11
Page 18616: btreeInitPage() returns error code 11
Page 461: btreeInitPage() returns error code 11
On tree page 29598 cell 102: Child page depth differs
On tree page 459 cell 5: Rowid 41661 out of order
On tree page 459 cell 3: 2nd reference to page 1161
On tree page 459 cell 2: invalid page number 167884544
On tree page 501 cell 3: Rowid 41502 out of order
On tree page 501 cell 2: 2nd reference to page 18616
On tree page 501 cell 0: 2nd reference to page 523
Page 618: btreeInitPage() returns error code 11
On tree page 363 cell 2: 2nd reference to page 612
On tree page 363 cell 1: 2nd reference to page 1573
On tree page 363 cell 0: 2nd reference to page 1398
On tree page 44802 cell 79: 2nd reference to page 45116
On tree page 44802 cell 52: Rowid 35248 out of order
On tree page 44802 cell 52: 2nd reference to page 45112
On tree page 44802 cell 51: 2nd reference to page 45105
On tree page 44802 cell 50: 2nd reference to page 45103
On tree page 44802 cell 49: 2nd reference to page 45101
On tree page 44802 cell 48: 2nd reference to page 45091
On tree page 44802 cell 47: 2nd reference to page 45090
On tree page 44802 cell 46: 2nd reference to page 45085
On tree page 44802 cell 45: 2nd reference to page 45081
On tree page 44802 cell 44: 2nd reference to page 45079
On tree page 44802 cell 43: 2nd reference to page 45076
On tree page 44802 cell 42: 2nd reference to page 45071
On tree page 44802 cell 41: 2nd reference to page 45070
On tree page 44802 cell 40: 2nd reference to page 45058

This is an annoying bug. Since the Elipsa was mounted on my desktop for an hour, I wonder if Spotlight's search indexing caused a problem. I have now excluded KOBOeReader from being indexed. But this could be a Kobo Desktop problem, too. Any suggestions on how to isolate who is at fault?

How fortunate for me that I just did a backup half an hour ago before this happened.