Thanks Jay, that clears things up for me. On 20/06/2011 14:17, Jay A. Kreibich wrote: > On Mon, Jun 20, 2011 at 02:04:36PM +0100, Ian Hardingham scratched on the > wall: >> Hey guys. >> >> We revisit my situation - I'm accessing the same database with 4 >> processes and they are using busy-waiting to access the db somewhat >> concurrently. >> >> I'm expecting SQLITE_LOCKED and SQLITE_BUSY, but I also get >> SQLITE_CANTOPEN - this is on an *already open* database and a query >> shortly later works fine. >> >> Can anyone explain when this error happens? > It is likely related to the journal file. > > If you're not using WAL, you might try changing the journal mode to > "truncate." > > http://www.sqlite.org/pragma.html#pragma_journal_mode > > -j >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users