Hi, all. I enabled '@storage_sql_dsn' in Amavisd-new-2.6.4, used to store incoming/outgoing mail info, and quarantine SPAM into MySQL database.
But i got many "Duplicate entry" log like below, just wondering how to solve it. #--<-- Feb 9 12:10:16 mail amavis[31806]: (31806-06) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-9R6CJuPSz7Ar-0' for key 1 at (eval 102) line 166, <GEN15> line 7126. Feb 9 12:10:18 mail amavis[31806]: (31806-06) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-9R6CJuPSz7Ar-0' for key 1 at (eval 102) line 166, <GEN15> line 7126. Feb 9 12:10:33 mail amavis[32041]: (32041-03) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-7-BWtkkAeqdC-0' for key 1 at (eval 102) line 166, <GEN15> line 3484. Feb 9 12:10:34 mail amavis[32041]: (32041-03) (!)WARN save_info_final: sql exec: err=1062, 23000, DBD::mysql::st execute failed: Duplicate entry '0-7-BWtkkAeqdC-0' for key 1 at (eval 102) line 166, <GEN15> line 3484. #--<-- I try to increase MySQL "max_connections" setting, but it doesn't work at all. Any suggestions? Thanks. :) ------------------------------------------------------------------------------ The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user Please visit http://www.ijs.si/software/amavisd/ regularly For administrativa requests please send email to rainer at openantivirus dot org
