Bug #54850 rpl_ndb.rpl_ndb_stm_innodb and rpl_ndb.rpl_ndb_2other fails
Submitted: 28 Jun 2010 6:38 Modified: 2 Sep 2010 16:09
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S7 (Test Cases)
Version:M3 (Celosia), M4 (Dahlia) OS:Any
Assigned to: Magne Mæhre CPU Architecture:Any
Tags: pb2, test failure

[28 Jun 2010 6:38] Alexander Nozdrin 
Description:
rpl_ndb.rpl_ndb_stm_innodb and rpl_ndb.rpl_ndb_2other started to fail
after WL#5349 with the following symptoms:

----------------------------------------------------------------
rpl_ndb.rpl_ndb_stm_innodb               [ fail ]
        Test ended at 2010-06-27 23:54:37

Server log is:
100628  0:54:33 [Note] Plugin 'FEDERATED' is disabled.
100628  0:54:33 [Note] Plugin 'InnoDB' is disabled.
100628  0:54:33 [Note] Starting MySQL Cluster Binlog Thread
100628  0:54:33 [Warning] /export/home/pb2/test/sb_1-1981047-1277646467.41/mysql-5.5.6-m3-linux-i686-test/libexec/mysqld: unknown option '--loose-enable-performance-schema'
100628  0:54:33 [ERROR] Unknown/unsupported storage engine: InnoDB
100628  0:54:33 [ERROR] Aborting

100628  0:54:34 [Note] Stopping Cluster Binlog
100628  0:54:36 [Note] Stopping Cluster Utility thread
100628  0:54:36 [Note] Debug sync points hit:                   9
100628  0:54:36 [Note] Debug sync points executed:              0
100628  0:54:36 [Note] Debug sync points max active per thread: 0
100628  0:54:36 [Note] /export/home/pb2/test/sb_1-1981047-1277646467.41/mysql-5.5.6-m3-linux-i686-test/libexec/mysqld: Shutdown complete
----------------------------------------------------------------
rpl_ndb.rpl_ndb_2other                   [ fail ]
        Test ended at 2010-06-28 00:00:39

CURRENT_TEST: rpl_ndb.rpl_ndb_2other
--- /export/home/pb2/test/sb_1-1981047-1277646467.41/mysql-5.5.6-m3-linux-i686-test/mysql-test/suite/rpl_ndb/r/rpl_ndb_2other.result	2010-06-26 12:32:26.000000000 +0300
+++ /export/home/pb2/test/sb_1-1981047-1277646467.41/mysql-5.5.6-m3-linux-i686-test/mysql-test/suite/rpl_ndb/r/rpl_ndb_2other.reject	2010-06-28 01:00:39.000000000 +0300
@@ -60,7 +60,7 @@
   `y` year(4) DEFAULT NULL,
   `t` date DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;
@@ -152,7 +152,7 @@
   `total` bigint(20) unsigned DEFAULT NULL,
   `y` year(4) DEFAULT NULL,
   `t` date DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;
@@ -245,7 +245,7 @@
   `u` int(11) DEFAULT NULL,
   `v` char(16) DEFAULT 'default',
   PRIMARY KEY (`id`,`total`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 SELECT * 
 FROM t1
 ORDER BY id;
@@ -344,7 +344,7 @@
   `f` float DEFAULT '0',
   `total` bigint(20) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`total`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;
@@ -455,7 +455,7 @@
   `y` year(4) DEFAULT NULL,
   `t` date DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;
@@ -547,7 +547,7 @@
   `total` bigint(20) unsigned DEFAULT NULL,
   `y` year(4) DEFAULT NULL,
   `t` date DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;
@@ -640,7 +640,7 @@
   `u` int(11) DEFAULT NULL,
   `v` char(16) DEFAULT 'default',
   PRIMARY KEY (`id`,`total`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 SELECT * 
 FROM t1
 ORDER BY id;
@@ -739,7 +739,7 @@
   `f` float DEFAULT '0',
   `total` bigint(20) unsigned NOT NULL DEFAULT '0',
   PRIMARY KEY (`id`,`total`)
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
+) ENGINE=InnoDB DEFAULT CHARSET=latin1
 STOP SLAVE;
 RESET SLAVE;
 RESET MASTER;

mysqltest: Result content mismatch
----------------------------------------------------------------

How to repeat:
XRef: http://tinyurl.com/2446nkh http://tinyurl.com/29sopvl
[17 Aug 2010 8:57] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/115891

3109 Magne Mahre	2010-08-17
      Bug #54850 rpl_ndb.rpl_ndb_stm_innodb and 
                 rpl_ndb.rpl_ndb_2other fails
      
      The two regressions tests failed after WL#5349 was
      pushed, since they were writted with the implicit
      requirement that MyISAM is the default storage engine.
      
      Adding --default-storage-engine=MyISAM as startup
      parameter, to mimic the pre-wl#5349 situation.
     @ mysql-test/suite/rpl_ndb/t/disabled.def
        Re-enabling rpl_ndb_stm_innodb and rpl_ndb_2other
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_2other-slave.opt
        Setting MyISAM as default storage engine
        explicitly
     @ mysql-test/suite/rpl_ndb/t/rpl_ndb_stm_innodb-slave.opt
        The slave also needs to be started with
        MyISAM as default engine.
[25 Aug 2010 9:22] Bugs System 
Pushed into mysql-5.5 5.5.6-m3 (revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (version source revid:alik@ibmvm-20100825092002-2yvkb3iwu43ycpnm) (merge vers: 5.5.6-m3) (pib:20)
[25 Aug 2010 22:14] Paul DuBois 
Changes to test suite. No changelog entry needed.
[30 Aug 2010 8:30] Bugs System 
Pushed into mysql-trunk 5.6.1-m4 (revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (version source revid:alik@sun.com-20100830082732-n2eyijnv86exc5ci) (merge vers: 5.6.1-m4) (pib:21)
[30 Aug 2010 8:34] Bugs System 
Pushed into mysql-next-mr (revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (version source revid:alik@sun.com-20100830082745-n6sh01wlwh3itasv) (pib:21)