Bug #47245 rpl_ndb.rpl_ndb_2other fails on PB2.
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.
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