Dont' know if this is related but are you keeping the database open all the time or closing and reopening?
If reopening does this only occur after opening again? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: [email protected] [[email protected]] on behalf of [email protected] [[email protected]] Sent: Tuesday, August 23, 2011 10:28 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Autoincrement failure Sorry, I cannot run a shell sqlite3 on my embedded system. I will explain it using your example. It happen that sometime autoincrement begin to fail and new records overwrite the one at rowid =1 1|1|2|3|one|two|three replaced by 1|4|2|3|one|two|three 2|2|2|3|one|two|three 3|3|2|3|one|two|three if I add another record >insert into journal values(5,2,3,'one','two','three'); it overwrite last one as follow 1|4|2|3|one|two|three replaced by 1|5|2|3|one|two|three 2|2|2|3|one|two|three 3|3|2|3|one|two|three and by "select rowid, * from journal where rowid = 1" returns three times the same values with rowid = 1 1|5|2|3|one|two|three 1|5|2|3|one|two|three 1|5|2|3|one|two|three It appear that SQLite "keep in mind" the number of operations but the index for extracting info does not work fine. Thanks for any comment Alessandro _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
