The second problem is definitely related to the change in the implementation of "pragma journal_mode" though I am not completely sure how. The previous version of our code did
pragma encoding="UTF-8"; pragma auto_vacuum=incremental; pragma journal_mode=truncate; after opening the database file. When I change the code to pragma main.journal_mode=truncate; pragma encoding="UTF-8"; pragma auto_vacuum=incremental; the problem doesn't happen anymore. Even if I use this code sequence SQLite still tries to access the WAL file. F. On Tue, Jul 13, 2010 at 5:23 PM, Filip Navara <filip.nav...@gmail.com> wrote: > Btw, the failing application call is DeleteFileW. > F. > > On Tue, Jul 13, 2010 at 5:02 PM, Filip Navara <filip.nav...@gmail.com> > wrote: >> >> Hi, >> for a few days we have been running our application with SQLite built from >> the 201007091257 snapshot. The application runs on Windows 7 systems that >> are fully updated. We didn't enable the WAL mode and the following two >> problems occurred: >> - Every time a database file is opened SQLite tries to access the WAL file >> even though WAL was never used on the database. >> - Some commands fail intermittently when two connections are opened to the >> same database. An SQLITE_IOERR error is returned. >> Log from Process Monitor are available at >> http://www.emclient.com/temp/logfile-3.6.21.1.txt >> http://www.emclient.com/temp/logfile-3.6.21.1.pml >> http://www.emclient.com/temp/logfile-3.7.txt >> http://www.emclient.com/temp/logfile-3.7.pml >> Apparently the second problem is caused by the following call that wasn't >> present in the 3.6.21.1 logs: >> 16:53:00,5982911 MailClient.exe 2712 CreateFile C:\Users\Filip >> Navara\AppData\Roaming\eM Client\main.dat-journal SHARING VIOLATION Desired >> Access: Read Attributes, Delete, Disposition: Open, Options: Non-Directory >> File, Open Reparse Point, Attributes: n/a, ShareMode: Read, Write, Delete, >> AllocationSize: n/a >> We'd welcome any advice on solving the issue and we will provide any >> additional information requested. >> Best regards, >> Filip Navara > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
