Re: linked error "Lock wait timeout exceeded"
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.)
Subject
Views
Written By
Posted
6206
June 01, 2005 03:37AM
2647
June 01, 2005 01:21PM
2581
June 09, 2005 06:42AM
2681
June 10, 2005 06:18AM
2473
June 16, 2005 03:06AM
2397
June 16, 2005 06:28AM
2401
June 16, 2005 06:32AM
2472
June 20, 2005 05:46AM
Re: linked error "Lock wait timeout exceeded"
6346
June 09, 2005 06:50AM
6279
June 09, 2005 07:57AM
2925
June 17, 2005 09:04AM
2974
June 20, 2005 05:56AM
2918
June 23, 2005 10:26AM
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.