maria-developers team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Kazuhiko Shiozaki <kazuhiko@xxxxxxxxxx> 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.