No error when slave has MASTER_USE_GTID=NO on a binlog-in-engine master

# A BiE master can only serve a dump request that starts from a GTID position

# ("GTID starting position is required on master with --binlog-storage-engine

# enabled"). The plan expects a clear error at CHANGE MASTER or START SLAVE.

#

# This test records what actually happens today:

#   - CHANGE MASTER and START SLAVE both succeed silently

#   - the IO thread never connects, and keeps retrying with no backoff

#   - SHOW SLAVE STATUS shows no error (Last_IO_Errno = 0)

#   - nothing replicates

# Lines marked "BUG" below are the ones that should change when the server

# reports the GTID requirement properly.  A GTID-based slave on the same

# master recovers and catches up (control).

#

--source include/have_innodb_binlog.inc

--source include/master-slave.inc

--connection slave

call mtr.add_suppression("GTID starting position is required on master");

call mtr.add_suppression("Error reading packet from server");

--connection master

CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;

INSERT INTO t1 VALUES (1);

--sync_slave_with_master

--echo #

--echo # Switch the slave to MASTER_USE_GTID=NO at the start of the BiE binlog

--echo #

--connection slave

--source include/stop_slave.inc

CHANGE MASTER TO MASTER_USE_GTID=NO, MASTER_LOG_FILE='binlog-000000.ibb', MASTER_LOG_POS=4;

--echo # BUG: CHANGE MASTER above and START SLAVE below succeed without any error

START SLAVE;

--connection master

INSERT INTO t1 VALUES (2);

--connection slave

# The IO thread keeps reconnecting; wait until the slave error log shows a few

# failed attempts.

--let SEARCH_FILE= $MYSQLTEST_VARDIR/log/mysqld.2.err

perl;

  use Time::HiRes qw(sleep);

  my $f= $ENV{SEARCH_FILE};

  for (1..300) {

    open(F, $f) or die "$f: $!";

    my $n= grep { /GTID starting position is required on master/ } <F>;

    close(F);

    exit 0 if $n >= 3;

    sleep(0.1);

  }

  die "Timeout waiting for the 4246 error in $f\n";

EOF

--echo # The slave log reports the GTID requirement, repeatedly

--let $io_running= query_get_value(SHOW SLAVE STATUS, Slave_IO_Running, 1)

--let $io_errno= query_get_value(SHOW SLAVE STATUS, Last_IO_Errno, 1)

--let $using_gtid= query_get_value(SHOW SLAVE STATUS, Using_Gtid, 1)

--echo # Using_Gtid: $using_gtid

--let $not_running= `SELECT '$io_running' != 'Yes'`

--echo # IO thread not running: $not_running

--echo # BUG: Last_IO_Errno is $io_errno (the 4246 error is only in the error log)

SELECT COUNT(*) AS rows_on_slave FROM t1;

--echo #

--echo # Control: switching back to GTID positioning recovers

--echo #

--source include/stop_slave.inc

CHANGE MASTER TO MASTER_USE_GTID=slave_pos;

--source include/start_slave.inc

--connection master

--sync_slave_with_master

SELECT COUNT(*) AS rows_on_slave FROM t1;

--connection master

DROP TABLE t1;

--source include/rpl_end.inc