Bug #17286 "ddl distribution across multiple binlogs" seems to fail
Submitted: 9 Feb 2006 18:58 Modified: 13 Feb 2006 13:10
Reporter: Joerg Bruehe Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.6-alpha OS:Linux (Linux (various), Solaris8+9/x86, HP-UX/ia64)
Assigned to: CPU Architecture:Any

[9 Feb 2006 18:58] Joerg Bruehe 
Description:
Release build of 5.1.6-alpha.

Symptom:
-------------------------------------------------------
*** r/ndb_binlog_ddl_multi.result
--- r/ndb_binlog_ddl_multi.reject
***************
*** 17,23
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
  master-bin.000001     #       Query   #       #       create database mysqltest
  master-bin.000001     #       Query   #       #       use `mysqltest`; create table t1 (a int primary key) engine=ndb
- master-bin.000001     #       Query   #       #       use `test`; create table t2 (a int primary key) engine=ndb
  reset master;
  reset master;
  alter table t2 add column (b int);
--- 17,22
***************
*** 55,61
  master-bin1.000001    #       Write_rows      #       #
  master-bin1.000001    #       Query   #       #       COMMIT
  master-bin1.000001    #       Query   #       #       drop database mysqltest
- master-bin1.000001    #       Query   #       #       use `test`; create table t1 (a int primary key) engine=ndb
  drop table t2;
  reset master;
  reset master;
--- 54,59
-------------------------------------------------------

Occurred:
etpglb0-5.1.log   normal
sol9x86-5.1.log   ps-protocol

How to repeat:
Found by running the test suite.
[9 Feb 2006 19:26] Joerg Bruehe 
Found only later:

-------------------------------------------------------
*** r/ndb_binlog_ddl_multi.result
--- r/ndb_binlog_ddl_multi.reject
***************
*** 90,125
  drop table t1;
  show binlog events from 102;
  Log_name      Pos     Event_type      Server_id       End_log_pos     Info
- master-bin1.000001    #       Query   #       #       CREATE LOGFILE GROUP lg1
- ADD UNDOFILE 'undofile.dat'
- INITIAL_SIZE 16M
- UNDO_BUFFER_SIZE = 1M
- ENGINE=NDB
- master-bin1.000001    #       Query   #       #       ALTER LOGFILE GROUP lg1
- ADD UNDOFILE 'undofile02.dat'
- INITIAL_SIZE = 4M
- ENGINE=NDB
- master-bin1.000001    #       Query   #       #       CREATE TABLESPACE ts1
- ADD DATAFILE 'datafile.dat'
- USE LOGFILE GROUP lg1
- INITIAL_SIZE 12M
- ENGINE NDB
- master-bin1.000001    #       Query   #       #       ALTER TABLESPACE ts1
- ADD DATAFILE 'datafile02.dat'
- INITIAL_SIZE = 4M
- ENGINE=NDB
- master-bin1.000001    #       Query   #       #       ALTER TABLESPACE ts1
- DROP DATAFILE 'datafile.dat'
- ENGINE = NDB
- master-bin1.000001    #       Query   #       #       ALTER TABLESPACE ts1
- DROP DATAFILE 'datafile02.dat'
- ENGINE = NDB
- master-bin1.000001    #       Query   #       #       DROP TABLESPACE ts1
- ENGINE = NDB
- master-bin1.000001    #       Query   #       #       DROP LOGFILE GROUP lg1
- ENGINE =NDB
- master-bin1.000001    #       Query   #       #       BEGIN
- master-bin1.000001    #       Table_map       #       #       cluster_replication.apply_status
- master-bin1.000001    #       Write_rows      #       #
- master-bin1.000001    #       Query   #       #       COMMIT
- master-bin1.000001    #       Query   #       #       use `test`; drop table `t1`
--- 90,92
-------------------------------------------------------

Occurred:
nocona-icc-glibc23-5.1.log   ps-protocol
[9 Feb 2006 19:30] Joerg Bruehe 
Even later:

-------------------------------------------------------
*** r/ndb_binlog_ddl_multi.result
--- r/ndb_binlog_ddl_multi.reject
***************
*** 39,45
  master-bin.000001     #       Table_map       #       #       cluster_replication.apply_status
  master-bin.000001     #       Write_rows      #       #
  master-bin.000001     #       Query   #       #       COMMIT
- master-bin.000001     #       Query   #       #       use `mysqltest`; drop table `t1`
  reset master;
  reset master;
  use test;
--- 39,44
-------------------------------------------------------
intelxeon3-5.1.log   normal

-------------------------------------------------------
*** r/ndb_binlog_ddl_multi.result
--- r/ndb_binlog_ddl_multi.reject
***************
*** 122,125
  master-bin1.000001    #       Table_map       #       #       cluster_replication.apply_status
  master-bin1.000001    #       Write_rows      #       #
  master-bin1.000001    #       Query   #       #       COMMIT
- master-bin1.000001    #       Query   #       #       use `test`; drop table `t1`
--- 122,124
-------------------------------------------------------
hpita2-64bit-5.1.log   normal
[13 Feb 2006 13:10] Tomas Ulin 
to be fixed in 5.1.7
[13 Mar 2014 13:34] Omer Barnir 
This bug is not scheduled to be fixed at this time.