On Wed, 10 Feb 2010 10:05:34 +0530, <ramesh.kotab...@wipro.com> wrote:
>Hi All, > >I am Ramesh, facing come issue regarding DB malformed, find trace below. > > sqlite> pragma integrity_check; > *** in database main *** > Main freelist: 4 of 4 pages missing from overflow list starting at 0 > Page 1515 is never used > Page 1519 is never used > Page 1528 is never used > Page 1529 is never used > sqlite> > >The above DB can be recover by using VACUUM command. > > sqlite> vacuum; > sqlite> pragma integrity_check; > ok > sqlite> > >Presently PRAGMA auto_vacuum is disabled, and we are using as it is, > >Please give me you suggestions to over come this issue, > >will enabling PRAGMA auto_vacuum will solve the issue, Probably not. >OR any othet way...? In which version of SQLite does this happen? SELECT sqlite_version(); Check the timeline, there have been similar issues in the past. Perhaps you use an old version. http://www.sqlite.org/src/timeline Make sure you use one of the latest. >Thanks in advance. > >Regards, >Ramesh -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users