[AMaViS-user] Quarantine to SQL and points of failure

Hi Mark,

Thanks for accepting the previous changes to the
database, the cleanup/purging is extremely fast now.

The next thing I'd like to address is when quarantining
to SQL, and the query fails for whatever reason. If i am
reading correctly, amavisd-new will try 5 times to insert
the SPAM mail into the database, and failing that, it will
switch into a "bypass" mode and delete the spam message.
This behavior is perfect as it allows amavisd-new to work
around points of failure.

However, is there any chance the same behavior can exist
for when the database connection goes down? If 1 connection
to the database gets killed when trying to quarantine a
spam mail, amavisd-new comes to a complete standstill for
*every* child and no longer accepts connections and ofcourse
refuses to process any mail.

Example:

Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) LMTP:[196.2.50.197]:10024 /var/amavis/tmp/amavis-20051114T185900-21706: <bluesroom@firemail.firewater.co.za> -> <Mywork@iafrica.com> Received: SIZE=13079 from postwall01.mweb.co.za ([196.2.42.21]) by spamwall03.mweb.co.za (spamwall03.mweb.co.za [196.2.50.197]) (amavisd-new, port 10024) with LMTP id 21706-01-53 for <Mywork@iafrica.com>; Mon, 14 Nov 2005 18:59:00 +0200 (SAST)
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) connect_to_sql: unable to connect to DSN 'DBI:mysql:database=amavis;host=196.2.50.213;port= 3306': Can't connect to MySQL server on '196.2.50.213' (111)
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) TROUBLE in process_request: connect_to_sql: unable to connect to any dataset at (eval 39) line 172, <GEN302> line 16.
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) Requesting process rundown after fatal error
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) extra modules loaded: List/Util.pm, Scalar/Util.pm
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) SMTP shutdown: tempdir is to be PRESERVED: /var/amavis/tmp/amavis-20051114T185900-21706
Nov 14 18:59:00 spamwall03.mweb.co.za amavis[21706]: (21706-01-53) SMTP shutdown: Error writing a SMTP response to the socket: Bad file descriptor at (eval 44) line 813.\n

Instead of no longer accepting messages, is it possible to
switch into a 'bypass mode' and simply delete the spam
message? (If there is trouble with the database when
quarantining, perhaps there should be a "counter" to keep
track of errors. Ie, should amavisd-new get more than 5
database connect() or MySQL INSERT failures in the period
of N minutes, it should switch into a 'bypass mode' for
5 minutes and then try and poll again.

Comments?

Cami


-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP. Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/