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

Reply via email to