Sven wrote:
> Hi,
>> Since a few days I got some problems mit amavisd-new and spamassassin.
>> After ~2 days amavisd dies and all emails are stocked in the postfix
>> queue.
>>
>> /usr/local/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesSt
>> ore/DBM.pm line 227\n\tMail::Spam
>> Assassin::BayesStore::DBM::tie_db_writable('Mail::SpamAssassin
>> ::BayesStore::DBM=HASH(0xa43ac88)') called at
>> /usr/local/lib/perl5/site_perl/5.8.5/Mail/SpamAssassin/BayesSt
>> ore.pm line 208\n\teval {...} called at
>> /usr/local/lib/perl5/site_perl/5...
>>
> Could it be that you're running out of locks for the bayes database?
> Check sleepycat.com (the people who make berkeley db) or your local
> documentation on how you can find out the stats of your bdb files.
> Unless you need bayesian filtering, you can try to not use bayes for
> a while (settable in spamassassins local.cf file).
> With that many mails I'd also suggest looking into using an SQL
> backend for bayes. This will reduce your risk of running into
> bdb problems (for some people it works fine, I usually have LOTS
> of problems with bdb) such as file corruption, running out of lockers,
> safe backups etc.
> Regs,
> Sven
In addition to using SQL for Bayes, read about 'lock_method type'
in the documentation to determine if it would be appropriate to use
the other lock_method.
http://spamassassin.apache.org/full/3.0.x/dist/doc/Mail_SpamAssassin_Conf.html
However, I'm not sure if this only applies to BDB based Bayes.
Here is a page that details migrating Bayes (and AWL) to MySQL 4.1 on a
Debian machine, it may (if nothing else) give you an idea what is involved.
http://www200.pair.com/mecham/spam/debian-spamassassin-sql.html
There are also links to other documents that outline the process
there.
Gary V
-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
