MySQL Forums
Forum List  »  NDB clusters

Re: linked error "Lock wait timeout exceeded"
Posted by: Pierre COLOMBIER
Date: June 09, 2005 06:50AM

if I use only one process to insert data, in the cluster, sometimes it stops saying Lock wait timeout exceeded; try restarting transaction

If i submit the file again, the problem occurs again a few minutes later

exemple :

[root@mysystem ndb]# cat data.sql | mysql mydatabase
ERROR 1205 at line 994969: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]# tail +994969 data.sql | mysql mydatabase
ERROR 1205 at line 29230: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]# tail +994969 data.sql | tail +29230 | mysql mydatabase
ERROR 1205 at line 292888: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]# tail +994969 data.sql | tail +29230 | tail +292888 | mysql mydatabase
ERROR 1205 at line 1816: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]# tail +994969 data.sql | tail +29230 | tail +292888 | tail +1816 | mysql mydatabase
ERROR 1205 at line 10546: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]# tail +994969 data.sql | tail +29230 | tail +292888 | tail +1816 | tail +10546 | mysql mydatabase
ERROR 1205 at line 62063: Lock wait timeout exceeded; try restarting transaction
[root@mysystem ndb]#



(ok guys, I know it is not a good thing to use tail | tail | tail | tail but it was easier and it's definitely not the problem's reason.)

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.