Mysql deadlock single insert transactions

Question

In the following case I am seeing a deadlock detected, retry transaction error:

Multiple insertions are occurring concurrently. Each insertion is done within a transaction for only a single row. (Each transaction only does one insert between its begin and commit.) The table has 3 columns, one of which is the PK. The PK is not auto-incremented.

How is it possible for a deadlock to occur if each transaction is only holding a single lock? I thought that a single row insertion would only require a single row level lock.

Did you try running `SHOW INNODB STATUS` to get some more info? — ldg, Jul 17 '16 at 01:43
Please provide `SHOW CREATE TABLE` and the insert statement. — Rick James, Jul 17 '16 at 22:53

score 0 · Answer 1 · answered Jul 17 '16 at 06:13

0

Try using on mysql shell: show processlist This will give you details of what queries are under execution among other things. This would be a good starting point.

answered Jul 17 '16 at 06:13

Razor Tag

36
4

Mysql deadlock single insert transactions

1 Answers1