Jason wrote: > 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)) http://marc.info/?t=117891630000003 Gary V ------------------------------------------------------------------------- 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 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/