On Fri, Nov 12, 2010 at 10:31 AM, Wilson, Ronald <rwils...@harris.com>wrote:
> I've got a 500 mb database with one table that I set up to log system > information over night and I arrive this morning to find this situation. > The database was generated on windows using vbscript and the sqliteodbc > driver based on sqlite 3.7.2. Do I have any hope of recovery? > Probably not. I'll bet if you look at the database file beginning at page 140481 you see that it has been overwritten with something that is not database information, perhaps with all zeros. You can probably use the ".dump" utility to extract most or all of the information prior to page 140481, though. So you can get some of your database back. Have you tried that? > > SQLite version 3.6.22 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> pragma integrity_check; > *** in database main *** > Page 140481: btreeInitPage() returns error code 11 > On tree page 140458 cell 65: Child page depth differs > Page 140482: btreeInitPage() returns error code 11 > Page 140483: btreeInitPage() returns error code 11 > Page 140484: btreeInitPage() returns error code 11 > Page 140485: btreeInitPage() returns error code 11 > Page 140486: btreeInitPage() returns error code 11 > Page 140487: btreeInitPage() returns error code 11 > Page 140488: btreeInitPage() returns error code 11 > Page 140489: btreeInitPage() returns error code 11 > Page 140490: btreeInitPage() returns error code 11 > Page 140491: btreeInitPage() returns error code 11 > Page 140492: btreeInitPage() returns error code 11 > Page 140493: btreeInitPage() returns error code 11 > Page 140494: btreeInitPage() returns error code 11 > Page 140495: btreeInitPage() returns error code 11 > Page 140496: btreeInitPage() returns error code 11 > Page 140497: btreeInitPage() returns error code 11 > Page 140498: btreeInitPage() returns error code 11 > Page 140499: btreeInitPage() returns error code 11 > Page 140500: btreeInitPage() returns error code 11 > Page 140501: btreeInitPage() returns error code 11 > Page 140502: btreeInitPage() returns error code 11 > Page 140503: btreeInitPage() returns error code 11 > Page 140504: btreeInitPage() returns error code 11 > Page 140505: btreeInitPage() returns error code 11 > Page 140506: btreeInitPage() returns error code 11 > Page 140507: btreeInitPage() returns error code 11 > Page 140508: btreeInitPage() returns error code 11 > Page 140509: btreeInitPage() returns error code 11 > Page 140510: btreeInitPage() returns error code 11 > Page 140511: btreeInitPage() returns error code 11 > Page 140512: btreeInitPage() returns error code 11 > Page 140513: btreeInitPage() returns error code 11 > Page 140514: btreeInitPage() returns error code 11 > On tree page 143459 cell 12: Child page depth differs > Page 140515: btreeInitPage() returns error code 11 > Page 140516: btreeInitPage() returns error code 11 > Page 140517: btreeInitPage() returns error code 11 > Page 140518: btreeInitPage() returns error code 11 > Page 140519: btreeInitPage() returns error code 11 > Page 140520: btreeInitPage() returns error code 11 > Page 140521: btreeInitPage() returns error code 11 > Page 140522: btreeInitPage() returns error code 11 > Page 140523: btreeInitPage() returns error code 11 > Page 140524: btreeInitPage() returns error code 11 > Page 140525: btreeInitPage() returns error code 11 > Page 140526: btreeInitPage() returns error code 11 > Page 140527: btreeInitPage() returns error code 11 > Page 140528: btreeInitPage() returns error code 11 > Page 140529: btreeInitPage() returns error code 11 > Page 140530: btreeInitPage() returns error code 11 > Page 140531: btreeInitPage() returns error code 11 > Page 140532: btreeInitPage() returns error code 11 > Page 140533: btreeInitPage() returns error code 11 > Page 140534: btreeInitPage() returns error code 11 > Page 140535: btreeInitPage() returns error code 11 > Page 140536: btreeInitPage() returns error code 11 > Page 140537: btreeInitPage() returns error code 11 > Page 140538: btreeInitPage() returns error code 11 > Page 140539: btreeInitPage() returns error code 11 > Page 140540: btreeInitPage() returns error code 11 > Page 140541: btreeInitPage() returns error code 11 > Page 140542: btreeInitPage() returns error code 11 > Page 140543: btreeInitPage() returns error code 11 > Page 140544: btreeInitPage() returns error code 11 > On tree page 140558 cell 30: Child page depth differs > On tree page 143459 cell 13: Child page depth differs > Page 161860: btreeInitPage() returns error code 11 > On tree page 163261 cell 28: Child page depth differs > Page 161917: btreeInitPage() returns error code 11 > Page 161918: btreeInitPage() returns error code 11 > Page 161919: btreeInitPage() returns error code 11 > Page 161920: btreeInitPage() returns error code 11 > On tree page 161960 cell 4: Child page depth differs > On tree page 163261 cell 29: Child page depth differs > Page 162113: btreeInitPage() returns error code 11 > On tree page 162060 cell 95: Child page depth differs > Page 162114: btreeInitPage() returns error code 11 > Page 162115: btreeInitPage() returns error code 11 > Page 162116: btreeInitPage() returns error code 11 > On tree page 163261 cell 30: Child page depth differs > Page 162160: btreeInitPage() returns error code 11 > On tree page 163261 cell 31: Child page depth differs > Page 162217: btreeInitPage() returns error code 11 > Page 162218: btreeInitPage() returns error code 11 > Page 162219: btreeInitPage() returns error code 11 > Page 162220: btreeInitPage() returns error code 11 > Page 162221: btreeInitPage() returns error code 11 > Page 162222: btreeInitPage() returns error code 11 > Page 162223: btreeInitPage() returns error code 11 > Page 162224: btreeInitPage() returns error code 11 > Page 162225: btreeInitPage() returns error code 11 > Page 162226: btreeInitPage() returns error code 11 > Page 162227: btreeInitPage() returns error code 11 > Page 162228: btreeInitPage() returns error code 11 > Page 162229: btreeInitPage() returns error code 11 > Page 162230: btreeInitPage() returns error code 11 > Page 162231: btreeInitPage() returns error code 11 > Page 162232: btreeInitPage() returns error code 11 > sqlite> vacuum; > Error: database disk image is malformed > sqlite> > > Ron Wilson, Engineering Project Lead > (o) 434.455.6453, (m) 434.851.1612, www.harris.com > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
