LogSat Software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   today i've noticed a major issue with my spamfilter 4.0.1.785. I am getting exceptions and a lot of them. They are occuring when a user forces delivery of a message from quaratine or if I try to force delivery from the quarantine (actually, the latter makes spamfilter fail and closes). Here is an excerp from my log:

08/27/08 16:42:53:156 -- (188) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:53:171 -- (188) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
08/27/08 16:42:54:156 -- (1504) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:54:171 -- (1504) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
08/27/08 16:42:55:171 -- (3284) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:55:187 -- (3284) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
08/27/08 16:42:56:156 -- (4036) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:56:171 -- (4036) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
08/27/08 16:42:57:156 -- (1744) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:57:171 -- (1744) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38
08/27/08 16:42:58:156 -- (3748) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk|admin@k-com.net
08/27/08 16:42:58:171 -- (3748) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38

I have no idea what can be causing this. I've viewed a few posts with similar results but this is not temorary. Once I manually remove the marked message from quarantine, the problem stops until yet another message is marked for delivery. It appears to be taking up a lot or resources as well. I even removed all items from quarantine to see if that fixes it and it doesn't.

Any help would be much appreciated.

-Dave

p.s. tried to email the logfiles to support@logsat.com but messages came back as undeliverable. Perhaps they fell victim to greylisting, but my server retries every minute for 15 minutes and they still were returned. So if you need a copy of the logfile, please provide me with the FTP address and login to do so. thx.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
davemeister Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11 March 2008 Location: Portland, OR Status: Offline Points: 6	Post Options Post Reply Quote davemeister Report Post Thanks(0) Quote Reply Topic: Exception occurs on autowhitelisting Posted: 27 August 2008 at 9:53pm
	today i've noticed a major issue with my spamfilter 4.0.1.785. I am getting exceptions and a lot of them. They are occuring when a user forces delivery of a message from quaratine or if I try to force delivery from the quarantine (actually, the latter makes spamfilter fail and closes). Here is an excerp from my log: 08/27/08 16:42:53:156 -- (188) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:53:171 -- (188) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 08/27/08 16:42:54:156 -- (1504) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:54:171 -- (1504) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 08/27/08 16:42:55:171 -- (3284) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:55:187 -- (3284) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 08/27/08 16:42:56:156 -- (4036) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:56:171 -- (4036) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 08/27/08 16:42:57:156 -- (1744) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:57:171 -- (1744) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 08/27/08 16:42:58:156 -- (3748) Adding to C:\Program Files\SpamFilter\AutoWhiteListForceDelivery.txt:3llb@centa-uk.co.uk\|admin@k-com.net 08/27/08 16:42:58:171 -- (3748) Exception occurred during TDeliverQuarantineThread.Execute: Insufficient key column information for updating or refreshing 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 36 37 38 I have no idea what can be causing this. I've viewed a few posts with similar results but this is not temorary. Once I manually remove the marked message from quarantine, the problem stops until yet another message is marked for delivery. It appears to be taking up a lot or resources as well. I even removed all items from quarantine to see if that fixes it and it doesn't. Any help would be much appreciated. -Dave p.s. tried to email the logfiles to support@logsat.com but messages came back as undeliverable. Perhaps they fell victim to greylisting, but my server retries every minute for 15 minutes and they still were returned. So if you need a copy of the logfile, please provide me with the FTP address and login to do so. thx.
	Davemeister -Death to Spammers!

LogSat Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104	Post Options Post Reply Quote LogSat Report Post Thanks(0) Quote Reply Posted: 30 August 2008 at 11:20am
	davemeister, I'm very sorry, we just saw this posting. Not only we did not receive your direct email to support@logsat.com, but we did not even receive the email notifications that notify us of new forum posts relative to this specific posting. Very, very unusual coincidence. I'll be sending you a PM shortly with the FTP details. Please zip us the logs for the entire day when this first happened, and also the previous day as well in case there were errors lingering earlier that lead to other issues later. If you can please both send us an email and a PM us back when you uploaded the files, we'll be certain to receive your response.
	Roberto Franceschetti LogSat Software Spam Filter ISP

LogSat Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 25 January 2005 Location: United States Status: Offline Points: 4104	Post Options Post Reply Quote LogSat Report Post Thanks(0) Quote Reply Posted: 30 August 2008 at 7:12pm
	The issue was caused by the tables tblQuarantine and tblMsgs both missing their primary keys on the QuarID and the MsgID columns. Recreating the keys solved the problem. The database is on the MS Access platform, and it's possible that the primary keys were removed when a "Compact & Repair" procedure was performed on the database.
	Roberto Franceschetti LogSat Software Spam Filter ISP

LogSat Software

Site Navigation[Skip]

Spam Filter ISP Support Forum

Exception occurs on autowhitelisting