Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 connection slave;
5 call mtr.add_suppression("Can.t find record in .t[12].* error.* 1032");
6 call mtr.add_suppression("Cannot delete or update a parent row: a foreign key constraint fails .* error.* 1451");
7 call mtr.add_suppression("Cannot add or update a child row: a foreign key constraint fails .* error.* 1452");
8 call mtr.add_suppression("Duplicate entry .1. for key .PRIMARY.* error.* 1062");
9 call mtr.add_suppression("Can't find record in 't1'");
10 call mtr.add_suppression("Can't find record in 't2'");
11 connection slave;
12 set @old_slave_exec_mode= @@global.slave_exec_mode;
13 set @@global.slave_exec_mode= IDEMPOTENT;
14 connection master;
15 create table ti1 (b int primary key) engine = innodb;
16 create table ti2 (a int primary key, b int, foreign key (b) references ti1(b))
17 engine = innodb;
18 set foreign_key_checks=1 /* ensure the check */;
19 insert into ti1 values (1),(2),(3);
20 insert into ti2 set a=2, b=2;
21 connection slave;
22 select * from ti1 order by b /* must be (1),(2),(3) */;
23 b
24 1
25 2
26 3
27 insert into ti2 set a=1, b=1;
28 select * from ti2 order by b /* must be (1,1) (2,2) */;
29 a b
30 1 1
31 2 2
32 connection master;
33 set @save_binlog_format= @@session.binlog_format;
34 set @@session.binlog_format= row;
35 delete from ti1 where b=1;
36 select * from ti1 order by b /* must be (2),(3) */;
37 b
38 2
39 3
40 connection slave;
41 select * from ti1 order by b /* must stays as were on master (1),(2),(3) */;
42 b
43 1
44 2
45 3
46 delete from ti1 where b=3;
47 connection master;
48 insert into ti2 set a=3, b=3;
49 connection slave;
50 select * from ti2 order by b /* must be (1,1),(2,2) - not inserted */;
51 a b
52 1 1
53 2 2
54 connection slave;
55 set global slave_exec_mode='IDEMPOTENT';
56 set global slave_exec_mode='STRICT';
57 set global slave_exec_mode='IDEMPOTENT,STRICT';
58 ERROR 42000: Variable 'slave_exec_mode' can't be set to the value of 'IDEMPOTENT,STRICT'
59 select @@global.slave_exec_mode /* must be STRICT */;
60 @@global.slave_exec_mode
61 STRICT
62 *** foreign keys errors as above now forces to stop
63 connection master;
64 set foreign_key_checks=0;
65 drop table ti2, ti1;
66 create table ti1 (b int primary key) engine = innodb;
67 create table ti2 (a int primary key, b int, foreign key (b) references ti1(b))
68 engine = innodb;
69 set foreign_key_checks=1 /* ensure the check */;
70 insert into ti1 values (1),(2),(3);
71 insert into ti2 set a=2, b=2;
72 connection slave;
73 select * from ti1 order by b /* must be (1),(2),(3) */;
74 b
75 1
76 2
77 3
78 *** conspire future problem
79 insert into ti2 set a=1, b=1;
80 select * from ti2 order by b /* must be (1,1) (2,2) */;
81 a b
82 1 1
83 2 2
84 connection master;
85 delete from ti1 where b=1 /* offending delete event */;
86 select * from ti1 order by b /* must be (2),(3) */;
87 b
88 2
89 3
90 *** slave must stop (Trying to delete a referenced foreing key)
91 connection slave;
92 include/wait_for_slave_sql_error.inc [errno=1451]
93 Last_SQL_Error
94 1451
95 select * from ti1 order by b /* must be (1),(2),(3) - not deleted */;
96 b
97 1
98 2
99 3
100 set foreign_key_checks= 0;
101 delete from ti2 where b=1;
102 set foreign_key_checks= 1;
103 set global slave_exec_mode='IDEMPOTENT';
104 start slave sql_thread;
105 connection master;
106 connection slave;
107 set global slave_exec_mode='STRICT';
108 connection master;
109 connection slave;
110 *** conspire the following insert failure
111 *** conspire future problem
112 delete from ti1 where b=3;
113 connection master;
114 insert into ti2 set a=3, b=3 /* offending write event */;
115 *** slave must stop (Trying to insert an invalid foreign key)
116 connection slave;
117 include/wait_for_slave_sql_error.inc [errno=1452]
118 Last_SQL_Error
119 1452
120 select * from ti2 order by b /* must be (2,2) */;
121 a b
122 2 2
123 set foreign_key_checks= 0;
124 insert into ti1 set b=3;
125 set foreign_key_checks= 1;
126 set global slave_exec_mode='IDEMPOTENT';
127 start slave sql_thread;
128 connection master;
129 connection slave;
130 set global slave_exec_mode='STRICT';
131 connection master;
132 connection slave;
133 select * from ti2 order by b /* must be (2,2),(3,3) */;
134 a b
135 2 2
136 3 3
137 *** other errors
138 *** conspiring query
139 insert into ti1 set b=1;
140 connection master;
141 insert into ti1 set b=1 /* offending write event */;
142 *** slave must stop (Trying to insert a duplicate key)
143 connection slave;
144 include/wait_for_slave_sql_error.inc [errno=1062]
145 Last_SQL_Error
146 1062
147 set foreign_key_checks= 0;
148 delete from ti1 where b=1;
149 set foreign_key_checks= 1;
150 set global slave_exec_mode='IDEMPOTENT';
151 start slave sql_thread;
152 connection master;
153 connection slave;
154 set global slave_exec_mode='STRICT';
155 connection master;
156 CREATE TABLE t1 (a INT PRIMARY KEY);
157 CREATE TABLE t2 (a INT);
158 INSERT INTO t1 VALUES (-1),(-2),(-3);
159 INSERT INTO t2 VALUES (-1),(-2),(-3);
160 connection slave;
161 DELETE FROM t1 WHERE a = -2;
162 DELETE FROM t2 WHERE a = -2;
163 connection master;
164 DELETE FROM t1 WHERE a = -2;
165 *** slave must stop (Key was not found)
166 connection slave;
167 include/wait_for_slave_sql_error.inc [errno=1032]
168 Last_SQL_Error
169 1032
170 set global slave_exec_mode='IDEMPOTENT';
171 start slave sql_thread;
172 connection master;
173 connection slave;
174 set global slave_exec_mode='STRICT';
175 connection master;
176 DELETE FROM t2 WHERE a = -2;
177 *** slave must stop (Key was not found)
178 connection slave;
179 include/wait_for_slave_sql_error.inc [errno=1032]
180 Last_SQL_Error
181 1032
182 set global slave_exec_mode='IDEMPOTENT';
183 start slave sql_thread;
184 connection master;
185 connection slave;
186 set global slave_exec_mode='STRICT';
187 UPDATE t1 SET a = 1 WHERE a = -1;
188 UPDATE t2 SET a = 1 WHERE a = -1;
189 connection master;
190 UPDATE t1 SET a = 1 WHERE a = -1;
191 *** slave must stop (Key was not found)
192 connection slave;
193 include/wait_for_slave_sql_error.inc [errno=1032]
194 Last_SQL_Error
195 1032
196 set global slave_exec_mode='IDEMPOTENT';
197 start slave sql_thread;
198 connection master;
199 connection slave;
200 set global slave_exec_mode='STRICT';
201 connection master;
202 UPDATE t2 SET a = 1 WHERE a = -1;
203 *** slave must stop (Key was not found)
204 connection slave;
205 include/wait_for_slave_sql_error.inc [errno=1032]
206 Last_SQL_Error
207 1032
208 set global slave_exec_mode='IDEMPOTENT';
209 start slave sql_thread;
210 connection master;
211 connection slave;
212 SET @@global.slave_exec_mode= @old_slave_exec_mode;
213 connection master;
214 drop table t1,t2,ti2,ti1;
215 connection slave;
216 set @@global.slave_exec_mode= @old_slave_exec_mode;
217 *** end of tests
218 include/rpl_end.inc