MySQL Forums
Forum List  »  NDB clusters

How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster
Posted by: Jingyu Hu
Date: May 26, 2016 03:53AM

When our system busy with SQL update logic in MySQL Cluster, it report below info:
----------------------------
Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionCaused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
----------------------------

Is MySQL cluster NDB engine different to Innodb, that difference lead this issue ?

Or there is no difference between NDB and Innodb about SQL Lock logic, that happened comes from our system logic ?

Could you help to give me more suggestions to resolve this issue ?

Best Regards,
Hu Jingyu

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.