On Wed, Mar 7, 2012 at 9:30 AM, 跃峰 潘 <pyfs...@hotmail.com> wrote:
> > hi, We had a problem with sqlite 3.7.3. And we had no idea to solve it > or avoid it. So we write to you for reporting this bug. > The problem is described as follow.1. We used sqlite 3.7.3 on suse-11 > linux to create a database called 'rofsagent.db', which had only one > table.2. The schema is as follow:CREATE TABLE agent( path > VARCHAR(256), ipaddr VARCHAR(16), > port INTEGER, > get VARCHAR(256), > set VARCHAR(256), > time INTEGER, type INTEGER) > 3. After inserting about 250 records, the db file did not work. It > reported 'database disk image is malformed'. > For information on the possible reasons why an SQLite databases go corrupt, see http://www.sqlite.org/howtocorrupt.html > > 4. Using the command "PRAGMA quick_check;", the result is as:*** in > database main ***Main freelist: 2nd reference to page 112On tree page 26 > cell 3: Rowid 14315 out of order (previous was 14320)On tree page 60 cell > 1: Rowid 14007 out of order (previous was 14322)On tree page 61 cell 40: > Rowid 14264 out of order (previous was 15276)On tree page 65 cell 3: Rowid > 15280 out of order (max larger than parent max of 14264)On tree page 71 > cell 1: Rowid 14198 out of order (previous was 14345)On tree page 71 cell > 2: Rowid 14345 out of order (min less than parent min of 15280)On tree page > 115 cell 4: Rowid 14760 out of order (max larger than parent max of > 14335)On tree page 31 cell 1: Rowid 14323 out of order (previous was > 14339)On tree page 31 cell 4: Rowid 15023 out of order (previous was > 15425)On tree page 31 cell 4: Rowid 14339 out of order (min less than > parent min of 14760)On tree page 34 cell 3: Rowid 14960 out of order (min > less than parent min of 15023)On page 87 at right child > : 2nd reference to page 87Page 57 is never usedPage 96 is never used > 5. When we tried to use 'dump' command to recover the data, some records > lost. > Looking forward to hear from you soon. > Best wishes. > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
