Jason Shatzkamer asked 8 years ago
"I could not select query because: Deadlock found when trying to get lock; try restarting transaction"
This happens occcasionally, more often than I'd like, but occasionally.
On one particular view, though, it is happening every single time we load the grid, and we have confirmed that no other users are accessing it.
Is there some kind of lock cache that may be "stuck"?
Guidance?
Abu Ghufran answered 8 years ago
Hello,
Looks like multiple connections are accessing same tables causing this issue.
Grid does not independently raise such error.
Refer following threads:
http://stackoverflow.com/questions/2332768/how-to-avoid-mysql-deadlock-found-when-trying-to-get-lock-try-restarting-trans
http://dba.stackexchange.com/questions/25472/how-can-i-configure-mysql-innodb-to-handle-1000s-of-inserts-per-hour
