Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mysql_upgrade.test

raw
1 #############################################################################
2 # BUG#43579 mysql_upgrade tries to alter log tables on replicated database
3 # Master and slave should be upgraded separately. All statements executed by
4 # mysql_upgrade will not be binlogged. --write-binlog and --skip-write-binlog
5 # options are added into mysql_upgrade. These options control whether sql
6 # statements are binlogged or not.
7 #############################################################################
8 --source include/not_group_replication_plugin.inc
9 --source include/master-slave.inc
10 --source include/not_valgrind.inc
11
12 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
13
14 #
15 # Special handling of the #mysql50# prefix has been removed.
16 # It is now treated as any other identifier part. I.e. it has to
17 # be quoted and will remain part of the identifier name.
18 #
19
20 connection master;
21 --disable_warnings
22 DROP DATABASE IF EXISTS `#mysql50#mysqltest-1`;
23 CREATE DATABASE `#mysql50#mysqltest-1`;
24 --enable_warnings
25 --source include/sync_slave_sql_with_master.inc
26 # Stop slave io thread before restarting master
27 --source include/stop_slave_io.inc
28
29 connection master;
30 let $before_position= query_get_value(SHOW MASTER STATUS, Position, 1);
31
32 #With '--force' option, mysql_upgrade always executes all sql statements for upgrading.
33 #binlog is disabled by default.
34 --let $rpl_server_parameters= --upgrade=FORCE
35 --let $rpl_server_number= 1
36 --let $wait_counter= 10000
37 --source include/rpl_restart_server.inc
38
39 # Restart slave io thread after restarting master server
40 connection slave;
41 --source include/start_slave_io.inc
42
43 connection master;
44 let $after_position= query_get_value(SHOW MASTER STATUS, Position, 1);
45
46 if ($before_position == $after_position)
47 {
48 echo Master position is not changed;
49 }
50
51 # Some log events of the mysql_upgrade's will cause errors on slave.
52 # And Stop slave io thread before restarting master
53 connection slave;
54 --source include/stop_slave.inc
55
56 connection master;
57 #With '--force' option, mysql_upgrade always executes all sql statements for upgrading.
58 #--write-binlog option enables binlog.
59 --let $rpl_server_parameters= --upgrade=FORCE
60 --let $rpl_server_number= 1
61 --let $wait_counter= 10000
62 --source include/rpl_restart_server.inc
63
64 connection master;
65 let $after_file= query_get_value(SHOW MASTER STATUS, File, 1);
66 let $after_position= query_get_value(SHOW MASTER STATUS, Position, 1);
67
68 if ($before_position != $after_position)
69 {
70 echo Master position has been changed;
71 }
72
73 DROP DATABASE `#mysql50#mysqltest-1`;
74 connection slave;
75 DROP DATABASE `#mysql50#mysqltest-1`;
76 --let $rpl_only_running_threads= 1
77 --source include/rpl_end.inc
78