> 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
