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 <[email protected]> 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" <[email protected]> > To: "General Discussion of SQLite Database" <[email protected]> > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
