On Aug 2, 2010, at 1:42 PM, Yoni Londner wrote: > Hi, > Forgot to mention that the inserting should be inside a > transactions, so > complete repro steps are: > 1. open sqlite connection. > 2. PRAGMA journal_mode=WAL > 3. PRAGMA synchronous=full > 4. PRAGMA temp_store=memory > 5. sqlite3_enable_shared_cache(1) > 6. begin transaction > 7. while(1) loop - insert records to a table. > 8. after 15 seconds, run a checkpoint on separate thread (using > another > sqlite connection with same settings as above). > 9. get the above error AFTER the checkpoint finished.
Thanks for this report. If possible, can you try your test with the latest from fossil (newer than e75b52d156)? Thanks. http://www.sqlite.org/src/zip/SQLite-016486c7d544dcf9.zip?uuid=016486c7d544dcf9b7422cb0fb9804aa1c418f68 Please post if you need an amalgamation instead of the source package. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
