Hello, We have been using SQLite for our desktop application for around an year now. Suddenly we started getting weird errors and could see multiple entries in the same table violating primary key constraints. The version of of SQLite is 3 and System.Data.SQLite is 1.0.82.0.
The table schema is as follows - CREATE TABLE [Configurations] ( [Key] nvarchar(200) NOT NULL, [Value] text NULL, [TillId] int NOT NULL, PRIMARY KEY ([Key],[TillId]) ) Integrity check gives the following result - <z:row integrity_check="**** in database main *** On tree page 18 cell 8: Rowid 1913 out of order (previous was 2743) On tree page 127 cell 6: Rowid 1910 out of order (previous was 3192) On tree page 51 cell 2: 2nd reference to page 14081 On tree page 51 cell 2: Child page depth differs Page 17781 is never used*" /> <z:row integrity_check="*rowid 1910 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1911 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1912 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1913 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1914 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1915 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1916 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1917 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*rowid 1918 missing from index sqlite_autoindex_Configurations_1*" /> <z:row integrity_check="*wrong # of entries in index sqlite_autoindex_Configurations_1*" /> The problem is that when performing write on the table there is no error thrown. But, when we try to read data we get error as - *The database disk image is malformed.* Also, could you tell us that is there a corner case scenario where the Primary_Key constraint will get violated, because we could see multiple entries in the table with same key pairs. Thanks in Advance. Regards, Priyam Chokhani _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
