Hi Dan, Thanks for the response. I tried to new version, but the problem still exist. I continued to debug it, and found that the error detected in btreeInitPage (on decodeFlags). I also found that if i run without enabling shared cache, the problem does not happen. Hope that it will help. Yoni.
On Mon, Aug 2, 2010 at 2:33 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > > On Aug 2, 2010, at 6:13 PM, Dan Kennedy wrote: > > > > > 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. > > Easier: Grab it from here: > > http://www.sqlite.org/draft/download.html > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users