This is most probably a corruption where index have some rowids not present in table. If nothing else is corrupted you can just drop the index and recreate it again.
Pavel On Fri, Oct 15, 2010 at 1:43 PM, Jeff Flanigan <jflani...@zimbra.com> wrote: > Cool, that definitely tells me the db is corrupt. Is there any way to recover > a corrupted db, or is it completely borked? > > ----- Original Message ----- > From: "Simon Slavin" <slav...@bigfraud.org> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Friday, October 15, 2010 1:30:34 PM > Subject: Re: [sqlite] Duplicate results for a given primary key/row > > > On 15 Oct 2010, at 6:11pm, Jeff Flanigan wrote: > >> My initial guess is this is due to some sort of database corruption, > > http://www.sqlite.org/pragma.html#pragma_integrity_check > > Simon. > _______________________________________________ > 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
