Debian Codegraph @

mysql-test/suite/rpl_nogtid/r/rpl_parallel_start_stop.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 test.t1");
7 call mtr.add_suppression("Replica SQL for channel '':.* Could not execute Update_rows event on table d1.t1; Deadlock found when trying to get lock");
8 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
9 create view worker_proc_list as SELECT id from Information_Schema.processlist
10 where state like 'Waiting for an event from Coordinator';
11 create view coord_proc_list as SELECT id from Information_Schema.processlist where state like 'Replica has read all relay log%';
12 include/stop_slave.inc
13 set @save.replica_parallel_workers= @@global.replica_parallel_workers;
14 set @@global.replica_parallel_workers= 4;
15 include/start_slave.inc
16 select min(id) from worker_proc_list into @w_id;
17 Warnings:
18 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
19 kill query @w_id;
20 include/wait_for_slave_sql_to_stop.inc
21 include/start_slave.inc
22 select id from coord_proc_list into @c_id;
23 Warnings:
24 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
25 kill query @c_id;
26 include/wait_for_slave_sql_error.inc [errno=1756]
27 include/start_slave.inc
28 CREATE TABLE t1 (a int primary key) engine=innodb;
29 insert into t1 values (1),(2);
30 include/sync_slave_sql_with_master.inc
31 insert into t1 values (3);
32 insert into t1 values (3);
33 include/wait_for_slave_sql_to_stop.inc
34 delete from t1 where a=3;
35 set @save.replica_transaction_retries= @@global.replica_transaction_retries;
36 set @@global.replica_transaction_retries= 10;
37 include/start_slave.inc
38 include/sync_slave_sql_with_master.inc
39 delete from t1;
40 include/sync_slave_sql_with_master.inc
41 insert into t1 values (1),(2),(3);
42 create table t2m (a int) engine=myisam;
43 insert into t2m values (1);
44 include/sync_slave_sql_with_master.inc
45 begin;
46 update t1 set a=31 where a=3;
47 insert into t1 values (5),(6),(7);
48 update t1 set a=a+10;
49 begin;
50 update t1 set a=20 where a=2;
51 insert into t2m values (2);
52 update t1 set a=30 where a=3;
53 commit;
54 update t1 set a=21 where a=2;
55 rollback;
56 include/sync_slave_sql_with_master.inc
57 stop slave sql_thread;
58 Warnings:
59 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
60 set @@global.sql_replica_skip_counter=7;
61 begin;
62 select max(a) + 1 from t1 into @a;
63 insert into t1 set a=@a;
64 commit;
65 begin;
66 select max(a) + 1 from t1 into @a;
67 insert into t1 set a=@a;
68 commit;
69 begin;
70 select max(a) + 1 from t1 into @a;
71 insert into t1 set a=@a;
72 commit;
73 start slave sql_thread;
74 Warnings:
75 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
76 include/sync_slave_sql_with_master.inc
77 include/stop_slave.inc
78 create table t2 (a int);
79 insert into t2 values (1);
80 start slave until SOURCE_LOG_FILE='master-bin.000001', SOURCE_LOG_POS=MASTER_LOG_POS;
81 Warnings:
82 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
83 include/wait_for_slave_sql_to_stop.inc
84 include/start_slave.inc
85 drop table t1;
86 drop table t2m;
87 drop table t2;
88 include/sync_slave_sql_with_master.inc
89 drop view worker_proc_list;
90 drop view coord_proc_list;
91 set @@global.replica_transaction_retries= 0;
92 include/stop_slave.inc
93 start slave until sql_after_mts_gaps relay_log_file='dummy';
94 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'relay_log_file='dummy'' at line 1
95 start slave until sql_after_mts_gaps relay_log_pos=0;
96 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'relay_log_pos=0' at line 1
97 start slave until sql_after_mts_gaps SOURCE_LOG_FILE='dummy';
98 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SOURCE_LOG_FILE='dummy'' at line 1
99 start slave until sql_after_mts_gaps SOURCE_LOG_POS=0;
100 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SOURCE_LOG_POS=0' at line 1
101 start slave until sql_after_mts_gaps SQL_BEFORE_GTIDS='dummy';
102 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_BEFORE_GTIDS='dummy'' at line 1
103 call mtr.add_suppression('Replica SQL for channel '': Could not execute Update_rows event on table d1.t1; Deadlock found when trying to get lock');
104 include/start_slave.inc
105 create database d1;
106 create database d2;
107 create table d1.t1 (a int primary key) engine=innodb;
108 create table d2.t1 (a int primary key) engine=innodb;
109 create table d1.t2m (a int) engine=myisam;
110 insert into d1.t1 values (1),(2),(3);
111 insert into d2.t1 values (1),(2),(3);
112 insert into d1.t2m values (1);
113 include/sync_slave_sql_with_master.inc
114 begin;
115 update d1.t1 set a=31 where a=3;
116 insert into d1.t1 values (5),(6),(7);
117 begin;
118 update d1.t1 set a=20 where a=2;
119 insert into d1.t2m values (2);
120 update d1.t1 set a=30 where a=3;
121 insert into d1.t1 values (4);
122 begin;
123 delete from d2.t1;
124 commit;
125 commit;
126 delete from d1.t1;
127 update d1.t1 set a=21 where a=2;
128 include/wait_for_slave_sql_error.inc [errno=1213, 1205]
129 rollback;
130 start slave until sql_after_mts_gaps;
131 Warnings:
132 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
133 include/wait_for_slave_sql_to_stop.inc
134 set @@global.replica_parallel_workers= @save.replica_parallel_workers;
135 include/start_slave.inc
136 drop database d1;
137 drop database d2;
138 include/sync_slave_sql_with_master.inc
139 set @@global.replica_transaction_retries= @save.replica_transaction_retries;
140 include/rpl_end.inc