Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Exception occurs on autowhitelisting
  FAQ FAQ  Forum Search   Register Register  Login Login

Exception occurs on autowhitelisting

 Post Reply Post Reply
Author
davemeister View Drop Down
Newbie
Newbie
Avatar

Joined: 11 March 2008
Location: Portland, OR
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote davemeister Quote  Post ReplyReply Direct Link To This Post 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!
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4065
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.078 seconds.