【原创】sqlite3数据库“SQL error: database disk image is malformed”问题探究(2)
Author: chad
Mail: linczone@163.com
本文可以自由转载,但转载请务必注明出处以及本声明信息。
在《sqlite3数据库SQL error: database disk image is malformed问题探究<1>》中对“SQL error: database disk image is malformed”问题已经进行了详细的实验分析,本以为事情已经处理的差不多,但是,对本附件的数据库进行分析后才发现,问题远没有那么简单!对本数据库的实验记录如下:
- 数据库总体检测:
[root@Chad: data]#sqlite3 terminal.db
SQLite version 3.6.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> PRAGMA integrity_check;
*** in database main ***
Page 7927: sqlite3BtreeInitPage() returns error code 11
On tree page 8366 cell 15: Child page depth differs
On tree page 8366 cell 16: Child page depth differs
Page 7928: sqlite3BtreeInitPage() returns error code 11
On tree page 8366 cell 20: Child page depth differs
On tree page 8366 cell 21: Child page depth differs
Page 2684: sqlite3BtreeInitPage() returns error code 11
On tree page 56 cell 40: Child page depth differs
On tree page 56 cell 41: Child page depth differs
。。。。。。省去n多行
On tree page 636 cell 55: Child page depth differs
On tree page 660 cell 22