Re: Deadlock Priority

[Nicolas Cannasse]

That didn't do it.

My transaction is the following :

START TRANSACTION;

DROP TABLE IF EXISTS Ranks;

CREATE TABLE Ranks
(pos INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (pos)) TYPE=InnoDB
SELECT User.id as uid , User.name as name, score, COUNT(Dino.id) as dcount
FROM User,Dino
WHERE
Dino.owner = User.id AND
User.deleted = 0
GROUP BY User.id
ORDER BY score DESC, User.id ASC;

ALTER TABLE Ranks ADD INDEX uid (uid);

COMMIT;

Sometimes I get an errno 121 (can't create table Ranks) but most of the times I get a deadlock. I tried to create a Tmp TABLE and insert a few thousands elements inside the transaction but it didn't work (still deadlock) :

CREATE TABLE Tmp (name VARCHAR(50) NOT NULL) SELECT name FROM Log;