Spam Filter ISP Forums : ) Error occurred during TAddToQuarantineThread https://www.logsat.com/spamfilter/forums/ Mon, 15 Jun 2026 01:19:57 +0000 Thu, 24 Apr 2014 22:58:27 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 11.04 360 https://www.logsat.com/spamfilter/forums/RSS_post_feed.asp?TID=7081 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[) Error occurred during TAddToQuarantineThread : The maximum file size for Access...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7081&PID=14591&title=error-occurred-during-taddtoquarantinethread#14591 Author: LogSat
Subject: 7081
Posted: 24 April 2014 at 10:58pm

The maximum file size for Access databases is 2GB, which roughly on average would hold only between 50,000 and 200,000 spam emails. Some deployments of SpamFilter archive that amount of emails in just an hour or two.

While SpamFilter supports Microsoft Access for a backend, that database platform is not suited for high performance applications that cause a large amount of data/concurrent connections. It's mainly used to help evaluate SpamFilter with very low email traffic. For live environments we strongly recommend the use of either Microsoft SQL Server or MySQL, which allow for much greater scalability.

If you need to continue using Access as a platform, you would need to ensure that the .mdb file is not reaching the 1GB limit by reducing the number of days SpamFilter retains the quarantined emails, so as to have a much smaller number of spam emails stored in the database.
]]> Thu, 24 Apr 2014 22:58:27 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7081&PID=14591&title=error-occurred-during-taddtoquarantinethread#14591 <![CDATA[) Error occurred during TAddToQuarantineThread : We ran into this problem with...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7081&PID=14590&title=error-occurred-during-taddtoquarantinethread#14590 Author: JeffHildebrand
Subject: 7081
Posted: 24 April 2014 at 11:15am

We ran into this problem with 4.5.1.98, It looks like we started getting quarantine errors last week.

04/17/14 05:00:46:548 -- (133483376) Adding to Quarantine file:Qrtn390F4869-916D-492E-9397-CFBE863B283B.tmp
04/17/14 05:00:46:558 -- (133483376) Error occurred during TAddToQuarantineThread when accessing the quarantine database: Operation must use an updateable query ( 1 83 84 85 86 86a 86b 86c 87)

... continuing until today...
04/23/14 09:45:01:998 -- (17979792) Adding to Quarantine file:QrtnE86EC5D6-6241-435D-8EB2-6BE804F49F14.tmp.queued
04/23/14 09:45:01:998 -- (17979792) Error occurred during TAddToQuarantineThread when accessing the quarantine database: Invalid argument ( 1 3a 83 84 85 86 86a 86b 86c 87 88 89 90 91)

...
this morning the rate was about 150 errors per second, generating log files between 300MB-500MB per day.
The spamfilter.mdb was up to 2GB's on an NTFS volume with over a TB of free space. I tried to compress the mdb, but that only reduced the size by about 12MB. I ended up replacing the mdb with a clean copy, and after catching up from the last week grew to 600MB.

I didn't try the compacted mdb since there was not much of a difference in file size, but I would think you should look at adding some type of limiter to the number of attempts to quarantine an item.



]]> Thu, 24 Apr 2014 11:15:20 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=7081&PID=14590&title=error-occurred-during-taddtoquarantinethread#14590