Re: [sqlite] Question on errors - IOERR and CANTOPEN

2009-05-26 Thread Dennis Volodomanov
Hi Filip, > what SQLite version and on what platform are you using? There was a > bug in SQLite 3.6.13 on Windows where SQLITE_CANTOPEN was incorrectly > returned during journal check when race condition between two threads > was hit. Also there could be some other software interfering with the >

Re: [sqlite] Question on errors - IOERR and CANTOPEN

2009-05-26 Thread Filip Navara
Hi Dennis, what SQLite version and on what platform are you using? There was a bug in SQLite 3.6.13 on Windows where SQLITE_CANTOPEN was incorrectly returned during journal check when race condition between two threads was hit. Also there could be some other software interfering with the journal d

[sqlite] Question on errors - IOERR and CANTOPEN

2009-05-25 Thread Dennis Volodomanov
I sometimes get either a SQLITE_IOERR or a SQLITE_CANTOPEN when issuing BEGIN IMMEDIATE TRANSACTION or END TRANSACTION, however the database file is there and is being used by another thread. I thought I'd get the usual SQLITE_BUSY or SQLITE_LOCKED, but sometimes these file-related errors come up.