maria-developers team mailing list archive

[Kazuhiko Shiozaki <kazuhiko@xxxxxxxxxx>]

On 18/02/2013 16:31, Kazuhiko Shiozaki wrote:
> 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.

And  innodb_locks_unsafe_for_binlog is ON, could it be the reason ?

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/