Thursday, February 3, 2011

Deadlock found when trying to get lock,try restarting transaction

Deadlock found when trying to get lock; try restarting transaction
 Nuffnang ads error Deadlock found when trying to get lock; try restarting transaction

General cause;
This exception is throwed up in this case:

 - INNODB table
 - autoincrement field
 - two or more concurrent thread 
 - SQL command deleting / inserting via transaction

1 comment: