主题: amavis (!)WARN save_info_final: sql exec: err=1062 产生原因
Feb 11 22:28:18 mail postfix/qmgr[23310]: 008D538B08CA: from=<international@emarsys.net>, size=10250, nrcpt=3 (queue active)
Feb 11 22:28:18 mail amavis[23206]: (23206-05) Passed CLEAN, LOCAL [91.211.240.179] [91.194.249.232] <international@emarsys.net> -> <apple.lai@xxx.com>,<
judy.hu@xxx.com>,<simon.xu@xxx.com>, Message-ID: <4D554786.00000028@pmta40179.emarsys.net>, mail_id: sWiAztUnV4uk, Hits: -9.515, size: 9681, queued_a
s: 008D538B08CA, dkim_id=invitation@fashionandyou.com,invitation@fashionandyou.com, 36309 ms
Feb 11 22:28:18 mail amavis[23206]: (23206-05) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-sWiAztUn
V4uk-0' for key 1 at (eval 102) line 166, <GEN17> line 7202.
Feb 11 22:28:18 mail postfix/pipe[23476]: 008D538B08CA: to=<judy.hu@xxx.com>, relay=dovecot, delay=0.63, delays=0.09/0.02/0/0.52, dsn=2.0.0, status=sent
(delivered via dovecot service)
Feb 11 22:28:18 mail postfix/pipe[23478]: 008D538B08CA: to=<simon.xu@xxx.com>, relay=dovecot, delay=0.78, delays=0.09/0.03/0/0.66, dsn=2.0.0, status=sent
(delivered via dovecot service)
Feb 11 22:28:18 mail postfix/pipe[23465]: 008D538B08CA: to=<apple.lai@xxx.com>, relay=dovecot, delay=0.81, delays=0.09/0.01/0/0.71, dsn=2.0.0, status=sen
t (delivered via dovecot service)
Feb 11 22:28:18 mail postfix/qmgr[23310]: 008D538B08CA: removed
Feb 11 22:28:21 mail amavis[23206]: (23206-05) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-sWiAztUn
V4uk-0' for key 1 at (eval 102) line 166, <GEN17> line 7202.
Feb 11 22:28:30 mail last message repeated 3 times
在收到给本域多个收件人的时候,amavis 向mysql写入的时候就会出现重复的错误
猜测: 如果出现Quarantined错误拦截,释放邮件可能就第一个收件人能收到,其他人收不到
zhanghuangbin 仔细检查一下,如果情况属实的话有没有办法解决一下?