Even in my use case I got "Disk I/O error" after I reached 2GB of virtual memory. Max tell us the size of the memory mapped file in VMMap tool when you got "Disk I/O error", and check the value of Virtual Bytes in windows performance counter
Il 10/09/2010 6.54, Max Vlasov ha scritto: >> 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) > ) > > 2. Open the db that should currently be in journal_mode=delete > > 3. Change journal_mode=WAL; > > 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 > > -- Selea s.r.l. Michele Pradella R&D SELEA s.r.l. Via Aldo Moro 69 Italy - 46019 Cicognara (MN) Tel +39 0375 889091 Fax +39 0375 889080 *michele.prade...@selea.com* <mailto:michele.prade...@selea.com> *http://www.selea.com* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
