Spam Filter ISP Forums : Quarantine Release Question https://www.logsat.com/spamfilter/forums/ Mon, 20 Apr 2026 11:43:21 +0000 Thu, 08 Sep 2011 11:17:50 +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=6977 <![CDATA[Spam Filter ISP Forums]]> https://www.logsat.com/spamfilter/forums/forum_images/web_wiz_forums.png https://www.logsat.com/spamfilter/forums/ <![CDATA[Quarantine Release Question : LogSat wrote:Are you certain...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14212&title=quarantine-release-question#14212 Author: dotme
Subject: 6977
Posted: 08 September 2011 at 11:17am

Originally posted by LogSat LogSat wrote:

Are you certain you do not have some customized cleanup routines configured in SQL Server (or in an external application) that may be modifying the SpamFilter database directly, bypassing SpamFilter?
Guilty as charged... thanks for pointing me in the right direction. I found the problem in one of my overnight routines. Thanks again!!
]]> Thu, 08 Sep 2011 11:17:50 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14212&title=quarantine-release-question#14212 <![CDATA[Quarantine Release Question : No - that is not normal. For every...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14211&title=quarantine-release-question#14211 Author: LogSat
Subject: 6977
Posted: 07 September 2011 at 5:59pm

No - that is not normal. For every spam email that is quarantined, a record is added to the tblQuarantine table for each recipient of that email. The tblQuarantine holds simple header data relative to the email (ex. subject, to/from, etc). The actual content of the email is added to the tblMsgs. Only one record with the content is added in order to save space (since it's the same content for all recipients).

In your case, 3 records would thus be added to the tblQuarantine table, and just one record with the body of the email is added to the table tblMsgs. Each of the 3 records in the tblQuarantine then points to the same record in the tblMsgs table for the content. When a user release the email from the quarantine, after the delivery, their record in the tblQuarantine is marked for deletion. When SpamFilter performs its cleanup routines (by default every hour), it will delete that one record from the tblQuarantine. The remaining 2 records for the other users in the tblQuarantine, along with the email body in the tblMsgs, are not touched and should thus remain available for the other users to see (and deliver).

Are you certain you do not have some customized cleanup routines configured in SQL Server (or in an external application) that may be modifying the SpamFilter database directly, bypassing SpamFilter?
]]> Wed, 07 Sep 2011 17:59:08 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14211&title=quarantine-release-question#14211 <![CDATA[Quarantine Release Question : Maybe I coded something wrong?...]]> https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14210&title=quarantine-release-question#14210 Author: dotme
Subject: 6977
Posted: 07 September 2011 at 10:03am

Maybe I coded something wrong?
 
1) Email sent to 3 users on same domain gets quarantined.
2) User 1 releases email and receives it
3) Users 2 and 3 can't release the message any more, because it's already been delivered to User 1.
 
Is that normal? Are there three copies quarantined when an email comes in for three people at example.com, or only one? Hints and tips appreciated...


Edited by dotme - 07 September 2011 at 10:03am]]> Wed, 07 Sep 2011 10:03:24 +0000 https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6977&PID=14210&title=quarantine-release-question#14210