Re: Deadlock found when trying to get lock; Try restarting transaction, message from server: "Lock wait timeout exceeded; try restarting transaction" : for SELECT statement

[Ted Wennmark]

Hello,

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: https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-transactiondeadlockdetectiontimeout

Regards,
Ted