On 11/24/17 12:20 PM, Nelson, Erik - 2 wrote:
Jirí Matejka Sent on Friday, November 24, 2017 3:45 AM
but this does not prevent reading and modifying the file from other
processes while they are open by SQLite in our process.
Does antivirus or Windows randomly modify other applications' files? It seems
like no program could reliably execute under such circumstances.
An antivirus program is unlikely to actually modify the files (unless it
thinks it is virus infected and is quarantining the file). What can
happen is the file gets a read lock on it and the application attempts
to get a write lock, and THAT is refused due to the read locks by the
scanner/indexer/backup program.
A basic rule is that even if you don't think anyone else might be
accessing a file, you need to allow for a temporary failure to lock a
file for writting, and retry several times with a timeout.
--
Richard Damon
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users