A free block list is not built well when a record in a leaf page is deleted. The list doesn't hold all free blocks sometimes. The bad list of deleted record cells makes recovery not that easy. For example:(showed in pictures) 1.1.png and 1.2.png: is after the the deletion of the record with information "2222---second", nothing is wrong. 2.1.png and 2.2.png: is after the deletion of two records with information "555--five"and"111--first" respectively,something is wrong. below is relative address 03A8h(0000h) means that it has only a free block,but we notice that there is two more free blocks.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users