On 27 Nov 2017, at 12:41pm, Jiří Matějka <mate...@emclient.com> wrote:
> We have no busy timeout set because we use System.Data.SQlite library which > has its own waiting mechanism (repeating the sqlite3_reset/sqlite3_step > within 30 secons). I’m hoping that Joe Mistachkin, or someone else who understands that library sees this, just to check that it works the way you’re expecting it to. > b) "database disk image is malformed", which is sometimes really caused by AV > software. Our application is an email client, so the antivirus could > theoretically found a virus signature inside datafile (but why would it just > modify the file instead of moving to the quarantine as whole?). > We also have many reports with "database schema has changed" errors. There are millions of installations on Wintel computers which have AV software installed. We do not have millions of complaints about this problem. This suggests that your setup is unusual. As you write, AV software is expected to handle a SQLite database file as a whole: it could delete it, put protection on it, or move it. Since AV software doesn’t understand the format of SQLite databases it should not be modifying the contents of the file leading to "schema has changed" but not "database corrupt". Can you investigate further ? Or tell us more about what you already know ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
