I started seeing this in my mailq. So I deleted my quarantine database, which is only virus. It now has zero rows, but still occurs. I'm not an SQL idiot, but I'm uncertain what the problem is here.
Thanks, Jason -=-=-=-= 05E0CEFC9C 44713 Tue May 15 01:42:25 MAILER-DAEMON (host localhost[127.0.0.1] said: 451-4.5.0 Error in processing, id=06507-07, quar+notif FAILED: temporarily unable to quarantine: 451 4.5.0 Storing to sql db as mail_id X9ja7O+ABa3e failed: writing mail text to SQL failed: Error closing, flush: sql inserting text failed, sql exec: err=1452, S1000, DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`amavisd/quarantine`, CONSTRAINT `quarantine_ibfk_1` FOREIGN KEY (`mail_id`) REFERENCES `msgs` (`mail_id`) ON DELETE CASCADE) at (eval 39) line 162 451 4.5.0 , <GEN757> line 817. at (eval 41) line 196, <GEN757> line 817. at (eval 41) line 78, <GEN757> line 817. at (eval 41) line 322, <GEN757> line 817., id=06507-07 at /usr/local/sbin/amavisd line 10056, <GEN757> line 817. (in reply to end of DATA command)) ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ 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/
