[PeterT]

I've taken a look, and the problem is that the content table has some corruption. A count of the rows in it shows 15117, however I'm only able to retrieve 4,757 rows from it so attempts to build a new database from a dump of the old one fail.

An integrity check shows

*** in database main ***
Page 17620: btreeInitPage() returns error code 11
On tree page 16705 cell 80: Child page depth differs
On tree page 16705 cell 81: Child page depth differs
Page 17650: btreeInitPage() returns error code 11
On tree page 16705 cell 92: Child page depth differs
On tree page 16705 cell 93: Child page depth differs
On tree page 6819 cell 20: 2nd reference to page 7209
On tree page 6819 cell 20: Child page depth differs
On tree page 20 cell 1: Child page depth differs
Page 17619 is never used
Page 17621 is never used
Page 17648 is never used
Page 17649 is never used
rowid 19971 missing from index analytics_events_timestamp
rowid 19971 missing from index sqlite_autoindex_AnalyticsEvents_1
wrong # of entries in index analytics_events_timestamp
wrong # of entries in index sqlite_autoindex_AnalyticsEvents_1

If davidfor sees this, any thoughts?

I know you don't want to reset the database but you probably will have to sooner or later.