Ilo, > I'm getting the following in my logs, so far this morning it happened > 76 times and when it happens a queue starts to build and the load on > my machine goes up quite intensenly .? > > Mar 12 12:07:52 scanjia0z04.ipnetwork.co.za /usr/sbin/amavisd[15759]: > (15759-04-5) (!)SA TIMED OUT, backtrace: at > /usr/lib/perl5/vendor_perl/5.8.5/Mail/SpamAssassin/BayesStore/SQL.pm > line 2152\n
Line 2152 corresponds to running an 'UPDATE bayes_token ...'. Could be your database is corrupted or needs optimizing, or some other operation was running on it and was locked (perhaps the opportunistic auto-expiry). > the below message was rather small being SIZE=96145, I haven't > modified $sa_mail_body_size_limit = 200*1024 > > and I'm using amavisd-new-2.4.3 and spamassassin-3.2.5 , > > I'm using Intel(R) Xeon(TM) CPU 3.06GHz with 2 GIGS RAM, but this has > only recently started happening.. > I do maintain my bayes database nightly, below is a dump of the magic > tokens .. is the DB still too big? > > 0.000 0 3 0 non-token data: bayes db version > 0.000 0 33752 0 non-token data: nspam > 0.000 0 95204 0 non-token data: nham > 0.000 0 890713 0 non-token data: ntokens > 0.000 0 1236713732 0 non-token data: oldest atime > 0.000 0 1236856490 0 non-token data: newest atime > 0.000 0 0 0 non-token data: last journal sync > atime > 0.000 0 1236850577 0 non-token data: last expiry > atime > 0.000 0 0 0 non-token data: last expire > atime delta > 0.000 0 0 0 non-token data: last > expire reduction count Looks reasonable, not too big. If using MySQL, I'd strongly suggest to switch from Mail::SpamAssassin::BayesStore::SQL to Mail::SpamAssassin::BayesStore::MySQL as a bayes_store_module, and convert tables from MyISAM to InnoDB. It all becomes much more predictable and reliable. See file sql/README.bayes that comes with a SpamAssassin distribution. Mark ------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-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/