I have a customer that has a database that has somehow become corrupted.
I'm fairly certain he was on v3.4.1 but I'll double check. The database
isn't completely bad, I can look at the master table and one of the two
tables in the database. But if the second table is touched SQLITE_CORRUPT
is returned. Running sqlite3_analyzer returns the following (StatData is
the second table)
Analyzing table StatData...
ERROR: SQLITE_CORRUPT
SQLITE_CORRUPT
while executing
"btree_next $csr"
("foreach" body line 32)
invoked from within
"foreach {name rootpage} [db eval $sql] {
puts stderr "Analyzing table $name..."
# Code below traverses the table being analyzed (table name $name..."
He is running with pragma synchronous off, but I thought that only opened up
the possibility for corruption if there was a power, OS, or hardware
failure, which he doesn't think occurred (it is Windows, and the server was
rebooted at some point.)
I suspect the answer is no, but is there any way to salvage any of the data?
Thanks
Doug
