On 22 Sep 2011, at 6:28pm, neelakanta reddy wrote: > The following is the result od pragma integrity check: > > sqlite> PRAGMA integrity_check; > *** in database main *** > Main freelist: 38 of 38 pages missing from overflow list starting at 0 > On tree page 608 cell 13: Rowid 1309 out of order (min less than parent min > of 1315) > Page 943 is never used
Are you using any PRAGMAs in apps which manipulate the database ? For instance 'PRAGMA synchronous = 0'. Are there any crashes or power-losses involved in getting the database to this stage ? Are you checking the result values returned by every SQLite operation, from the time you create the database to the point where 'PRAGMA integrity_check' shows something wrong ? If you do the same operations with the SQLite shell tool, do you get the same errors at the same point ? You can do this by simply putting all the commands in a text file and using '.read SQLCommands.txt' in the SQLite shell tool. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users