Wrong # of entries in index MyOtherTableAndOrIndexName_1 wrong # of entries in index sqlite_autoindex_MyTableName_1
There were approximately 140K records per table and 6 tables was this large.Īfter the execution of Integrity Check script, 11 rows was returned after 30 minutes of execution time. The DataBase file is being used on everyday usage for 1.5 year, via the connection journal mode on Memory, and was about 750 MB large. (I don't have any idea if these statistics would help, but I'm going to share them anyway.) In my case, I've executed following check script and the followings via SQLiteStudio 3.1.1. Our project has the dependency and the error message was the same: But the error is definitely a generic one, which led me here, this question page.
Marked answer might be the correct one, according to subversion cleanup.
