At the end of august I upgraded our mail server from Amavisd-new 2.1 to 2.3
and enabled the SQL quarantining. Ran into a few snags at first since the box
was running Mysql 4.0 and not 4.1, but got it all setup. Though a week or two
ago I noticed that were the duplicate indexes on some of the new tables for
2.3's sql storage support.
In any case, the problem I'm having is strange and not sure how best to track
it down. Amavisd was running for a month logging to syslog (log level 2, same
as I have been forever) and to sql, and the db eventually grew to about 5GB.
The cleanup script that came with mailzu was taking forever to run (most
likely due to duplicated indexes) so it got ran a time or two manually. My
goal was to get mailzu up and running so that we could give users access to
quarantine.
The problem is that Amavisd would eventually 'get borked' and stop processing
mail. There are no errors in the log that give any hints. What appears to
happen is that the master process either dies or stops spawning children,
because in the log what I see is just one child going through a bunch of
tasks. For example:
amavis[childpid]: (childpid-session-task): log data
and over a span of a few hours on this last 'crash' I only see one childpid
and one session but the task count goes to several hundred. I'm guessing this
is due to a cached ESMTP session from the sendmail MTA that feeds data to
amavisd (running in MTA mode, that then forwards to our POP3 server). Is there
a way to enforce a limited task per session? Such that once a child processes
so many tasks just shutdown the session.
In any case, what I'm really wondering is if anyone has had any problems with
using SQL lookups along side SQL storage, or if there are any tips. Turning
off the SQL logging and changing nothing else caused the problem to go away.
Also with the SQL logging, it appears to log every message
(clean/spam/banned/etc) in SQL, is it possible to only log stuff marked as
spam. I already have the whole log via syslog so I was only really interested
in getting the emails that were blocked in sql.
--
Ryan Moore
----------
Perigee.net Corporation
704-849-8355 (sales)
704-849-8017 (tech)
www.perigee.net
-------------------------------------------------------
This SF.Net email is sponsored by:
Power Architecture Resource Center: Free content, downloads, discussions,
and more. http://solutions.newsforge.com/ibmarch.tmpl
_______________________________________________
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/
