Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_parallel_change_master.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 call mtr.add_suppression("Replica SQL for channel '': .*Could not execute Write_rows event on table d1.t1; Duplicate entry '13' for key .*");
7 call mtr.add_suppression("Replica SQL for channel '': ... The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state.");
8 call mtr.add_suppression("Error writing relay log configuration.");
9 include/stop_slave.inc
10 SET @save.replica_parallel_workers=@@global.replica_parallel_workers;
11 SET @@global.replica_parallel_workers=2;
12 include/start_slave.inc
13 CREATE DATABASE d1;
14 CREATE DATABASE d2;
15 CREATE TABLE d1.t1 (a int unique) ENGINE=INNODB;
16 CREATE TABLE d2.t1 (a int unique) ENGINE=INNODB;
17 INSERT INTO d1.t1 VALUES (1);
18 FLUSH LOGS;
19 include/sync_slave_sql_with_master.inc
20 include/stop_slave.inc
21 CHANGE REPLICATION SOURCE TO SOURCE_DELAY=5;
22 include/start_slave.inc
23 INSERT INTO d1.t1 VALUES (3);
24 INSERT INTO d1.t1 VALUES (5);
25 FLUSH LOGS;
26 include/stop_slave.inc
27 CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE=FILE, RELAY_LOG_POS= POS;
28 include/start_slave.inc
29 include/stop_slave.inc
30 CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE=FILE, RELAY_LOG_POS= POS, SOURCE_DELAY=0;
31 include/start_slave.inc
32 BEGIN;
33 INSERT INTO d1.t1 VALUES (13);
34 INSERT INTO d1.t1 VALUES (6);
35 INSERT INTO d2.t1 VALUES (7);
36 BEGIN;
37 INSERT INTO d1.t1 VALUES (13);
38 BEGIN;
39 INSERT INTO d2.t1 VALUES (8);
40 COMMIT;
41 COMMIT;
42 INSERT INTO d2.t1 VALUES (9);
43 COMMIT;
44 include/wait_for_slave_sql_error.inc [errno=1062]
45 include/stop_slave_io.inc
46 CHANGE REPLICATION SOURCE TO RELAY_LOG_FILE=FILE, RELAY_LOG_POS= POS;
47 ERROR HY000: CHANGE REPLICATION SOURCE cannot be executed when the replica was stopped with an error or killed in MTA mode. Consider using RESET REPLICA or START REPLICA UNTIL.
48 SET @@global.replica_parallel_workers= @save.replica_parallel_workers;
49 include/rpl_restart_server.inc [server_number=2 parameters: --relay-log-recovery --skip-replica-start]
50 SELECT @@global.relay_log_recovery as 'must be ON';
51 must be ON
52 1
53 call mtr.add_suppression("MTA recovery: automatic recovery failed.*");
54 call mtr.add_suppression("Failed to initialize the connection metadata structure");
55 call mtr.add_suppression("Failed to create or recover replication info repositories.");
56 call mtr.add_suppression("It is not possible to change the type of the relay log repository because there are workers repositories with possible execution gaps. The value of --relay_log_info_repository is altered to one of the found Worker repositories");
57 include/rpl_restart_server.inc [server_number=2 parameters: --skip-replica-start]
58 SELECT @@global.relay_log_recovery as 'must be OFF';
59 must be OFF
60 0
61 DELETE FROM d1.t1 WHERE a = 13;
62 include/start_slave.inc
63 DROP DATABASE d1;
64 DROP DATABASE d2;
65 include/sync_slave_sql_with_master.inc
66 [connection slave]
67 include/stop_slave.inc
68 SET @save.replica_parallel_workers=@@global.replica_parallel_workers;
69 SET @@global.replica_parallel_workers=2;
70 SET @save.relay_log_info_repository=@@global.relay_log_info_repository;
71 Warnings:
72 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
73 SET @@global.relay_log_info_repository='TABLE';
74 Warnings:
75 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
76 include/start_slave.inc
77 [connection master]
78 CREATE DATABASE d1;
79 CREATE DATABASE d2;
80 CREATE TABLE d1.t1 (a int unique) ENGINE=INNODB;
81 CREATE TABLE d2.t1 (a int unique) ENGINE=INNODB;
82 include/sync_slave_sql_with_master.inc
83 BEGIN;
84 INSERT INTO d1.t1 VALUES (13);
85 [connection master]
86 INSERT INTO d1.t1 VALUES (6);
87 INSERT INTO d2.t1 VALUES (7);
88 BEGIN;
89 INSERT INTO d1.t1 VALUES (13);
90 BEGIN;
91 INSERT INTO d2.t1 VALUES (8);
92 COMMIT;
93 COMMIT;
94 INSERT INTO d2.t1 VALUES (9);
95 [connection slave1]
96 [connection slave]
97 COMMIT;
98 include/wait_for_slave_sql_error.inc [errno=1062]
99 include/stop_slave_io.inc
100 [connection master]
101 FLUSH LOGS;
102 [connection slave]
103 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT, SOURCE_USER= 'root',SOURCE_LOG_FILE = 'FILE', SOURCE_LOG_POS = POS ;
104 ERROR HY000: CHANGE REPLICATION SOURCE cannot be executed when the replica was stopped with an error or killed in MTA mode. Consider using RESET REPLICA or START REPLICA UNTIL.
105 reset slave;
106 Warnings:
107 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
108 CHANGE REPLICATION SOURCE TO SOURCE_HOST= '127.0.0.1', SOURCE_PORT= MASTER_PORT, SOURCE_USER= 'root',SOURCE_LOG_FILE = 'FILE', SOURCE_LOG_POS = POS ;
109 Warnings:
110 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
111 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.
112 SET @@global.replica_parallel_workers= @save.replica_parallel_workers;
113 SET @@global.relay_log_info_repository= @save.relay_log_info_repository;
114 include/start_slave.inc
115 [connection master]
116 DROP DATABASE d1;
117 DROP DATABASE d2;
118 include/rpl_end.inc