View Ticket
Not logged in
Ticket UUID: 7c700d2f28838490fc5625779315576a8d657988
Title: Cannot rebuild a repository that has been ANALYZE'd by SQLite
Status: Fixed Type: Code_Defect
Severity: Important Priority:
Subsystem: Resolution: Fixed
Last Modified: 2010-06-23 11:55:04
Version Found In: 15b293259d
Description & Comments:
After I have opened a repository with SQLite to run ANALYZE on it, which was probably stupid, I cannot run fossil rebuild anymore. It attempts to drop table sqlite_stat1 and fails.

BMorgat added on 2010-06-23 07:30:31:
A solution to come over this problem is to run:

echo .dump | sqlite repository > dump.sql

then edit dump.sql to delete SQL statements from ANALYZE sqlite_master; to last INSERT INTO sqlite_stat1

then rm repository && sqlite repository < dump.sql