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...@returnpath.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.
run this and see if you get a hit, (assumes you have rotated logs using
gzip)
zgrep 'sql-enter FAILED: find_or_save_addr: failed to insert addr'
/var/log/maillog | tail
If you are getting these, then maybe we can narrow it down.
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best Anti-Spam Product 2008, Network Products Guide
* King of Spam Filters, SC Magazine 2008
______________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
______________________________________________________________________
------------------------------------------------------------------------------
_______________________________________________
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
