I tried to reproduce the issue with the latest version, as well as with the referenced snapshot, and could not. I ran two instances of the sqlite CLI as you indicated without issue.
C:\work\sqlite\win32\Debug>sqlite_snapshot test.db SQLite version 3.7.0 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> pragma encoding="UTF-8"; sqlite> pragma auto_vacuum=incremental; sqlite> pragma journal_mode=truncate; truncate sqlite> select sqlite_version(); 3.7.0 sqlite> select sqlite_source_id(); 2010-07-09 12:57:54 0c32c4bbdd74297767dcf4ec4295f9cc72875af0 sqlite> PRAGMA compile_options; DEBUG OMIT_LOAD_EXTENSION TEMP_STORE=1 TEST THREADSAFE=1 sqlite> I included the output of version, source_id, and compile_options for reference. What options are you compiling with? Is there perhaps a journal file somewhere that you're unaware of? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users