Bug #47245 rpl_ndb.rpl_ndb_2other fails on PB2.

Submitted: 10 Sep 2009 10:41
Reporter: Luis 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 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.047 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
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.