Dear all,
I just try to delete data from sqlite3 database and I get the following: “sqlite3: database disk image is malformed” I check the integrity of the database with this tool: http://www.sqlite.org/2013/sqlite-shell-win32-x86-3080200.zip and the following line command: sqlite3 MYDB.db “pragma integrity_check” I have the following problems: On tree page 9 cell 15: Rowid 1099134 out of order (max larger than parent min of 1099036) On tree page 1548 cell 9: Rowid 1099118 out of order (max larger than parent max of 1099061) On tree page 4 cell 2: 2nd reference to page 239 On tree page 4 cell 2: Child page depth differs On tree page 4 cell 3: Rowid 1099108 out of order (previous was 1100371) On tree page 295 cell 1: Rowid 1099096 out of order (previous was 1100372) On tree page 4 cell 3: Child page depth differs On tree page 4 cell 4: 2nd reference to page 1548 On tree page 4 cell 4: Child page depth differs On tree page 4 cell 5: 2nd reference to page 9 I try to make à clean copy of the database with the following command: Sqlite3 MYDB.db .dump | sqlite3 MYDB _NEW.db And I get the following: Error: near line 859: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 860: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 861: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 862: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 863: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 864: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 865: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 866: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 867: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 868: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 869: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 870: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 871: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 872: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 873: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 874: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 875: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 876: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 877: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 878: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 879: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 880: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 881: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 882: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 883: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Error: near line 884: UNIQUE constraint failed: TB_SPOOL_FEATURE_CLASS_EVENTS_DETAIL.INT_SpoolEventDetailId Can you explain me please in which conditions these kind of errors occurs and how can I fix my database? Thank Best regards Jose _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
