Hi, Actually it DOES help. I just found out that I ran the wrong executable. Sorry if I wasted your time :-) When will you have an official release of this version? Yoni.
On Mon, Aug 2, 2010 at 3:02 PM, Yoni Londner <yonih...@gmail.com> wrote: > 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