Bug #38088 rpl_row_basic_7ndb failed At line 55 INSERT INTO t2 ...
Submitted: 13 Jul 2008 16:03 Modified: 12 Mar 2009 14:35
Reporter: Andrei Elkin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:6.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: pushbuild, sporadic, test failure

[13 Jul 2008 16:03] Andrei Elkin 
Description:
CURRENT_TEST: rpl_ndb.rpl_row_basic_7ndb
mysqltest: In included file "./extra/rpl_tests/rpl_row_basic.test": At line 55: query 'INSERT INTO t2
VALUES (1,'A',2),  (2,'A',4),  (3,'A',9),  (4,'A',15), (5,'A',25),
(6,'A',35), (7,'A',50), (8,'A',64), (9,'A',81)' failed: 1205: Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:
< snip >
A	I
X	Y
X	Z
UPDATE t1 SET c2 = 'Q' WHERE c1 = 'A' AND c2 = 'N';
SELECT * FROM t1 ORDER BY c1,c2;
C1	C2
A	B
A	I
X	Y
X	Z
SELECT * FROM t1 ORDER BY c1,c2;
C1	C2
A	B
A	I
X	Y
X	Z
CREATE TABLE t2 (c1 INT, c12 char(1), c2 INT, PRIMARY KEY (c1)) ENGINE = 'NDB'  ;
INSERT INTO t2
VALUES (1,'A',2),  (2,'A',4),  (3,'A',9),  (4,'A',15), (5,'A',25),
(6,'A',35), (7,'A',50), (8,'A',64), (9,'A',81);

More results from queries before failure can be found in /dev/shm/var-ps_row-112/log/rpl_row_basic_7ndb.log

Warnings from just before the error:
Error 1297 Got temporary error 266 'Time-out in NDB, probably caused by deadlock' 

How to repeat:
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=sapsrv1&...
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=24
[12 Feb 2009 14:35] Jonathan Miller 
Does this still happen?
[13 Mar 2009 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".