Re: [Maria-developers] unexpected "Duplicate entry" error

Kazuhiko Shiozaki <kazuhiko@nexedi.com> writes:

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? - Kristian.