Thanks for respond my email. Yes, There is index defined on peerid. Second query used the index which is defined by peerid. How to fix this corruped database. Thanks, JP
________________________________ From: "Griggs, Donald" <donald.gri...@allscripts.com> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Monday, May 4, 2009 4:26:58 PM Subject: Re: [sqlite] SQL error: database disk image is malformed -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joanne Pham Sent: Monday, May 04, 2009 2:51 PM To: General Discussion of SQLite Database Subject: [sqlite] SQL error: database disk image is malformed Hi All, I ran the following sql statement: select blobid, fbid from sig group by peerid; return about 10 rows 222222 ................... 333333 return about 10 rows and I got the error message: SQL error: database disk image is malformed but when I ran the following sql statement: select blobid, fbid from sig; I didn't see any error message. So why the first sql statement has problem but not the second. Thanks JP ================== ================== Joanne, I couldn't say, but if I were you I'd probably -- Hold tight to my backups of my data. -- Run "PRAGMA integrity_check;" as soon as possible. -- See if the problem can be reproduced using the command-line utility. -- Is there an index defined on peerid? Does "Explain query plan" show that it is used by the first query. If so, perhaps the peerid index contains some corruption? -- Does adding "peerid" to your second select run without error? Regards, Donald _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
