On 4/6/10 2:46 PM, Mark Martinec wrote:
>
> The race condition is probably due to some SQL optimization/caching/whatever.
> I assume the ENGINE=InnoDB is used. Which version of MySQL btw?
>
>
yes, InnoDB. mysql 5.1.34
> The correct solution would probably be to do a SELECT-OR-INSERT in one go,
> or perhaps do an INSERT which could return a generated ID of the inserted
> record. Suggestion on how to do it in a standard SQL as understood by
> mainstream SQL servers is welcome.
>
(or, as SA did, they have a 'generic' sql, and an optimized MySql.)
Once I track it down, and find a way to fix it, I'll let you know.
--
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/
______________________________________________________________________
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
