Michael, > If you DON'T get this, no need to tell me, if we do have a couple people > getting this, then we can try to see why. > > I am looking for people running latest amavisd, with mysql 5.1.x and > getting these errors in your maillogs: > > May 19 16:16:01 mx1 postfix/lmtp[57047]: 51EB9B0D6E9: > to=<ssny...@domain.com>, orig_to=<she...@domain.com>, > relay=127.0.0.1[127.0.0.1]:10024, conn_use=8, delay=7.4, > delays=0.71/6.6/0/0.1, dsn=4.5.0, status=deferred (host > 127.0.0.1[127.0.0.1] said: 451 4.5.0 Error in processing, id=56659-12-8, > sql-enter FAILED: find_or_save_addr: failed to insert > addrbounce-use=m=9235490230=echo4=6c598b5b6be991623d80732a3deaf...@returnp > ath.bluehornet.com: sql exec: err=1062, 23000, DBD::mysql::st execute > failed: Duplicate entry '428247251-201020' for key 'PRIMARY' at (eval 100) > line 166,<GEN278> line 24. at (eval 101) line 109,<GEN278> line 24. (in > reply to end of DATA command)) > > with max_servers at 5, sometimes I see 6 different maddr addresses > (different addresses) trying to use the same maddr id. (which, can't > happen!) > > Duplicate entry '428247251-201020' > if I am the ONLY one getting this, then I'll need to figure out why. > my assumptions are it has to do with innodb locks and partitioned tables.
Which version of MySQL 5.1.x exactly are you using? The 5.1.46 is in FreeBSD ports at this time. As you already know, there were some fixes in this area at around 5.1.22, iirc. Mark ------------------------------------------------------------------------------ _______________________________________________ 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
