maria-developers team mailing list archive

[Kazuhiko Shiozaki <kazuhiko@xxxxxxxxxx>]

Hi Krisian,

On 18/02/2013 15:36, Kristian Nielsen wrote:
>> We sometimes (not always, not often but sometimes) have unexpected
>> "Duplicate entry" error on the following table and with the following
>> query :
>>
>> BEGIN;
>>
>> (some queries for other tables)
>>
>> DELETE FROM category WHERE uid=14026268;
>>
>> INSERT INTO category VALUES
>> (14026268, 3131502, 2074, 1),(14026268, 2992, 2992, 0),(14026268,
>> 3133077, 191, 1),(14026268, 1212264, 2992, 1);
>>
>> (some queries for other tables)
>>
>> COMMIT;
> 
> What transaction isolation level are you running these transactions with?

It's REPEATABLE-READ.

Regards,
-- 
Kazuhiko Shiozaki, Nexedi SA Senior Consultant
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.com/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/