Re: deadlock: a row being locked by a query twice?

[Amit K]

We are using stored procedures in our project. So got to use it.

Nevertheless, the query I am using uses primary key, may be a bit inefficient, but works like a charm. No deadlocks in months (it's a very high volume/frequency query), with one exception (of course).

I am interested in knowing how can a query ever get an exclusive lock on same record, this is what innodb status says (if i am reading it correctly). This puzzles me.