Re: [sqlite] disk IO error after windows resumes from sleep

or Scientist Advanced Analytics Directorate Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org on behalf of Serena Lien Sent: Tue 10/5/2010 7:25 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] disk IO error aft

Re: [sqlite] disk IO error after windows resumes from sleep

On 5 Oct 2010, at 1:11pm, Serena Lien wrote: > Yes - that is indeed what I am doing (your 3rd scenario) - but I have tried > to close the connection first (and ignore any errors closing it) before > retrying to open. As you say, the database object I am trying to close may > not be valid so I am

Re: [sqlite] disk IO error after windows resumes from sleep

__ > > From: sqlite-users-boun...@sqlite.org on behalf of Drake Wilson > Sent: Tue 10/5/2010 5:59 AM > To: General Discussion of SQLite Database > Subject: EXTERNAL:Re: [sqlite] disk IO error after windows resumes from > sleep > > > > Quoth Seren

Re: [sqlite] disk IO error after windows resumes from sleep

Drake Wilson Sent: Tue 10/5/2010 5:59 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] disk IO error after windows resumes from sleep Quoth Serena Lien <serenal...@gmail.com>, on 2010-10-05 11:46:18 +0100: > On a windows vista/win7 machine or a laptop which goes

Re: [sqlite] disk IO error after windows resumes from sleep

Yes - that is indeed what I am doing (your 3rd scenario) - but I have tried to close the connection first (and ignore any errors closing it) before retrying to open. As you say, the database object I am trying to close may not be valid so I am not able to close it first, and therefore unable to

Re: [sqlite] disk IO error after windows resumes from sleep

On 5 Oct 2010, at 11:46am, Serena Lien wrote: > On a windows vista/win7 machine or a laptop which goes into sleep mode, when > it resumes and the application tries to open a database on a networked > drive, the open function returns SQLITE_CANTOPEN and SQLITE_IOERR. I don't > have a problem with

Re: [sqlite] disk IO error after windows resumes from sleep

In response to your question - by "always continues to fail" I mean that yes, after delaying and retrying, even when the file should be accessible, I still get SQLITE_IOERR returned from sqlite3_open_v2. If my application exits and restarts, it will try to call sqlite3_open_v2 again on the same

Re: [sqlite] disk IO error after windows resumes from sleep

Quoth Serena Lien , on 2010-10-05 11:46:18 +0100: > On a windows vista/win7 machine or a laptop which goes into sleep mode, when > it resumes and the application tries to open a database on a networked > drive, the open function returns SQLITE_CANTOPEN and SQLITE_IOERR. I

[sqlite] disk IO error after windows resumes from sleep

I have a question about recovering from SQLITE_IOERR? We are using sqlite v3.6.15 on windows where the databases may be accessed across a network (I am aware of the caveats here). On a windows vista/win7 machine or a laptop which goes into sleep mode, when it resumes and the application tries to