Continually getting deadlock errors when using the grid

QuestionsContinually getting deadlock errors when using the grid
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?

1 Answers
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

Your Answer

10 + 19 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?