Paolo, > today I gave a test run to the quarantine cleanup script during working > hours, and noticed amavisd-new behaviour. Because of DB timeout the > message was left in Postfix' incoming queue.
Right, this is the intended behaviour. > Setup: 2.3.3 with Mysql 4.1.17 quarantine and Bayes store. > Here's the log excerpt from one of the messages that got deferred: ... > Dec 28 15:41:36 srv-asgw03 amavis[23922]: (23922-01-2) writing mail text > to SQL failed: Error closing, flush: sql inserting text failed, sql > execute: sts=1205, DBD::mysql::st execute failed: Lock wait timeout > exceeded; try restarting transaction at (eval 37) line 127 ... > Dec 28 15:41:36 srv-asgw03 postfix/smtp[23889]: DAE675840FA: > to=<[EMAIL PROTECTED]>, relay=127.0.0.1[127.0.0.1], delay=217, > status=deferred (host 127.0.0.1[127.0.0.1] said: 451-4.5.0 Error in > processing, id=23922-01-2, spam quar+notif FAILED: temporarily unable to > quarantine: 451 4.5.0 Storing to sql db as mail_id RwE12bnYGrrT failed:... > Was the message sent twice? Any cure? Sent twice? What makes you think so? After this unsuccessful attempt, Postfix retried the same message later, and when cleanup was over, the next attempt should have been successful. Recipients should have this message delivered exactly once. Mark ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ 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/
