Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Shane Harrelson
[EMAIL PROTECTED] On Behalf Of Shane Harrelson > Sent: Wednesday, July 30, 2008 8:38 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] winDelete retry-on-failure functionality isn't > working > > GetFileAttributes() returns INVALID_FILE_ATTRIBUTES with an error o

Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Jeremy Spiegel
Shane, Just saw the checkin for the fix. Thanks! :) Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shane Harrelson Sent: Wednesday, July 30, 2008 8:38 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] winDelete retry-on-failure

Re: [sqlite] winDelete retry-on-failure functionality isn't working

2008-07-30 Thread Shane Harrelson
GetFileAttributes() returns INVALID_FILE_ATTRIBUTES with an error of ERROR_ACCESS_DENIED if the file is in a "pending delete" state. I'll update the retry logic in os_win.c in winDelete() to add this additional check. I believe that should improve the situation (as long as the other application

[sqlite] winDelete retry-on-failure functionality isn't working

2008-07-29 Thread Jeremy Spiegel
Hi, winDelete in os_win.c has retry functionality to try multiple times to delete a file if a virus scanner or indexing program has a handle open on that file. We've seen SQLite failures that have been tracked down to other apps temporarily opening our db journal files, so we believe that the ret