Thread: Troubleshooting X-ray functionality for "War and Peace"
View Single Post
Old 04-26-2018, 04:20 PM   #23
j.p.s
Grand Sorcerer
j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.j.p.s ought to be getting tired of karma fortunes by now.
 
Posts: 5,821
Karma: 104662271
Join Date: Apr 2011
Device: pb360
I have tried two more experiments.

First, I turned off airplane mode for several hours. That didn't help.

Next, I deleted the book via the list view GUI and deleted the sidecar directory and all its contents via my computer. Then I redownloaded the book OTA via the list view GUI, opened the book, and waited for the XRAY option to no longer be grayed out, then waited some more. Still broken, still the same XRAY.entities.B00JCDK5ME.asc file size, but different md5sum.

I've used sqlite to dump both databases. The dumps are identical and have the same md5sum.
md5sum B00JCDK5ME.sql
7a6f5970d3628dae93f5e3f647653656 B00JCDK5ME.sql

B00JCDK5ME.sql has unix newlines and is 545055 bytes long, which is barely longer than the database itself. I thought sqlite databases are supposed to be very compact.

To dump the db:
Code:
sqlite3 XRAY.entities.B00JCDK5ME.asc
SQLite version 3.20.1 2017-08-24 16:21:36
Enter ".help" for usage hints.
sqlite> .output B00JCDK5ME.sql
sqlite> .dump
sqlite> .exit
Last edited by j.p.s; 04-26-2018 at 04:25 PM. Reason: Add C[CODE] tag
j.p.s is offline   Reply With Quote