Bug #47244 rpl_ndb_innodb2ndb fails on PB2 with timeout
Submitted: 10 Sep 2009 10:28
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:28] Luis Manuel Oliveira Soares
Description:
Test failure description.

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_innodb2ndb	None	2009-09-09 16:00:57

rpl_ndb.rpl_ndb_innodb2ndb               w3 [ fail ]  timeout after 900 seconds
        Test ended at 2009-09-09 19:46:13

Test case timeout after 900 seconds

== /export/home/pb2/test/sb_0-737460-1252508171.13/mysql-5.1.39-solaris10-sparc-test/mysql-test/var-ps_row/3/log/rpl_ndb_innodb2ndb.log == 
ALTER TABLE t1 MODIFY vc TEXT;
--- Show the new improved table on the master ---
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TABLE `t1` (
  `id` mediumint(9) NOT NULL,
  `b1` bit(8) DEFAULT NULL,
  `vc` text,
  `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 NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`t`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH ( YEAR(t))
PARTITIONS 4 */
--- Make sure that our tables on slave are still same engine ---
--- and that the alter statements replicated correctly ---

The server [ndbd.1.slave - pid: 2451, winpid: 2451, exit: 0] crashed while running 'analyze-timeout'
 - saving '/export/home/pb2/test/sb_0-737460-1252508171.13/mysql-5.1.39-solaris10-sparc-test/mysql-test/var-ps_row/3/log/rpl_ndb.rpl_ndb_innodb2ndb/' 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_innodb2ndb/'
 - found 'core', moving it 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_innodb2ndb'
 - found 'core' (2/5)

The test case lines:

--echo --- Make sure that our tables on slave are still same engine --- 
--echo --- and that the alter statements replicated correctly --- 

Are followed by a:

sync_slave_with_master;

Which suggests that the test case gets stuck while syncing master and slave, causing the timeout.

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

Suggested fix:
n/a