What happens if you make it an in-memory database? If that works that will help narrow the problem to the MMC.
And can you run it on your development machine too and see what happens? And I think we asked before but can you make a small sample program that causes this for you? Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________ From: [email protected] [[email protected]] on behalf of [email protected] [[email protected]] Sent: Monday, August 22, 2011 10:17 AM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] Autoincrement failure SELECT rowid FROM (mytable) WHERE (mystuff) returns 37 identical rows(!) where Rowid = 1 Alessandro From: [email protected] To: <[email protected]> Date: 22/08/2011 16.26 Subject: Re: [sqlite] Autoincrement failure sqlite> .dump sqlite_sequence PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; COMMIT; sqlite> Any idea? Thanks Alessandro From: Richard Hipp <[email protected]> To: General Discussion of SQLite Database <[email protected]> Date: 22/08/2011 16.11 Subject: Re: [sqlite] Autoincrement failure On Mon, Aug 22, 2011 at 9:56 AM, <[email protected]> wrote: > Hallo, > > Have you ever seen a SQLite3 DB file with autoincrement algoritm broken? > Every new record seems to be added with rowid=1 overwriting existing > info... > > Any idea about the causes of this issue > and about extracting lost data (if present)? > Please run from the sqlite3.exe shell: .dump sqlite_sequence Tell us what you see. > > Many thanks > Alessandro > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ 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 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
