Thanks for your replies, Simon and Dair. Yes, it is probably a bug in sqlite version 3.6.10. After I upgraded to version 3.6.12, I ran vacuum again and had no problems.
I do have more questions. I want to clean fragmentation in the database with vacuum command. When I ran a combination of '.dump' and '.read' commands to create a new database, for example, $sqlite3 hq.db '.dump' | sqlite3 hq_new.db, does it achieve the same thing as vacuum does? If yes, what's the advantage of vaccum? Thanks. Best, Jia On Sat, Oct 31, 2009 at 5:55 PM, Dair Grant <d...@refnum.com> wrote: > chen jia wrote: > >> Before I ran vacuum, I ran pragma integrity_check; and got >> sqlite> pragma integrity_check; >> ok >> >> After I ran vacuum, I ran pragma integrity_check; again and got >> sqlite> pragma integrity_check; >> *** in database main *** >> On tree page 15 cell 36: Child page depth differs >> On tree page 15 cell 37: Child page depth differs >> On tree page 20 cell 1: Child page depth differs > > This sounds like an issue I ran into: > > <http://www.mail-archive.com/sqlite-users@sqlite.org/msg40704.html> > > I sent some test cases to DRH to examine and he indicated the bug was > present in 3.6.10 but was fixed in 3.6.11. > > > -dair > ___________________________________________________ > d...@refnum.com http://www.refnum.com/ > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Ohio State University - Finance 248 Fisher Hall 2100 Neil Ave. Columbus, Ohio 43210 Telephone: 614-292-2979 http://www.fisher.osu.edu/~chen_1002/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
