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'.
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
