Mark Martinec wrote: > 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.
Thanks for the quick reply Mark. Our replication/migration scheme would break this check, look like we need to add similar logic. > >> 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/ > -- Joel Nimety Perimeter Internetworking Corp. 203.541.3416 -- The sender of this email subscribes to Perimeter Internetworking's email anti-virus service. This email has been scanned for malicious code and is believed to be virus free. For more information on email security please visit: http://www.perimeterusa.com/malicious_code_defense_content.html This communication is confidential, intended only for the named recipient(s) above and may contain trade secrets or other information that is exempt from disclosure under applicable law. Any use, dissemination, distribution or copying of this communication by anyone other than the named recipient(s) is strictly prohibited. If you have received this communication in error, please delete the email and immediately notify our Command Center at 203-541-3444. ------------------------------------------------------------------------- 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/
