Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows
Hmm, it didn't help. I can still easily reproduce the TortoiseSVN bug. The only reliable workaround is to use different journal_mode (or implementing renaming of the journal file before deleting it). Best regards, F. On Wed, Oct 15, 2008 at 2:33 PM, Shane Harrelson <[EMAIL PROTECTED]> wrote: > Version 3.6.1 (IIRC) had changes to improve the error detection and retry > logic for this condition (typically caused when a 3rd party application > opens the SQLite journal file.) > HTH. > -Shane > > > On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: > >> I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN >> when doing an insert. When that fails, I can use the debugger to go back >> up >> and step through the same lines again (using the same database handle - >> nothing opened or closed in between) and it will work. >> >> I am using sqlite3_bind_blob with the following: INSERT OR REPLACE INTO >> BlobTable (BlobKey, BlobVal) Values ('exampleKey', ?) >> in case that makes any difference (the SQLITE_CANTOPEN code is returned >> from >> sqlite3_step). >> >> I doubt this has anything to do with SQLite as it's been working perfectly >> for years, but I also can't figure out what has changed on my system such >> that this would be happening now. >> >> Thanks in advance for any ideas. >> >> Doug >> >> >> >> ___ >> 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
Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows
Version 3.6.1 (IIRC) had changes to improve the error detection and retry logic for this condition (typically caused when a 3rd party application opens the SQLite journal file.) HTH. -Shane On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back > up > and step through the same lines again (using the same database handle - > nothing opened or closed in between) and it will work. > > I am using sqlite3_bind_blob with the following: INSERT OR REPLACE INTO > BlobTable (BlobKey, BlobVal) Values ('exampleKey', ?) > in case that makes any difference (the SQLITE_CANTOPEN code is returned > from > sqlite3_step). > > I doubt this has anything to do with SQLite as it's been working perfectly > for years, but I also can't figure out what has changed on my system such > that this would be happening now. > > Thanks in advance for any ideas. > > Doug > > > > ___ > 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
Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows
http://www.mail-archive.com/sqlite-users@sqlite.org/msg34453.html On Mon, Oct 13, 2008 at 6:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back up > and step through the same lines again (using the same database handle - > nothing opened or closed in between) and it will work. > > I am using sqlite3_bind_blob with the following: INSERT OR REPLACE INTO > BlobTable (BlobKey, BlobVal) Values ('exampleKey', ?) > in case that makes any difference (the SQLITE_CANTOPEN code is returned from > sqlite3_step). > > I doubt this has anything to do with SQLite as it's been working perfectly > for years, but I also can't figure out what has changed on my system such > that this would be happening now. > > Thanks in advance for any ideas. > > Doug > > > > ___ > 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
Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows
Stephen Oberholtzer wrote: On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN when doing an insert. When that fails, I can use the debugger to go back up and step through the same lines again (using the same database handle - nothing opened or closed in between) and it will work. We see this a lot when people have an antivirus that autoscans files after they've been modified. Is that possibly the case? System Restore also tends to interfere a lot when one chooses filenames with extensions that are monitored by that service (especially .sdb which is very tempting when using SQLite, but is the extension used by the shim engine.) Here is a list of extensions to avoid: http://msdn.microsoft.com/en-us/library/aa378870.aspx. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Intermittent SQLITE_CANTOPEN on Windows
On Mon, Oct 13, 2008 at 12:52 PM, Doug <[EMAIL PROTECTED]> wrote: > I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN > when doing an insert. When that fails, I can use the debugger to go back > up > and step through the same lines again (using the same database handle - > nothing opened or closed in between) and it will work. > We see this a lot when people have an antivirus that autoscans files after they've been modified. Is that possibly the case? -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Intermittent SQLITE_CANTOPEN on Windows
I'm using SQLite 3.5.6 on Windows and intermittently get SQLITE_CANTOPEN when doing an insert. When that fails, I can use the debugger to go back up and step through the same lines again (using the same database handle - nothing opened or closed in between) and it will work. I am using sqlite3_bind_blob with the following: INSERT OR REPLACE INTO BlobTable (BlobKey, BlobVal) Values ('exampleKey', ?) in case that makes any difference (the SQLITE_CANTOPEN code is returned from sqlite3_step). I doubt this has anything to do with SQLite as it's been working perfectly for years, but I also can't figure out what has changed on my system such that this would be happening now. Thanks in advance for any ideas. Doug ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users