> Please enter this line in the same sqlite3 tool you are using for > vacuum:
> PRAGMA integrity_check; > It appears that you have a copy of the database from before the > 'vacuum' command. If you can, take another copy and run the PRAGMA > command both before and after the 'vacuum'. For more details see > <http://www.sqlite.org/pragma.html> > Simon. Thanks, Simon, Before I ran vacuum, I ran pragma integrity_check; and got sqlite> pragma integrity_check; ok After I ran vacuum, I ran pragma integrity_check; again and got sqlite> pragma integrity_check; *** in database main *** On tree page 15 cell 36: Child page depth differs On tree page 15 cell 37: Child page depth differs On tree page 20 cell 1: Child page depth differs On tree page 3301422 cell 103: Child page depth differs On tree page 13623 cell 0: 2nd reference to page 13592 On tree page 13623 cell 1: 2nd reference to page 13593 On tree page 13623 cell 2: 2nd reference to page 13594 On tree page 13623 cell 3: 2nd reference to page 13595 On tree page 13623 cell 4: 2nd reference to page 13596 On tree page 13623 cell 5: 2nd reference to page 13597 On tree page 13623 cell 6: 2nd reference to page 13598 On tree page 13623 cell 7: 2nd reference to page 13599 On tree page 13623 cell 8: 2nd reference to page 13600 On tree page 13623 cell 9: 2nd reference to page 13601 On tree page 13623 cell 10: 2nd reference to page 13602 On tree page 13623 cell 11: 2nd reference to page 13603 On tree page 13623 cell 12: 2nd reference to page 13604 On tree page 13623 cell 13: 2nd reference to page 13605 On tree page 13623 cell 14: 2nd reference to page 13606 On tree page 13623 cell 15: 2nd reference to page 13607 On tree page 13623 cell 16: 2nd reference to page 13608 On tree page 13623 cell 17: 2nd reference to page 13609 On tree page 13623 cell 18: 2nd reference to page 13610 On tree page 13623 cell 19: 2nd reference to page 13611 On tree page 13623 cell 20: 2nd reference to page 13612 On tree page 13623 cell 21: 2nd reference to page 13613 On tree page 13623 cell 22: 2nd reference to page 13614 On tree page 13623 cell 23: 2nd reference to page 13615 On tree page 13623 cell 24: 2nd reference to page 13616 On tree page 13623 cell 25: 2nd reference to page 13617 On tree page 13623 cell 26: 2nd reference to page 13618 On tree page 13623 cell 27: 2nd reference to page 13619 On tree page 13623 cell 28: 2nd reference to page 13620 On tree page 13623 cell 29: 2nd reference to page 13621 On tree page 13623 cell 30: 2nd reference to page 13622 On tree page 13623 cell 31: 2nd reference to page 13624 On tree page 13623 cell 32: 2nd reference to page 13625 On tree page 13623 cell 33: 2nd reference to page 13626 On tree page 13623 cell 34: 2nd reference to page 13627 On tree page 13623 cell 35: 2nd reference to page 13628 On tree page 13623 cell 36: 2nd reference to page 13629 On tree page 13623 cell 37: 2nd reference to page 13630 On tree page 13623 cell 38: 2nd reference to page 13631 On tree page 13623 cell 39: 2nd reference to page 13632 On tree page 13623 cell 40: 2nd reference to page 13633 On tree page 13623 cell 41: 2nd reference to page 13634 On tree page 13623 cell 42: 2nd reference to page 13635 On tree page 13623 cell 43: 2nd reference to page 13636 On tree page 13623 cell 44: 2nd reference to page 13637 On tree page 13623 cell 45: 2nd reference to page 13638 On tree page 13623 cell 46: 2nd reference to page 13639 On tree page 13623 cell 47: 2nd reference to page 13640 On tree page 13623 cell 48: 2nd reference to page 13641 On tree page 13623 cell 49: 2nd reference to page 13642 On tree page 13623 cell 50: 2nd reference to page 13643 On tree page 13623 cell 51: 2nd reference to page 13644 On tree page 13623 cell 52: 2nd reference to page 13645 On tree page 13623 cell 53: 2nd reference to page 13646 On tree page 13623 cell 54: 2nd reference to page 13647 On tree page 13623 cell 55: 2nd reference to page 13648 On tree page 13623 cell 56: 2nd reference to page 13649 On tree page 13623 cell 57: 2nd reference to page 13650 On tree page 13623 cell 58: 2nd reference to page 13651 On tree page 13623 cell 59: 2nd reference to page 13652 On tree page 13623 cell 60: 2nd reference to page 13653 On tree page 13623 cell 61: 2nd reference to page 13654 On tree page 13623 cell 62: 2nd reference to page 13655 On tree page 13623 cell 63: 2nd reference to page 13656 On tree page 13623 cell 64: 2nd reference to page 13657 On tree page 13623 cell 65: 2nd reference to page 13658 On tree page 13623 cell 66: 2nd reference to page 13659 On tree page 13623 cell 67: 2nd reference to page 13660 On tree page 13623 cell 68: 2nd reference to page 13661 On tree page 13623 cell 69: 2nd reference to page 13662 On tree page 13623 cell 70: 2nd reference to page 13663 On tree page 13623 cell 71: 2nd reference to page 13664 On tree page 13623 cell 72: 2nd reference to page 13665 On tree page 13623 cell 73: 2nd reference to page 13666 On tree page 13623 cell 74: 2nd reference to page 13667 On tree page 13623 cell 75: 2nd reference to page 13668 On tree page 13623 cell 76: 2nd reference to page 13669 On tree page 13623 cell 77: 2nd reference to page 13670 On tree page 13623 cell 78: 2nd reference to page 13671 On tree page 13623 cell 79: 2nd reference to page 13672 On tree page 13623 cell 80: 2nd reference to page 13673 On tree page 13623 cell 81: 2nd reference to page 13674 On tree page 13623 cell 82: 2nd reference to page 13675 On tree page 13623 cell 83: 2nd reference to page 13676 On tree page 13623 cell 84: 2nd reference to page 13677 On tree page 13623 cell 85: 2nd reference to page 13678 On tree page 13623 cell 86: 2nd reference to page 13679 On tree page 13623 cell 87: 2nd reference to page 13680 On tree page 13623 cell 88: 2nd reference to page 13681 On tree page 13623 cell 89: 2nd reference to page 13682 On tree page 13623 cell 90: 2nd reference to page 13683 On tree page 13623 cell 91: 2nd reference to page 13684 On tree page 13623 cell 92: 2nd reference to page 13685 On tree page 13623 cell 93: 2nd reference to page 13686 On tree page 13623 cell 94: 2nd reference to page 13687 On tree page 13623 cell 95: 2nd reference to page 13688 There is something going on here, but I don't know what it is. Can anyone tell me what I can learn from this message and how to fix the problem? Thanks. Best, Jia _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users