Joel, > Our setup involves a large number of frontend smtp servers (running > postfix-amavis-postfix, spamassassin, av, dns, mysql,..., etc.). We > have just enabled SQL quarantine an all servers using a mysql local to > each server. We then have a script that migrates quarantined messages > from the local mysql instance to a central mysql server. We have > encountered 5 quarantined messages that have the same mail_id as > previous quarantined messages (mail_id is unique with respect to the > five messages). I've looked at the mail_id generation routine and the > ins_msg sql definition and corresponding routine and can't find any > logic to deal with duplicate mail_id's. > > Am I missing something, is there logic to deal with duplicate mail_id
There is: when a mail_id is generated, a record to msgs table is immediately inserted, and if that fails (duplicate key), a new mail_id is generated (in several attempts in an unlikely event of collisions). All this before any further processing is done, so the selected mail_id is guaranteed to be unique in a database of existing records. > that is broken by or mysql2mysql migration scheme? If there is no such > logic how does amavisd guarantee that the mail_id is unique (even for > single server setups). > Have GUID/UUID's been considered? Yes, and a lot more - there are numerous places to collect entropy (see calls to add_entropy), so the 71.9 bits of entropy should be fairly well dispersed. See RELEASE_NOTES. Mark ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
