Hello.
SERIALIZABLE is like REPEATABLE READ, but all plain SELECT statements are implicitly converted to SELECT ... LOCK IN SHARE MODE. In REPEATABLE READ statements like SELECT ... LOCK IN SHARE MODE that use a unique index with a unique search condition lock only the index record found, not the gap before it. So, parallel INSERTs are possible and they cause a 'duplicate' error. > In the transaction isolation level,Database send some "duplicate entry" > message to me. > Why? > > _________________________________________________________________ > $$$$$$$$$$$$$$ MSN Messenger: http://messenger.msn.com/cn > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
