Bug #47245 rpl_ndb.rpl_ndb_2other fails on PB2.
Submitted: 10 Sep 2009 10:41
Reporter: Luis Manuel Oliveira Soares Email Updates:
Status: Verified Impact on me:
None 
Category:Tests: Cluster Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any
Tags: pb-2

[10 Sep 2009 10:41] Luis Manuel Oliveira Soares
Description:
Failure details:

Where 	Build 	Test 	Run 	Suite 	Case 	Mode 	When
mysql-5.1-bugteam
521135	binary-max-sol10-sparc64-tar-gz
521235 takk-z7	test-max-sol10-sparc64
521858 tor05-z1	ps_row	rpl_ndb	rpl_ndb_2other	None	2009-09-09 16:00:57

rpl_ndb.rpl_ndb_2other                   w1 [ fail ]
        Test ended at 2009-09-09 19:56:30

CURRENT_TEST: rpl_ndb.rpl_ndb_2other
mysqltest: In included file "./include/rpl_multi_engine2.inc": At line 20: query 'INSERT INTO t1 VALUES(42,1,'Testing MySQL databases is a cool ',
'Must make it bug free for the customer',
654321.4321,15.21,0,1965,"1905-11-14")' failed: 1205: Lock wait timeout exceeded; try restarting transaction

The result from queries just before the failure was:
< snip >
--- Show table on slave ---
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` int(11) DEFAULT NULL,
  `vc` varchar(255) DEFAULT NULL,
  `bc` char(255) DEFAULT NULL,
  `d` decimal(10,4) DEFAULT '0.0000',
  `f` float DEFAULT '0',
  `total` bigint(20) unsigned DEFAULT NULL,
  `y` year(4) DEFAULT NULL,
  `t` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
STOP SLAVE;
RESET SLAVE;
RESET MASTER;
START SLAVE;
--- Populate t1 with data ---

More results from queries before failure can be found in /export/home/pb2/test/sb_0-737460-1252508171.13/mysql-5.1.39-solaris10-sparc-test/mysql-test/var-ps_row/1/log/rpl_ndb_2other.log

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

 - saving '/export/home/pb2/test/sb_0-737460-1252508171.13/mysql-5.1.39-solaris10-sparc-test/mysql-test/var-ps_row/1/log/rpl_ndb.rpl_ndb_2other/' to '/export/home/pb2/test/sb_0-737460-1252508171.13/mysql-5.1.39-solaris10-sparc-test/mysql-test/var-ps_row/log/rpl_ndb.rpl_ndb_2other/'

Retrying test, attempt(2/3)...

How to repeat:
http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&test_failure_id=2312856

Suggested fix:
n/a