Due to attach limits this is the part 002 of the file! ----- "Israel Lins Albuquerque" <israel...@polibrasnet.com.br> escreveu: > Attached has a database corrupted. > We use the version 3.6.23.1 in wince. > > the command: > pragma integrity_check; > > show many errors and > > Duplicate pk was founded using: > SELECT u_pkey, count(*) > FROM tp_gpsdata > GROUP BY u_pkey > HAVING count(*) > 1 > ; > > this returns only 1 record > SELECT * > FROM tp_gpsdata > WHERE u_pkey IN (4684, 4879) > ORDER BY u_pkey > DESC LIMIT 10; > > deletes one record only > DELETE FROM tp_gpsdata WHERE u_pkey IN (4684, 4879); > > vacuum; > doesn't works because of pk constraints. > > > > > > I'm seeding because that can be a bug in OS or in sqlite and maybe someone > can see that, > Thanks for your time! > > -- > Atenciosamente/Regards, > > Israel Lins Albuquerque > Desenvolvimento/Development > Polibrás Brasil Software Ltda. > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
-- -- Atenciosamente/Regards, Israel Lins Albuquerque Desenvolvimento/Development Polibrás Brasil Software Ltda.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users