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/