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.
On Mon, Aug 2, 2010 at 9:25 AM, Yoni Londner <yonih...@gmail.com> wrote: > Hi, > I am getting "database disk image is malformed" error while using WAL. > To reproduce: > 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. while(1) loop - insert records to a table. > 7. after 15 seconds, run a checkpoint on separate thread (using another > sqlite connection with same settings as above). > 8. get the above error AFTER the checkpoint finished. > > Reproduced on both linux (debian lenny) and win XP. > Appreciate any help. > > Yoni. > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
