Exception occurs on autowhitelisting |
Post Reply ![]() |
Author | |
davemeister ![]() Newbie ![]() ![]() Joined: 11 March 2008 Location: Portland, OR Status: Offline Points: 6 |
![]() ![]() ![]() ![]() ![]() 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 ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4104 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.312 seconds.