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
© 2024, Oracle Corporation and/or its affiliates
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