MySQL Forums

Hi,

No, innodb_lock_wait_timeout isn't at all related to the problem you are seeing. You are running into a real deadlock, ie. A is waiting on B who is waiting on A who is waiting on B...., so InnoDB needs to roll on of them back in order to allow anyone to continue.

One tool very useful in debugging the deadlock scenarios is SHOW INNODB STATUS; If you run that command after you get a deadlock, it will tell you more information about how the deadlock occured, ie. what statements were waiting on each other and so on.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com