Yes, that's correct. I also tried using BEGIN EXCLUSIVE instead of BEGIN IMMEDIATE. This results in only one worker process being able to write to the database, while the other worker processes continually get SQLITE_BUSY when trying to write.
David -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov Sent: Thursday, 15 October 2009 9:53 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Exception writing to database from multiple processes > However, when it is run > inside an Application Pool with multiple worker processes, the database > soon becomes locked and cannot be written to by any of the worker > processes. You mean your application hangs? None of workers can write to database and nothing else happens in application? Nobody's reading database at the same time, nobody connecting to database via command line tool, nothing happens at all? Pavel On Thu, Oct 15, 2009 at 2:40 AM, David Carter <david.car...@erdas.com> wrote: > Hello, > > > > I am currently using the SQLite Amalgamation v3.6.19 from > http://www.sqlite.org/download.html in an ISAPI Extension to write out > usage statistics to an SQLite database. > > > > When the ISAPI extension is running inside an Application Pool with a > single worker process, everything works fine. However, when it is run > inside an Application Pool with multiple worker processes, the database > soon becomes locked and cannot be written to by any of the worker > processes. > > > > Each worker process has a separate background thread which writes to the > database every 5 seconds. Each write is performed as a single > transaction starting with "BEGIN IMMEDIATE". > > > > Any help you can provide would be greatly appreciated. > > > > Thanks, > > > > David > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users