Hello All, I have been in the process of getting SQLite 3.7.7.1 working on our ARM based platform and using WAL on some of our database files. Yesterday, I kept getting:
Error = 11 : database disk image is malformed We have seen this issue before, but not quite like this. We were manually deleting the -wal file which caused many problems as you can imagine. After we fixed that, I haven't seen any other instances of this problem until yesterday. I ran "pragma integrity_check;", here are the results. sqlite> pragma integrity_check; rowid 16571 missing from index SortTime sqlite> I performed a dump on the bad database and created a new one and the data is ok and I no longer get the Error 11, however I am trying to figure out the cause to see if there is reason for concern. I accidentally deleted the bad database so I am in the process of recreating the issue if I can? Questions that I have: What would cause rows to disappear from an index? The row that it's talking about (16571) is a row that has been in the database for some time and wasn't recently added. There are also rows newer and older then it. Could this have anything to do with WAL mode? Is there anyway to track how this occurs? Tests that I can perform? Any assistance in this matter would be appreciated, Korey _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
