I got this corruption message 2 days back. I tried everything mentioned in the other topics and followed the steps . This is what i am getting. I am using Windows platform . Can someone help me get my database back. Two databases showed error p.db and m.db. p.db got fixed but m.db still showed errors with the new one
**Here is p.db
G:\sqlite-tools-win32-x86-3350400>sqlite3 p.db "PRAGMA integrity_check *** in database main *** On tree page 199551 cell 3: invalid page number 218103808 On tree page 222861 cell 0: invalid page number 218103808 On tree page 206996 cell 1: 2nd reference to page 222896 Page 199425: btreeInitPage() returns error code 11 Page 199424: btreeInitPage() returns error code 11 On tree page 201629 cell 2: invalid page number 218745600 On tree page 198526 cell 0: overflow list length is 20 but should be 34 On tree page 193894 cell 1: overflow list length is 48 but should be 43 On tree page 198861 cell 54: Rowid 7179 out of order On tree page 192678 cell 0: 2nd reference to page 130878 On tree page 189356 cell 2: 2nd reference to page 118958 On tree page 188306 cell 1: 2nd reference to page 186582 On tree page 187777 cell 2: overflow list length is 47 but should be 45 On tree page 182615 cell 0: 2nd reference to page 191267 On tree page 99946 cell 0: invalid page number 218103808 On tree page 180147 cell 0: 2nd reference to page 200305 On tree page 201032 cell 0: 2nd reference to page 223062 On tree page 179398 cell 0: 2nd reference to page 186584 On tree page 177644 cell 1: 2nd reference to page 185372 On tree page 163796 cell 0: 2nd reference to page 84671 On tree page 149529 cell 418: 2nd reference to page 160475 On tree page 163417 cell 0: Rowid 6406 out of order On tree page 163417 cell 0: 2nd reference to page 163585 On tree page 162448 cell 0: overflow list length is 53 but should be 35 On tree page 149529 cell 386: 2nd reference to page 161199 On tree page 162457 cell 2: 2nd reference to page 160553 On tree page 150204 cell 0: 2nd reference to page 160474 On tree page 134435 cell 1: 2nd reference to page 198525 On tree page 128684 cell 244: Rowid 5475 out of order On tree page 134394 cell 1: invalid page number 218103808 On tree page 134394 cell 0: 2nd reference to page 123528 On tree page 126539 cell 0: invalid page number 218103808 On tree page 133216 cell 0: 2nd reference to page 160472 On tree page 121764 cell 1: 2nd reference to page 199424 On tree page 113125 cell 0: 2nd reference to page 118932 On tree page 8063 cell 0: 2nd reference to page 9802 Page 7975: btreeInitPage() returns error code 11 On tree page 7912 cell 0: 2nd reference to page 9652 On tree page 7911 cell 0: 2nd reference to page 9719 On tree page 7830 cell 0: 2nd reference to page 10178 On tree page 7829 cell 0: 2nd reference to page 9569 On tree page 7673 cell 0: 2nd reference to page 9559 Page 7674 is never used Page 7675 is never used Page 7676 is never used Page 7677 is never used Page 7678 is never used Page 7679 is never used Page 7680 is never used Page 7681 is never used Page 7682 is never used Page 7683 is never used Page 7684 is never used Page 7685 is never used Page 7686 is never used Page 7687 is never used Page 7688 is never used Page 7689 is never used Page 7690 is never used Page 7691 is never used Page 7692 is never used Page 7693 is never used Page 7694 is never used Page 7695 is never used Page 7696 is never used Page 7697 is never used Page 7698 is never used Page 7699 is never used Page 7700 is never used Page 7701 is never used Page 7702 is never used Page 7703 is never used Page 7704 is never used Page 7705 is never used Page 7706 is never used Page 7707 is never used Page 7708 is never used Page 7709 is never used Page 7710 is never used Page 7711 is never used Page 7712 is never used Page 7713 is never used Page 7714 is never used Page 7715 is never used Page 7716 is never used Page 7717 is never used Page 7718 is never used Page 7719 is never used Page 7720 is never used Page 7721 is never used Page 7722 is never used Page 7723 is never used Page 7783 is never used Page 7784 is never used Page 7785 is never used Page 7786 is never used Page 7787 is never used Page 7788 is never used Page 7789 is never used Page 7790 is never used
G:\sqlite-tools-win32-x86-3350400>sqlite3 p.db “.dump” | sqlite3 p.new.db
2)Here is m.db
G:\sqlite-tools-win32-x86-3350400>sqlite3 m.db "PRAGMA integrity_check row 16951 missing from index index_MetaData_text row 16951 missing from index index_MetaData_type row 16951 missing from index index_MetaData_id row 16951 missing from index sqlite_autoindex_MetaData_1 row 16952 missing from index index_MetaData_text row 16952 missing from index index_MetaData_type row 16952 missing from index index_MetaData_id row 16952 missing from index sqlite_autoindex_MetaData_1 row 16953 missing from index index_MetaData_text row 16953 missing from index index_MetaData_type row 16953 missing from index index_MetaData_id row 16953 missing from index sqlite_autoindex_MetaData_1 row 16954 missing from index index_MetaData_text row 16954 missing from index index_MetaData_type row 16954 missing from index index_MetaData_id row 16954 missing from index sqlite_autoindex_MetaData_1 row 16955 missing from index index_MetaData_text row 16955 missing from index index_MetaData_type row 16955 missing from index index_MetaData_id row 16955 missing from index sqlite_autoindex_MetaData_1 row 16956 missing from index index_MetaData_text row 16956 missing from index index_MetaData_type row 16956 missing from index index_MetaData_id row 16956 missing from index sqlite_autoindex_MetaData_1 row 16957 missing from index index_MetaData_text row 16957 missing from index index_MetaData_type row 16957 missing from index index_MetaData_id row 16957 missing from index sqlite_autoindex_MetaData_1 row 16958 missing from index index_MetaData_text row 16958 missing from index index_MetaData_type row 16958 missing from index index_MetaData_id row 16958 missing from index sqlite_autoindex_MetaData_1 row 16959 missing from index index_MetaData_text row 16959 missing from index index_MetaData_type row 16959 missing from index index_MetaData_id row 16959 missing from index sqlite_autoindex_MetaData_1 row 16960 missing from index index_MetaData_text row 16960 missing from index index_MetaData_type row 16960 missing from index index_MetaData_id row 16960 missing from index sqlite_autoindex_MetaData_1 row 16961 missing from index index_MetaData_text row 16961 missing from index index_MetaData_type row 16961 missing from index index_MetaData_id row 16961 missing from index sqlite_autoindex_MetaData_1 row 16962 missing from index index_MetaData_text row 16962 missing from index index_MetaData_type row 16962 missing from index index_MetaData_id row 16962 missing from index sqlite_autoindex_MetaData_1 row 16963 missing from index index_MetaData_text row 16963 missing from index index_MetaData_type row 16963 missing from index index_MetaData_id row 16963 missing from index sqlite_autoindex_MetaData_1 row 16964 missing from index index_MetaData_text row 16964 missing from index index_MetaData_type row 16964 missing from index index_MetaData_id row 16964 missing from index sqlite_autoindex_MetaData_1 row 16965 missing from index index_MetaData_text row 16965 missing from index index_MetaData_type row 16965 missing from index index_MetaData_id row 16965 missing from index sqlite_autoindex_MetaData_1 row 23206 missing from index index_MetaData_text row 23206 missing from index index_MetaData_type row 23206 missing from index index_MetaData_id row 23206 missing from index sqlite_autoindex_MetaData_1 row 23207 missing from index index_MetaData_text row 23207 missing from index index_MetaData_type row 23207 missing from index index_MetaData_id row 23207 missing from index sqlite_autoindex_MetaData_1 row 23208 missing from index index_MetaData_text row 23208 missing from index index_MetaData_type row 23208 missing from index index_MetaData_id row 23208 missing from index sqlite_autoindex_MetaData_1 row 23209 missing from index index_MetaData_text row 23209 missing from index index_MetaData_type row 23209 missing from index index_MetaData_id row 23209 missing from index sqlite_autoindex_MetaData_1 row 23210 missing from index index_MetaData_text row 23210 missing from index index_MetaData_type row 23210 missing from index index_MetaData_id row 23210 missing from index sqlite_autoindex_MetaData_1 row 23211 missing from index index_MetaData_text row 23211 missing from index index_MetaData_type row 23211 missing from index index_MetaData_id row 23211 missing from index sqlite_autoindex_MetaData_1 row 23212 missing from index index_MetaData_text row 23212 missing from index index_MetaData_type row 23212 missing from index index_MetaData_id row 23212 missing from index sqlite_autoindex_MetaData_1 row 23213 missing from index index_MetaData_text row 23213 missing from index index_MetaData_type row 23213 missing from index index_MetaData_id row 23213 missing from index sqlite_autoindex_MetaData_1 row 23214 missing from index index_MetaData_text row 23214 missing from index index_MetaData_type row 23214 missing from index index_MetaData_id row 23214 missing from index sqlite_autoindex_MetaData_1 row 23215 missing from index index_MetaData_text row 23215 missing from index index_MetaData_type row 23215 missing from index index_MetaData_id row 23215 missing from index sqlite_autoindex_MetaData_1
G:\sqlite-tools-win32-x86-3350400>sqlite3 m.db “.dump” | sqlite3 m.new.db Error: near line 97456: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97457: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97458: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97459: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97460: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97461: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97462: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97463: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97464: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97465: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97466: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97467: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97468: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97469: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97470: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97553: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97554: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97555: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97556: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97557: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97558: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97559: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97560: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97561: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97562: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97563: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97564: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97565: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97566: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97567: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97838: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 97839: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116342: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116343: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116344: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116345: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116346: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116347: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116348: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116349: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116350: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116351: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116352: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116353: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116354: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116355: UNIQUE constraint failed: MetaData.id, MetaData.type Error: near line 116356: UNIQUE constraint failed: MetaData.id, MetaData.type