I tried to reproduce this, and could not. There are some questions inline below. Additionally, I want to verify that you've tried this with a version of SQLite containing the previously linked fix.
-Shane On Fri, Sep 10, 2010 at 12:54 AM, Max Vlasov <max.vla...@gmail.com> wrote: >> But as a side effect I got not expected result in other area, when I tried >> to append 1,500,000 records to this 1.7G file having 5G of free space on the >> disk, I got the error a user reported recently about win7 64bit, "Disk I/O >> error". (http://www.mail-archive.com/sqlite-users@sqlite.org/msg54935.html, >> but this seems was not related to WAL) >> >> > > Now I the problem is fully reproducible. A modified versions of the steps: > > Windows 7 64bit Home Premium, sqlite 3.7.2 in dll > > 1. Create db with the table > CREATE TABLE [TestTable] ( > [Id] INTEGER PRIMARY KEY AUTOINCREMENT, > [Text] VARCHAR(200) > ) > Which version of SQLite are you using? What compilation options? Do you have syncs disabled? > 2. Open the db that should currently be in journal_mode=delete > Does the DB contain anything at this point? Or just the empty table? What page size are you using? > 3. Change journal_mode=WAL; What are you using for the wal_autocheckpoint setting? > > 4. BEGIN TRANSACTION > > 4. Make 1,300,000 repeated queries > INSERT INTO TestTable (Text) VALUES ("12345678912345.... (the exact length > of the string = 1152) > > 5. While the queries are executed, when the shm file grows to 11M > (0xAC0000), the failure occurs with Disk I/O error (both result and extended > are 10 (SQLITE_IOERR)). > > There's a change that there's something wrong with my program, can someone > do a similar test on another Windows 64bit system? > > Thanks > > Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
