I have a 1GB database configured to use WAL mode. It's accessed by short lived CGI processes, under windows 2008 server. Each process usually opens the database, execute a select or update/insert, close the connection and finishes. It uses c api (sqlite3_open, sqlite3_prepare, sqlite3_step) of dll downloaded from sqlite.org.
All operations are working fine (reading, writing to the database). Those processes are started ~1 to 5 per second There's a ~5MB wal and shm file that are being updated frequently When i open the same database with sqlite3.exe (or an external tool like Sqlite Expert) i can do read commands (select), but when i try to write to database (UPDATE / ALTER TABLE) it gives a "Attempt to write a read only database" error. The tools are executed in the same machine as the datafile If i try to open a (smaller, less accessed) database in the same folder as the main one all writing operations are allowed in the external tools Any hints on what's going on? Luiz _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
