Sasa,
> Hi, in log file I have this error with SA-3.2.5 and MySQL-5.0.77 (with
> amavisd-new, postfix, maia):
>
> Jul 23 11:03:35 mail amavis[6329]: (06329-02-2) SA TIMED OUT, backtrace: at
> /usr/lib/perl5/vendor_perl/5.10.0/Mail/SpamAssassin/BayesStore/MySQL.pm
> line 492\n\teval {...} called at
> /usr/lib/perl5/vendor_perl/5.10.0/Mail/SpamAssassin/BayesStore/MySQL.pm
> line
> 492\n\tMail::SpamAssassin::BayesStore::MySQL::tok_touch_all('Mail::SpamAssa
>ssin::BayesStore::MySQL=HASH(0xb8bfcec)', 'ARRAY(0xb19ce24)', 1248337394)
> called at
> /usr/lib/perl5/vendor_perl/5.10.0/Mail/SpamAssassin/Bayes.pm line
> 1284\n\tMail::SpamAssassin::Bayes::scan('Mail::SpamAssassin::Bayes=HASH(0xb
>6a92bc)', 'Mail::SpamAssassin::PerMsgStatus=HASH(0xcfda70c)',
> 'Mail::SpamAssassin::Message=HASH(0xd1bb9dc)') called at
> /usr/lib/perl5/vendor_perl/5.10.0/Mail/SpamAssassin/Plugin/Bayes.pm line
> 50\n\tMail::SpamAssassin::Plugin::Bayes::check_bayes('Mail::SpamAssassin::P
>lugin::Bayes=HASH(0xb7647cc)',
> 'Mail::SpamAssassin::PerMsgStatus=HASH(0xcfda70c)', 'ARRAY(0xba621dc)',
> 0.99, 1.00) called at (ev...
>
> ..this error is present occasionally but several times in a day.
> This error is caused by SA or MySQL ?
Amavisd sets a timer before calling SpamAssassin, typically to 30 seconds.
If the timer expires, it logs a backtrace, although execution is typically not
interrupted. The backtrace shows where the program was at the time
of the interrupt - which may or may not be the actual trouble spot guilty
of consuming excessive time. If this happens repeatedly and the backtrace
points to a similar place in the code, it is likely this actually _is_ the
trouble spot. If it hapens very rarely, you can ignore it, it can be treated
as as warning only.
Mark
