"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"?
Looks like multiple connections are accessing same tables causing this issue.
Grid does not independently raise such error.
Refer following threads:
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?