Print Page | Close Window

TAddToQuarantine Printed From: LogSat Software Category: Spam Filter ISP Forum Name: Spam Filter ISP Support Forum Description: General support for Spam Filter ISP URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=5737 Printed Date: 30 November 2025 at 1:22pm Topic: TAddToQuarantine Posted By: MatWEB Subject: TAddToQuarantine Date Posted: 24 July 2006 at 3:55pm Hello everyone, I need assistance. Recently, I have the following error     Error occurred during TAddToQuarantineThread when accessing the quarantine database: Nonvalid argument ( 83 84 85 86 86a 86b 86c 87 88 89 90 91) What can I do to correct the error ??? Replies: Posted By: sgeorge Date Posted: 24 July 2006 at 4:33pm Hi there.  I can't help, but just to save you some time... I think that they'll probably want to know what version of SpamFilter you are running. Stephen Posted By: LogSat Date Posted: 24 July 2006 at 10:20pm MatWEB, As sgeorge hinted, can you please let us know what version of SpamFilter you're using, and also what database (MySQL, MS SQL, Access, Oracle) and its version, you're using? ------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP Posted By: MatWEB Date Posted: 25 July 2006 at 8:01am We are using spamfilter 3.0.2.578 and our database is in Access (2000). But, I think i have found that the database is full. We have reach the 2GB limit. How can clean up the database to lower the size of this one ??? Posted By: sgeorge Date Posted: 25 July 2006 at 2:07pm Now that I may be able to help you with...  http://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=4352 - This post may be handy... I asked Roberto that very question regarding MS Access. Some other handy notes: Access databases are not automatically cleaned-up/shrunk.  If your database reaches 2 GB and you delete 500 messages, it will stay at 2 GB.  Now, future inserts will take advantage of that unused space in the file, but in order to manually shrink the database... Make a copy of your database (let's refer to the copy as "db2") Cleanup db2. In MS Access 2000, the option to manually "shrink" unused database space is under Tools->Database Utilities->Compact and Repair Database... Swap db1 with db2: a.) check your live quarantine in SpamFilter to make sure that no new good messages have come into db1 (because your about to replace it) b.) shut down SpamFilter c.) replace db1 with db2 d.) start SpamFilter Revise your quarantine limits! -You will definitely want to change SpamFilter's quarantine limits to try to prevent this from recurring (Settings->Quarantine DB) -If your db filled up because your getting slammed by large attachments that frequently come in, you may want to emply use of the ":null" tag in your blacklists to prevent certain messages from being stored in the quarantine. Judging by the crazy # of steps involved in clean-up, using SQL over this MS Access is ideal.  I use MS Access as well - I prefer to dedicate my SQL Server solely to serving the databases that it already has. Btw, I have Access queries that I use to identify large spam messages (as well as likely false positives).  If you would like 'em, just let me know. Good luck! Stephen

Print Page | Close Window