Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Forwarding from Quarantine fails
  FAQ FAQ  Forum Search   Register Register  Login Login

Forwarding from Quarantine fails

 Post Reply Post Reply
Author
strider77 View Drop Down
Newbie
Newbie


Joined: 10 January 2007
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote strider77 Quote  Post ReplyReply Direct Link To This Post Topic: Forwarding from Quarantine fails
    Posted: 18 June 2007 at 5:42pm
 
Exception occurred during TDeliverQuarantineThread.Execute: Timeout expired 1 2 3 4 5 6 7 36 37 38
 
Spamfilter 3.5.3.678 Enterprise
SQL Server - the web interface flips the deliver flag 1 successfully, however Spamfilter reports the above error and the email is not succesfully sent. I can confirm that the email is still in the DB. New spam email is succesfully being put into the quarantine DB, but it fails when trying to deliver it.
 
Note, this is a new install of spamfilter but it's using an existing spamfilter SQL DB. The Enterprise upgrade seemed to work fine, the extra tables were created successfully and are being utilized.
 
Any ideas?
Back to Top
corymckee View Drop Down
Newbie
Newbie


Joined: 10 June 2007
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote corymckee Quote  Post ReplyReply Direct Link To This Post Posted: 18 June 2007 at 6:06pm
I am having the same problem. New install and new SQL DB. My users are frantic.
Back to Top
strider77 View Drop Down
Newbie
Newbie


Joined: 10 January 2007
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote strider77 Quote  Post ReplyReply Direct Link To This Post Posted: 18 June 2007 at 6:19pm
I may have solution, I bumped the "MiscSQLTimeout" setting in the spamfilter.ini from 1 to 10, restarted the service and now things appear to be working just fine.
 
 
Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4106
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 18 June 2007 at 6:33pm
The Exception error *may* not be related to the emails not being sent.

SpamFilter checks the quarantine database every 5 seconds to see if there are any emails to be delivered. The query that makes this check has a very "aggressive" short timeout, as we do not want to waste too many resources. If it timeouts once, it will be executed again after 5 seconds, so it's usually not a big deal. Often you'll see dozens of those timeouts thrughout the day. Unless you see hundreds or thousands, it's nothing to worry about.
 
Going back to the original problem about not being able to deliver the emails, to see what is happening we'd need a copy of SpamFilter's activity logfile, possibly trimmed to include a few minutes before and after the time the quarantine emails was being delivered. Please also include the from/to email addresses involved so we may locate them in the logs.

Increasing the "MiscSQLTimeout" setting will indeed increase the timeout for the query that checks the quarantine for any pending emails to be delivered, but again, unless the error appears continuosly, there should not be a need to increase it.
 
Roberto Franceschetti

LogSat Software

Spam Filter ISP
Back to Top
corymckee View Drop Down
Newbie
Newbie


Joined: 10 June 2007
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote corymckee Quote  Post ReplyReply Direct Link To This Post Posted: 18 June 2007 at 7:22pm
Thank you. We changes this setting and messages started to be delivered again.
Back to Top
corymckee View Drop Down
Newbie
Newbie


Joined: 10 June 2007
Status: Offline
Points: 31
Post Options Post Options   Thanks (0) Thanks(0)   Quote corymckee Quote  Post ReplyReply Direct Link To This Post Posted: 19 June 2007 at 3:31pm

We had to up the time again so I think we may need troubleshoot further. I am adding memory to my MSSQL server as it a little low. I will test the quarantine issue once it has been running for a while and I will get a copy of the log and PM it to you.

 

Thank you

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.770 seconds.