SA TIMED OUT message debian sarge (new error)

[Simon <gr...@gmail.com>]

Hi There,

Looks like ive solved one issue, and another crops up!... I think that
i may need to move to a mysql storage engine here? approx 17,000
messages a day incoming on this server.

Any pointers here? - Thanks!!

Nov  4 11:39:40 mx1 amavis[32148]: (32148-07) SA TIMED OUT, backtrace:
at /usr/share/perl5/Mail/SpamAssassin/DBBasedAddrList.pm line
171\n\teval {...} called at /usr/share/perl5/Ma
il/SpamAssassin/DBBasedAddrList.pm line
171\n\tMail::SpamAssassin::DBBasedAddrList::remove_entry('Mail::SpamAssassin::DBBasedAddrList=HASH(0xa881df0)',
'HASH(0xa6bc474)') called at
 /usr/share/perl5/Mail/SpamAssassin/AutoWhitelist.pm line
134\n\tMail::SpamAssassin::AutoWhitelist::check_address('Mail::SpamAssassin::AutoWhitelist=HASH(0xa87eba8)',
'hugh@imagine
adv.com', 82.227.79.148) called at
/usr/share/perl5/Mail/SpamAssassin/Plugin/AWL.pm line 355\n\teval
{...} called at /usr/share/perl5/Mail/SpamAssassin/Plugin/AWL.pm line
351\n\tMa
il::SpamAssassin::Plugin::AWL::check_from_in_auto_whitelist('Mail::SpamAssassin::Plugin::AWL=HASH(0xa09da08)',
'Mail::SpamAssassin::PerMsgStatus=HASH(0xa67060c)') called at (eval 2
80) line 7\n\tMail::SpamAssassin::PerMsgStatus::check_f...

Re: SA TIMED OUT message debian sarge (new error)

[Mark Martinec <Ma...@ijs.si>]

Simon,

> Looks like ive solved one issue, and another crops up!... I think that
> i may need to move to a mysql storage engine here? approx 17,000
> messages a day incoming on this server.
> Any pointers here? - Thanks!!
>
> Nov  4 11:39:40 mx1 amavis[32148]: (32148-07) SA TIMED OUT, backtrace:
> at /usr/share/perl5/Mail/SpamAssassin/DBBasedAddrList.pm line 171
> ... /usr/share/perl5/Mail/SpamAssassin/AutoWhitelist.pm line 134
> ... /usr/share/perl5/Mail/SpamAssassin/Plugin/AWL.pm line 355

Move AWL to SQL, if you haven't already. It is not too bad to start
from scratch with an empty AWL database, it is probably not worth
salvaging your existing AWL.

  Mark

RE: SA TIMED OUT message debian sarge (new error)

[Gary V <mr...@hotmail.com>]

>Hi There,
>
>Looks like ive solved one issue, and another crops up!... I think that
>i may need to move to a mysql storage engine here? approx 17,000
>messages a day incoming on this server.
>
>Any pointers here? - Thanks!!
>
>Nov  4 11:39:40 mx1 amavis[32148]: (32148-07) SA TIMED OUT, backtrace:
>at /usr/share/perl5/Mail/SpamAssassin/DBBasedAddrList.pm line
>171\n\teval {...} called at /usr/share/perl5/Ma
>il/SpamAssassin/DBBasedAddrList.pm line
>171\n\tMail::SpamAssassin::DBBasedAddrList::remove_entry('Mail::SpamAssassin::DBBasedAddrList=HASH(0xa881df0)',
>'HASH(0xa6bc474)') called at
>/usr/share/perl5/Mail/SpamAssassin/AutoWhitelist.pm line
>134\n\tMail::SpamAssassin::AutoWhitelist::check_address('Mail::SpamAssassin::AutoWhitelist=HASH(0xa87eba8)',
>'hugh@imagine
>adv.com', 82.227.79.148) called at
>/usr/share/perl5/Mail/SpamAssassin/Plugin/AWL.pm line 355\n\teval
>{...} called at /usr/share/perl5/Mail/SpamAssassin/Plugin/AWL.pm line
>351\n\tMa
>il::SpamAssassin::Plugin::AWL::check_from_in_auto_whitelist('Mail::SpamAssassin::Plugin::AWL=HASH(0xa09da08)',
>'Mail::SpamAssassin::PerMsgStatus=HASH(0xa67060c)') called at (eval 2
>80) line 7\n\tMail::SpamAssassin::PerMsgStatus::check_f...

This could be simply what spamassassin was doing at the point you ran out of 
time. One possible reason for timeouts is sa-learn is running an expiry, and 
possibly learning a message at the same time. The Debian package of 
amavisd-new has a cron entry that runs --force-expire once a day 
(/etc/cron.daily/amavisd-new). You can disable opportunistic expiry by 
setting:
bayes_auto_expire 0
in local.cf, but MAKE SURE the script works or Bayes will grow forever. 
Simply run it. If it takes a minute to run, it's very likely working. The 
script may be outdated also. The important part should read something like:
su - amavis -c '/usr/bin/sa-learn --sync --force-expire >/dev/null'

Moving to MySQL helps considerably:
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html

Gary V

_________________________________________________________________
Add a Yahoo! contact to Windows Live Messenger for a chance to win a free 
trip! 
http://www.imagine-windowslive.com/minisites/yahoo/default.aspx?locale=en-us&hmtagline