Hello Voxen, I'm in the same boat and I have asked them to tweek the AV for performance reason and because it messes up disk writes. I have toyed with the idea of some mild encryption on my blobs to prevent this. Maybe some low key bits AES. An interesting experiment would be to see if the AV programs can read through compression because you could also GZIP of the blobs before insertion and save significant space too.
C Thursday, May 3, 2007, 9:47:44 AM, you wrote: V> The problem is my application is used by thousand of customers. V> I cannot ask them to tweak their antivirus. >> >> Most anti-virus software allows you to specify an exception folder and/or >> file. Tell the anti-virus to ignore sqlite db and the journal. >> >> Sam >> >> ------------------------------------------- >> We're Hiring! Seeking a passionate developer to join our team building >> products. Position is in the Washington D.C. metro area. If interested >> contact [EMAIL PROTECTED] >> -----Original Message----- >> From: Voxen [mailto:[EMAIL PROTECTED] >> Sent: Thursday, May 03, 2007 2:58 AM >> To: sqlite-users@sqlite.org >> Subject: [sqlite] Transaction journal corrupted by antivirus >> >> Hi, >> >> My application is storing email messages in a SQLite database (raw email >> messages as they are downloaded from the mail server). >> This is done under a transaction. >> >> Sometimes I get the SQLITE_MISUSE error and by watching the antivirus >> (Avast) log, I found this: >> Sign of "Uruguay 6/7/8" has been found in "C:\Documents and >> Settings\Voxen\Application Data\MyApp\mail.db-jounal" file. >> >> This means the antivirus found a virus in the transaction journal file >> and >> removes it. Its altering the journal file and then produces a >> SQLITE_MISUSE error. >> >> How can I work around this? >> Do I need to ZIP or encode the email message before storing it in the >> database? >> >> Thanks >> Voxen >> >> >> ---------------------------------------------------------------------------- >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> ---------------------------------------------------------------------------- >> - >> >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- >> >> V> ----------------------------------------------------------------------------- V> To unsubscribe, send email to [EMAIL PROTECTED] V> ----------------------------------------------------------------------------- -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
