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: Ted Wennmark
Date: November 26, 2015 01:55AM


How long time is passing before start of statements and timeout?
This SELECT will do a full scan of all data in cluster data nodes, filtering using LIMIT will be done on MySQL server layer.

I would guess this is more a timeout than a true deadlock so error message is a bit confusing.

Have you tried to increase TransactionDeadlockDetectionTimeout:


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.