Bug #42199 rpl_ndb_mixed_tables test fails in 6.0-bugteam
Submitted: 19 Jan 2009 13:09 Modified: 2 Jun 2009 17:04
Reporter: Georgi Kodinov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Row Based Replication ( RBR ) Severity:S3 (Non-critical)
Version:6.0-bugteam OS:Any
Assigned to: Mats Kindahl CPU Architecture:Any

[19 Jan 2009 13:09] Georgi Kodinov
Description:
the rpl_ndb.rpl_ndb_mixed_tables fails in pushbuild with the following error:
rpl_ndb.rpl_ndb_mixed_tables   [ fail ]

mysqltest: At line 54: query 'CREATE TABLE ndb_myisam    (a INT) ENGINE=NDB' failed: 1005: Can't create table 'test.ndb_myisam' (errno: 157)

The result from queries just before the failure was:
==== Initialization ====
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
---- setup master ----
CREATE TABLE myisam_innodb (a INT) ENGINE=MYISAM;
CREATE TABLE innodb_myisam (a INT) ENGINE=INNODB;
CREATE TABLE myisam_ndb    (a INT) ENGINE=MYISAM;
CREATE TABLE ndb_myisam    (a INT) ENGINE=NDB;

More results from queries before failure can be found in /dev/shm/var-rpl_ndb_row-100/log/rpl_ndb_mixed_tables.log

Warnings from just before the error:
Warning 1296 Got error 4009 'Cluster Failure' from NDB 
Error 1005 Can't create table 'test.ndb_myisam' (errno: 157)

Stopping All Servers
mysql-test-run: WARNING: Forcing kill of process 30844
Restoring snapshot of databases
Resuming Tests

ndb.bug36547                   [ pass ]           2600

How to repeat:
see pushbuild

Suggested fix:
Probably the test suite data need updating
[2 Jun 2009 17:04] Jon Stephens
Testing only, no changes to document. Closed.