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
6363
June 01, 2005 03:37AM
2720
June 01, 2005 01:21PM
2646
June 09, 2005 06:42AM
2741
June 10, 2005 06:18AM
2530
June 16, 2005 03:06AM
2457
June 16, 2005 06:28AM
2461
June 16, 2005 06:32AM
2544
June 20, 2005 05:46AM
Re: linked error "Lock wait timeout exceeded"
6456
June 09, 2005 06:50AM
6356
June 09, 2005 07:57AM
3072
June 17, 2005 09:04AM
3033
June 20, 2005 05:56AM
2980
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.