Fossil SCM
Cannot rebuild a repository that has been ANALYZE'd by SQLite
Fixed
7c700d2f2883849…
· opened 15 years, 9 months ago
- Type
- Code_Defect
- Priority
- —
- Severity
- Important
- Resolution
- Fixed
- Subsystem
- —
- Created
- June 22, 2010 4:39 p.m.
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