Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_server_uuid.result

raw
1 include/master-slave.inc [rpl_server_count=3]
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Replica I/O thread .* register on source");
7 call mtr.add_suppression("Replica I/O: Source command COM_REGISTER_REPLICA failed: .*");
8 CALL mtr.add_suppression(".*source and replica have equal MySQL server UUIDs.*");
9 CALL mtr.add_suppression("Source's UUID has changed, although this should not happen unless you have changed it manually");
10 CALL mtr.add_suppression("Replica I/O: SET @master_heartbeat_period to source failed with error: Lost connection to MySQL server during query");
11 CALL mtr.add_suppression("Notifying source by SET @master_binlog_checksum= @@global.binlog_checksum failed with error");
12 CALL mtr.add_suppression("A replica with the same server_uuid/server_id as this replica has connected to the source");
13 SET @@GLOBAL.LOG_ERROR_VERBOSITY= 3;
14 include/sync_slave_sql_with_master.inc
15
16 # Case 1:
17 # Master's UUID appears in the result of 'SHOW SLAVE STATUS'.
18 # Slave's UUID appears in the result of 'SHOW SLAVE HOSTS'.
19 -----------------------------------------------------------------------------
20 include/assert.inc ["Slave's SHOW SLAVE HOST should contain the correct value for master's server_uuid]
21 include/assert.inc [Master's SHOW SLAVE HOSTS should contain the correct value for slave's server_uuid]
22
23 # Case 2:
24 # After executing 'STOP SLAVE [IO_THREAD|SQL_THREAD]' successfully, Master's UUID
25 # is still kept into Slave status.
26 -----------------------------------------------------------------------------
27 include/stop_slave_io.inc
28 include/check_slave_param.inc [Slave_IO_Running]
29 include/stop_slave_sql.inc
30 include/check_slave_param.inc [Slave_SQL_Running]
31 include/start_slave.inc
32 include/stop_slave.inc
33 include/check_slave_param.inc [Slave_IO_Running]
34
35 # Case 3:
36 # Slave generates an error and aborts, if master's UUID is
37 # equal to slave's UUID unless --replicate-same-server-id
38 # option is set.
39 -----------------------------------------------------------------------------
40 include/rpl_restart_server.inc [server_number=1]
41 START SLAVE IO_THREAD;
42 Warnings:
43 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
44 include/wait_for_slave_io_error.inc [errno=13117]
45 include/rpl_restart_server.inc [server_number=1]
46
47 # server_3 is running with --replicate-same-server-id option
48 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1',
49 SOURCE_PORT= MASTER_PORT,
50 SOURCE_USER= 'root',
51 SOURCE_LOG_FILE='master-bin.000001';
52 Warnings:
53 Warning #### CHANGE REPLICATION SOURCE TO with a SOURCE_LOG_FILE clause but no SOURCE_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
54 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
55 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
56 include/start_slave.inc
57 include/check_slave_no_error.inc
58 include/sync_slave_sql_with_master.inc
59 include/stop_slave.inc
60 include/rpl_restart_server.inc [server_number=1]
61
62 # Case 4:
63 # When executing 'CHANGE MASTER ...', master's UUID and server_id will be
64 # cleared if master_host or/and master_port are changed.
65 # Master's UUID and server_id will not be cleared if both master_port
66 # and master_host are not changed.
67 -----------------------------------------------------------------------------
68 include/start_slave_io.inc
69 include/wait_for_slave_param.inc [Master_UUID]
70 include/stop_slave.inc
71
72 # Only change MASTER_PORT
73 CHANGE REPLICATION SOURCE TO SOURCE_PORT= 1111;
74 include/check_slave_param.inc [Master_UUID]
75 include/check_slave_param.inc [Master_Server_Id]
76 CHANGE REPLICATION SOURCE TO SOURCE_PORT= MASTER_PORT,
77 SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
78 include/start_slave_io.inc
79 include/wait_for_slave_param.inc [Master_UUID]
80
81 # Only change MASTER_HOST
82 STOP SLAVE IO_THREAD;
83 Warnings:
84 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
85 include/wait_for_slave_io_to_stop.inc
86 CHANGE REPLICATION SOURCE TO SOURCE_HOST= 'localhost';
87 include/check_slave_param.inc [Master_UUID]
88 include/check_slave_param.inc [Master_Server_Id]
89 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1',
90 SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
91 include/start_slave_io.inc
92 include/wait_for_slave_param.inc [Master_UUID]
93
94 # Both MASTER_HOST and MASTER_PORT are changed
95 STOP SLAVE IO_THREAD;
96 Warnings:
97 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
98 include/wait_for_slave_io_to_stop.inc
99 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= 1111;
100 include/check_slave_param.inc [Master_UUID]
101 include/check_slave_param.inc [Master_Server_Id]
102 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT,
103 SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
104 include/start_slave_io.inc
105 include/wait_for_slave_param.inc [Master_UUID]
106
107 # Both MASTER_HOST and MASTER_PORT are NOT changed
108 STOP SLAVE IO_THREAD;
109 Warnings:
110 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
111 include/wait_for_slave_io_to_stop.inc
112 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT;
113 include/check_slave_param.inc [Slave_IO_Running]
114 CHANGE REPLICATION SOURCE TO
115 SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
116 include/check_slave_param.inc [Slave_IO_Running]
117
118 # Case 5:
119 # After executing 'RESET SLAVE' successfully, Master's UUID is still kept
120 # into Slave status.
121 -----------------------------------------------------------------------------
122 RESET SLAVE;
123 Warnings:
124 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
125 include/check_slave_param.inc [Slave_IO_Running]
126 CHANGE REPLICATION SOURCE TO
127 SOURCE_LOG_FILE= 'MASTER_LOG_FILE', SOURCE_LOG_POS= MASTER_POS;
128 include/start_slave.inc
129
130 # Case 6:
131 # In an existing master-slave replication forum (M->S1), if another
132 # slave (S2) with the same UUID as S1 joins the forum and connects
133 # to Master(M), the master will throw an error to the first slave
134 # connection that will not try to reconnect.
135 -----------------------------------------------------------------------------
136 include/rpl_restart_server.inc [server_number=3]
137 [connection server_2]
138 include/wait_for_slave_io_error.inc [errno=13114]
139 include/assert_grep.inc [Found the expected line in master's error log for server 2 disconnection]
140 include/start_slave_io.inc
141 [connection server_3]
142 include/wait_for_slave_io_error.inc [errno=13114]
143 include/assert_grep.inc [Found the expected line in master's error log for server 3 disconnection]
144 include/assert_grep.inc [Found the expected line in server 2 error log]
145 include/assert_grep.inc [Found the expected line in server 3 error log]
146 include/rpl_restart_server.inc [server_number=3]
147 include/stop_slave.inc
148 [connection master]
149 SET @@GLOBAL.log_error_verbosity= OLD_LOG_ERROR_VERBOSITY;
150 include/rpl_end.inc