MySQL Forums
Forum List  »  NDB clusters

Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement
Posted by: Anwar Reefat
Date: November 27, 2015 11:34PM

Increasing TransactionDeadlockDetectionTimeout solves the problem.
But i think it's a temporary solution.
Increasing this value will work for few more extra query.
but that has a limit too and after reaching that max limit, again deadLock exception will appear.

But i am wondering why SELECT statement doesn't work concurrently ?

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.