Re: linked error "Lock wait timeout exceeded"

[Pierre COLOMBIER]

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.)