MySQL Forums
Forum List  »  NDB clusters

Re: How to resolve "Lock wait timeout exceeded" issue reported by MySQL Cluster
Posted by: Steven Welz
Date: June 13, 2016 08:26AM

Hi,

i dont want to highjack this thread but i have a simmilar problem. Of course i know what this error means and what it causes but the strange thing for me is that if i look table rows and try to insert data with the same keys i get an INSTANT error :

mysql> START TRANSACTION;
mysql> SELECT * FROM foo WHERE bar=1 FOR UPDATE;

wihout committing the transaction i fireup a new console :

mysql> START TRANSACTION;
mysql> REPLACE foo (bar) VALUES (1);
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

My lock_wait_timeout is set to '31536000'. Why is this happening ?

Sorry again for highjacking but i didnt want to start a new thread with the same subject when your thread is on the first page.

regards,
Steven

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.