Debian Codegraph @

mysql-test/suite/rpl/r/rpl_multi_source_channel_map_stress.result

raw
1 include/master-slave.inc
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 [connection slave]
7 CALL mtr.add_suppression('Replica failed to initialize connection metadata structure from the repository');
8 CALL mtr.add_suppression('This operation cannot be performed with a running replica');
9 CALL mtr.add_suppression('Could not find target log file mentioned in applier metadata in the index file');
10 CALL mtr.add_suppression('Could not find relay log file');
11 CALL mtr.add_suppression('A replica with the same server_uuid/server_id as this replica has connected to the source');
12 SET @saved_event_scheduler= @@GLOBAL.event_scheduler;
13 SET @saved_relay_log_purge= @@GLOBAL.relay_log_purge;
14 SET @@GLOBAL.event_scheduler= OFF;
15 include/stop_slave.inc
16 CREATE EVENT e_change_master_io_ch0 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL '';
17 CREATE EVENT e_change_master_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin.000001', RELAY_LOG_POS=4 FOR CHANNEL '';
18 CREATE EVENT e_start_slave_io_ch0 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL '';
19 Warnings:
20 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
21 CREATE EVENT e_stop_slave_io_ch0 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL '';
22 Warnings:
23 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
24 CREATE EVENT e_reset_slave_ch0 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL '';
25 Warnings:
26 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
27 CREATE EVENT e_reset_slave_all_ch0 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL '';
28 Warnings:
29 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
30 CREATE EVENT e_start_slave_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL '';
31 Warnings:
32 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
33 CREATE EVENT e_stop_slave_sql_ch0 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL '';
34 Warnings:
35 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
36 CREATE EVENT e_sss_ch0 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL '';
37 Warnings:
38 Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
39 CREATE EVENT e_reset_master ON SCHEDULE EVERY 1 SECOND DO RESET MASTER;
40 CREATE EVENT e_ils ON SCHEDULE EVERY 1 SECOND DO SELECT * FROM performance_schema.log_status;
41 CREATE EVENT e_change_master_io_ch1 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL 'ch1';
42 CREATE EVENT e_change_master_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin-ch1.000001', RELAY_LOG_POS=4 FOR CHANNEL 'ch1';
43 CREATE EVENT e_start_slave_io_ch1 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL 'ch1';
44 Warnings:
45 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
46 CREATE EVENT e_stop_slave_io_ch1 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL 'ch1';
47 Warnings:
48 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
49 CREATE EVENT e_reset_slave_ch1 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL 'ch1';
50 Warnings:
51 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
52 CREATE EVENT e_reset_slave_all_ch1 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL 'ch1';
53 Warnings:
54 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
55 CREATE EVENT e_start_slave_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL 'ch1';
56 Warnings:
57 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
58 CREATE EVENT e_stop_slave_sql_ch1 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL 'ch1';
59 Warnings:
60 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
61 CREATE EVENT e_sss_ch1 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL 'ch1';
62 Warnings:
63 Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
64 CREATE EVENT e_change_master_io_ch2 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT FOR CHANNEL 'ch2';
65 CREATE EVENT e_change_master_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE='slave-relay-bin-ch2.000001', RELAY_LOG_POS=4 FOR CHANNEL 'ch2';
66 CREATE EVENT e_start_slave_io_ch2 ON SCHEDULE EVERY 1 SECOND DO START SLAVE IO_THREAD FOR CHANNEL 'ch2';
67 Warnings:
68 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
69 CREATE EVENT e_stop_slave_io_ch2 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE IO_THREAD FOR CHANNEL 'ch2';
70 Warnings:
71 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
72 CREATE EVENT e_reset_slave_ch2 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE FOR CHANNEL 'ch2';
73 Warnings:
74 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
75 CREATE EVENT e_reset_slave_all_ch2 ON SCHEDULE EVERY 1 SECOND DO RESET SLAVE ALL FOR CHANNEL 'ch2';
76 Warnings:
77 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
78 CREATE EVENT e_start_slave_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO START SLAVE SQL_THREAD FOR CHANNEL 'ch2';
79 Warnings:
80 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
81 CREATE EVENT e_stop_slave_sql_ch2 ON SCHEDULE EVERY 1 SECOND DO STOP SLAVE SQL_THREAD FOR CHANNEL 'ch2';
82 Warnings:
83 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
84 CREATE EVENT e_sss_ch2 ON SCHEDULE EVERY 1 SECOND DO SHOW SLAVE STATUS FOR CHANNEL 'ch2';
85 Warnings:
86 Warning 1287 'SHOW SLAVE STATUS' is deprecated and will be removed in a future release. Please use SHOW REPLICA STATUS instead
87 SET @@GLOBAL.event_scheduler= ON;
88 Let the requests to run in parallel for 10 seconds
89 DROP EVENT e_sss_ch2;
90 DROP EVENT e_stop_slave_sql_ch2;
91 DROP EVENT e_start_slave_sql_ch2;
92 DROP EVENT e_reset_slave_all_ch2;
93 DROP EVENT e_reset_slave_ch2;
94 DROP EVENT e_stop_slave_io_ch2;
95 DROP EVENT e_start_slave_io_ch2;
96 DROP EVENT e_change_master_sql_ch2;
97 DROP EVENT e_change_master_io_ch2;
98 DROP EVENT e_sss_ch1;
99 DROP EVENT e_stop_slave_sql_ch1;
100 DROP EVENT e_start_slave_sql_ch1;
101 DROP EVENT e_reset_slave_all_ch1;
102 DROP EVENT e_reset_slave_ch1;
103 DROP EVENT e_stop_slave_io_ch1;
104 DROP EVENT e_start_slave_io_ch1;
105 DROP EVENT e_change_master_sql_ch1;
106 DROP EVENT e_change_master_io_ch1;
107 DROP EVENT e_ils;
108 DROP EVENT e_reset_master;
109 DROP EVENT e_sss_ch0;
110 DROP EVENT e_stop_slave_sql_ch0;
111 DROP EVENT e_start_slave_sql_ch0;
112 DROP EVENT e_reset_slave_all_ch0;
113 DROP EVENT e_reset_slave_ch0;
114 DROP EVENT e_stop_slave_io_ch0;
115 DROP EVENT e_start_slave_io_ch0;
116 DROP EVENT e_change_master_sql_ch0;
117 DROP EVENT e_change_master_io_ch0;
118 SET @@GLOBAL.event_scheduler= OFF;
119 # Wait until all scheduler activity has finished
120 STOP SLAVE FOR CHANNEL 'ch2';
121 STOP SLAVE FOR CHANNEL 'ch1';
122 STOP SLAVE FOR CHANNEL '';
123 RESET SLAVE ALL;
124 CHANGE REPLICATION SOURCE TO SOURCE_USER='root', SOURCE_HOST='127.0.0.1', SOURCE_PORT=SOURCE_PORT;
125 SET @@GLOBAL.event_scheduler = @saved_event_scheduler;
126 SET @@GLOBAL.relay_log_purge = @saved_relay_log_purge;
127 include/start_slave.inc
128 include/rpl_end.inc