diff options
author | Andrei <andrei.elkin@mariadb.com> | 2021-12-17 22:01:10 +0200 |
---|---|---|
committer | Andrei <andrei.elkin@mariadb.com> | 2021-12-17 22:01:10 +0200 |
commit | 479597396cf4acac304096d5c7fd75ce2b0326e8 (patch) | |
tree | 365312cf673355d8be2e500da26b0d6b4084a498 | |
parent | aba7ec58bb0cc72d85a57c5e3aa23acc18213b36 (diff) | |
download | mariadb-git-479597396cf4acac304096d5c7fd75ce2b0326e8.tar.gz |
Added show_binlog_event2 after the slave restart and synchonization.
-rw-r--r-- | mysql-test/suite/rpl/r/rpl_start_alter_restart_slave.result | 19 | ||||
-rw-r--r-- | mysql-test/suite/rpl/t/rpl_start_alter_restart_slave.test | 3 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/rpl/r/rpl_start_alter_restart_slave.result b/mysql-test/suite/rpl/r/rpl_start_alter_restart_slave.result index 002d59ff013..c4a20aceb51 100644 --- a/mysql-test/suite/rpl/r/rpl_start_alter_restart_slave.result +++ b/mysql-test/suite/rpl/r/rpl_start_alter_restart_slave.result @@ -85,6 +85,25 @@ select domain_id, seq_no from mysql.gtid_slave_pos order by seq_no desc limit 1; domain_id seq_no 0 7 # slave gtid state is 0-1-7 +# The list of events after the slave has synchronized must have both CA: +show binlog events from <binlog_start>; +Log_name Pos Event_type Server_id End_log_pos Info +slave-bin.000001 # Gtid_list 2 # [] +slave-bin.000001 # Binlog_checkpoint 2 # slave-bin.000001 +slave-bin.000001 # Gtid 1 # GTID #-#-# +slave-bin.000001 # Query 1 # use `test`; create table t1( a int primary key, b int) engine=myisam +slave-bin.000001 # Gtid 1 # GTID #-#-# +slave-bin.000001 # Query 1 # use `test`; create table t2( a int primary key, b int) engine=myisam +slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER +slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int +slave-bin.000001 # Gtid 1 # GTID #-#-# START ALTER +slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int +slave-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no> +slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int +slave-bin.000001 # Gtid 1 # GTID #-#-# COMMIT ALTER id=<seq_no> +slave-bin.000001 # Query 1 # use `test`; alter table <t> add column c int +slave-bin.000001 # Gtid 1 # GTID #-#-# +slave-bin.000001 # Query 1 # use `test`; create table t3( a int primary key, b int) engine=innodb connection master; drop table t1,t2,t3; set global binlog_alter_two_phase = No;; diff --git a/mysql-test/suite/rpl/t/rpl_start_alter_restart_slave.test b/mysql-test/suite/rpl/t/rpl_start_alter_restart_slave.test index 9c4c40484e6..4802e087885 100644 --- a/mysql-test/suite/rpl/t/rpl_start_alter_restart_slave.test +++ b/mysql-test/suite/rpl/t/rpl_start_alter_restart_slave.test @@ -101,6 +101,9 @@ if (`select $master_gtid_state <> $slave_gtid_state`) --echo Gtid state mismatch: $master_gtid_state <> $slave_gtid_state --die } +--echo # The list of events after the slave has synchronized must have both CA: +--let $replace_regexp=/alter table t[12]/alter table <t>/ /id=[0-9]+/id=<seq_no>/ +--source include/show_binlog_events2.inc --connection master drop table t1,t2,t3; |