....
 

Guardian Digital Inc. > InfoCenter > Mailing List Archives > Amavis

Amavis Mailing List Archive

From: Pavel Urban (pavel.urban@ct.cz)
Date: Tue Dec 28 2004 - 04:54:26 EST


Mark.Martinec+amavis@ijs.si wrote:
> Pavel,
>
>
>>we're running two instances of amavisd-new with different configuration
>>files. They are using the same clamav daemon (communicating through TCP
>>socket - without problem) and the same SA database (problem?).
>
>
> With the invention of policy maps, you can probably do it with
> one amavisd instance only, to slightly simplify matters.
>
>
>>We're seeing many SA timeouts... I'm adding them to this mail.
>>Is this configuration ok, or should I change it?
>
>
> I agree with Clifton's opinion.
> As far as bayes is concerned, your best solution is to move
> the bases db to SQL, as explained in the SA documentation
> in ./sql/READ*. It is faster and more reliable, and concurrent
> db access is no longer an issue.
>
> Mark

Hello,

I've tried suggested migration of Bayes database from db4 to MySQL. It
helped a bit, thanks a lot. But I'm still getting SA timeouts, now in
SQL code. Do you have any idea what's going wrong? Or what to do next?
Thanks!

Dec 28 10:47:34 antivir3 amavis[887]: (00887-11) SA TIMED OUT,
backtrace: at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/Bayes.pm line
361\n\teval {...} called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/Bayes.pm line
361\n\tMail::SpamAssassin::Bayes::tokenize('Mail::SpamAssassin::Bayes=HASH(0xa361690)','Mail::SpamAssassin::Message=HASH(0xbfab568)','HASH(0xbf579f0)')
called at /usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/Bayes.pm
line
1200\n\tMail::SpamAssassin::Bayes::scan('Mail::SpamAssassin::Bayes=HASH(0xa361690)','Mail::SpamAssassin::PerMsgStatus=HASH(0xbf1669c)','Mail::SpamAssassin::Message=HASH(0xbfab568)')
called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/EvalTests.pm line
2690\n\tMail::SpamAssassin::PerMsgStatus::check_bayes('Mail::SpamAssassin::PerMsgStatus=HASH(0xbf1669c)','ARRAY(0xbf91474)',0.20,0.40)
called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/PerMsgStatus.pm line
2296\n\teval {.....

Dec 28 10:48:01 antivir3 amavis[21378]: (21378-02-77) SA TIMED OUT,
backtrace: at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line 1843\n\teval {...} called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line
1843\n\tMail::SpamAssassin::BayesStore::SQL::_put_token('Mail::SpamAssassin::BayesStore::SQL=HASH(0xaf344c8)','\\x{92}\\x{c6}\\x{e9}\\x{d5}\\x{c4}',0,1,1104226808)
called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line
933\n\tMail::SpamAssassin::BayesStore::SQL::tok_count_change('Mail::SpamAssassin::BayesStore::SQL=HASH(0xaf344c8)',0,1,'\\x{92}\\x{c6}\\x{e9}\\x{d5}\\x{c4}',1104226808)
called at /usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/Bayes.pm
line
828\n\tMail::SpamAssassin::Bayes::learn_trapped('Mail::SpamAssassin::Bayes=HASH(0x9aa5690)',0,'Mail::SpamAssassin::Message=HASH(0xd1709cc)','HASH(0xcf44b44)','undef')
called at /usr/lib/perl5/vendor_perl/5.8.0/Mail/Spa...

Dec 28 10:48:25 antivir3 amavis[27975]: (27975-02-38) SA TIMED OUT,
backtrace: at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line 786\n\teval {...} called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line
786\n\tMail::SpamAssassin::BayesStore::SQL::tok_get('Mail::SpamAssassin::BayesStore::SQL=HASH(0xaf344c8)','pD\\x{6}\\x{e4}\\x{1e}')
called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line
1694\n\tMail::SpamAssassin::BayesStore::SQL::_put_token('Mail::SpamAssassin::BayesStore::SQL=HASH(0xaf344c8)','pD\\x{6}\\x{e4}\\x{1e}',0,1,1104226814)
called at
/usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/BayesStore/SQL.pm
line
933\n\tMail::SpamAssassin::BayesStore::SQL::tok_count_change('Mail::SpamAssassin::BayesStore::SQL=HASH(0xaf344c8)',0,1,'pD\\x{6}\\x{e4}\\x{1e}',1104226814)
called at /usr/lib/perl5/vendor_perl/5.8.0/Mail/SpamAssassin/Bayes.pm
line 828\n\tMail::SpamAssassin::Bay...

-- 
***********************************************************************
Pavel Urban (pavel.urban@ct.cz)
IOL system disaster
Internet OnLine, www.iol.cz (owned by Czech Telecom, www.ct.cz)
***********************************************************************
    Vegetables should not operate electronic equipment.
           Computer Stupidities, http://rinkworks.com/stupid/
***********************************************************************
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/


[ About Guardian Digital ] - [ Press Center ] - [ Contact Us ] - [ System Activation ] - [ Reseller Info ] - [ Online Store ] - [ Site Map ]
Copyright (c) 2000 - 2004 Guardian Digital, Inc. Linux Lockbox and EnGarde are Trademarks of Guardian Digital, Inc.