Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_mixed_binlog_max_cache_size.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 CHANGE MASTER TO MASTER_USE_GTID=NO;
6 include/start_slave.inc
7 connection master;
8 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
9 call mtr.add_suppression("Write to binary log failed: Multi-row statements required more than .max_binlog_stmt_cache_size");
10 call mtr.add_suppression("Write to binary log failed: Multi-statement transaction required more than .max_binlog_cache_size");
11 SET GLOBAL max_binlog_cache_size = 4096;
12 SET GLOBAL binlog_cache_size = 4096;
13 SET GLOBAL max_binlog_stmt_cache_size = 4096;
14 SET GLOBAL binlog_stmt_cache_size = 4096;
15 disconnect master;
16 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
17 CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb CHARSET=latin1;
18 CREATE TABLE t2(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=MyIsam CHARSET=latin1;
19 CREATE TABLE t3(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb CHARSET=latin1;
20 ########################################################################################
21 # 1 - SINGLE STATEMENT
22 ########################################################################################
23 connection master;
24 *** Single statement on transactional table ***
25 Got one of the listed errors
26 *** Single statement on non-transactional table ***
27 Got one of the listed errors
28 include/wait_for_slave_sql_error_and_skip.inc [errno=1590]
29 *** Single statement on both transactional and non-transactional tables. ***
30 Got one of the listed errors
31 include/wait_for_slave_sql_error_and_skip.inc [errno=1590]
32 include/diff_tables.inc [master:t1,slave:t1]
33 ########################################################################################
34 # 2 - BEGIN - IMPLICIT COMMIT by DDL
35 ########################################################################################
36 connection master;
37 TRUNCATE TABLE t1;
38 TRUNCATE TABLE t2;
39 TRUNCATE TABLE t3;
40 set default_storage_engine=innodb;
41 BEGIN;
42 Got one of the listed errors
43 Got one of the listed errors
44 Got one of the listed errors
45 INSERT INTO t1 (a, data) VALUES (7, 's');;
46 INSERT INTO t2 (a, data) VALUES (8, 's');;
47 INSERT INTO t1 (a, data) VALUES (9, 's');;
48 ALTER TABLE t3 ADD COLUMN d int;
49 BEGIN;
50 Got one of the listed errors
51 Got one of the listed errors
52 INSERT INTO t1 (a, data) VALUES (19, 's');;
53 INSERT INTO t2 (a, data) VALUES (20, 's');;
54 INSERT INTO t1 (a, data) VALUES (21, 's');;
55 CREATE TABLE t4 SELECT * FROM t1;
56 BEGIN;
57 Got one of the listed errors
58 Got one of the listed errors
59 INSERT INTO t1 (a, data) VALUES (27, 's');;
60 INSERT INTO t2 (a, data) VALUES (28, 's');;
61 INSERT INTO t1 (a, data) VALUES (29, 's');;
62 CREATE TABLE t5 (a int);
63 connection slave;
64 include/diff_tables.inc [master:t1,slave:t1]
65 ########################################################################################
66 # 3 - BEGIN - COMMIT
67 ########################################################################################
68 connection master;
69 TRUNCATE TABLE t1;
70 TRUNCATE TABLE t2;
71 TRUNCATE TABLE t3;
72 BEGIN;
73 Got one of the listed errors
74 Got one of the listed errors
75 Got one of the listed errors
76 COMMIT;
77 connection slave;
78 include/diff_tables.inc [master:t1,slave:t1]
79 ########################################################################################
80 # 4 - BEGIN - ROLLBACK
81 ########################################################################################
82 connection master;
83 TRUNCATE TABLE t1;
84 TRUNCATE TABLE t2;
85 TRUNCATE TABLE t3;
86 BEGIN;
87 Got one of the listed errors
88 Got one of the listed errors
89 Got one of the listed errors
90 ROLLBACK;
91 Warnings:
92 Warning 1196 Some non-transactional changed tables couldn't be rolled back
93 connection slave;
94 include/diff_tables.inc [master:t1,slave:t1]
95 ########################################################################################
96 # 5 - PROCEDURE
97 ########################################################################################
98 connection master;
99 TRUNCATE TABLE t1;
100 TRUNCATE TABLE t2;
101 TRUNCATE TABLE t3;
102 CREATE PROCEDURE p1(pd VARCHAR(30000) CHARACTER SET latin1)
103 BEGIN
104 INSERT INTO t1 (a, data) VALUES (1, pd);
105 INSERT INTO t1 (a, data) VALUES (2, pd);
106 INSERT INTO t1 (a, data) VALUES (3, pd);
107 INSERT INTO t1 (a, data) VALUES (4, pd);
108 INSERT INTO t1 (a, data) VALUES (5, 's');
109 END//
110 TRUNCATE TABLE t1;
111 TRUNCATE TABLE t1;
112 BEGIN;
113 Got one of the listed errors
114 COMMIT;
115 TRUNCATE TABLE t1;
116 BEGIN;
117 Got one of the listed errors
118 ROLLBACK;
119 connection slave;
120 include/diff_tables.inc [master:t1,slave:t1]
121 ########################################################################################
122 # 6 - XID
123 ########################################################################################
124 connection master;
125 TRUNCATE TABLE t1;
126 TRUNCATE TABLE t2;
127 TRUNCATE TABLE t3;
128 BEGIN;
129 Got one of the listed errors
130 Got one of the listed errors
131 Got one of the listed errors
132 INSERT INTO t1 (a, data) VALUES (7, 's');;
133 INSERT INTO t2 (a, data) VALUES (8, 's');;
134 INSERT INTO t1 (a, data) VALUES (9, 's');;
135 ROLLBACK TO sv;
136 Warnings:
137 Warning 1196 Some non-transactional changed tables couldn't be rolled back
138 COMMIT;
139 connection slave;
140 include/diff_tables.inc [master:t1,slave:t1]
141 ########################################################################################
142 # 7 - NON-TRANS TABLE
143 ########################################################################################
144 connection master;
145 TRUNCATE TABLE t1;
146 TRUNCATE TABLE t2;
147 TRUNCATE TABLE t3;
148 BEGIN;
149 Got one of the listed errors
150 Got one of the listed errors
151 Got one of the listed errors
152 INSERT INTO t1 (a, data) VALUES (8, 's');;
153 INSERT INTO t1 (a, data) VALUES (9, 's');;
154 INSERT INTO t2 (a, data) VALUES (10, 's');;
155 INSERT INTO t1 (a, data) VALUES (11, 's');;
156 COMMIT;
157 BEGIN;
158 Got one of the listed errors
159 COMMIT;
160 connection slave;
161 include/diff_tables.inc [master:t1,slave:t1]
162 ########################################################################
163 # 8 - Bug#55375(Regression Bug) Transaction bigger than
164 # max_binlog_cache_size crashes slave
165 ########################################################################
166 # [ On Slave ]
167 SET GLOBAL max_binlog_cache_size = 4096;
168 SET GLOBAL binlog_cache_size = 4096;
169 SET GLOBAL max_binlog_stmt_cache_size = 4096;
170 SET GLOBAL binlog_stmt_cache_size = 4096;
171 include/stop_slave.inc
172 include/start_slave.inc
173 CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage.*");
174 CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_stmt_cache_size' bytes of storage.*");
175 CALL mtr.add_suppression("Writing one row to the row-based binary log failed.*");
176 CALL mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occurred on the master. Message: error writing to the binary log");
177 connection master;
178 TRUNCATE t1;
179 connection slave;
180 connection master;
181 SET GLOBAL max_binlog_cache_size= ORIGINAL_VALUE;
182 SET GLOBAL binlog_cache_size= ORIGINAL_VALUE;
183 SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
184 SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;
185 disconnect master;
186 connect master,127.0.0.1,root,,test,$MASTER_MYPORT,;
187 BEGIN;
188 Repeat statement 'INSERT INTO t1 VALUES($n, repeat("a", 32))' 128 times
189 COMMIT;
190 connection slave;
191 include/wait_for_slave_sql_error.inc [errno=1197]
192 SELECT count(*) FROM t1;
193 count(*)
194 0
195 include/show_binlog_events.inc
196 SET GLOBAL max_binlog_cache_size= ORIGINAL_VALUE;
197 SET GLOBAL binlog_cache_size= ORIGINAL_VALUE;
198 SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
199 SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;
200 include/stop_slave_io.inc
201 include/start_slave.inc
202 connection master;
203 connection slave;
204 SELECT count(*) FROM t1;
205 count(*)
206 128
207 ########################################################################################
208 # CLEAN
209 ########################################################################################
210 connection master;
211 DROP TABLE t1;
212 DROP TABLE t2;
213 DROP TABLE t3;
214 DROP TABLE IF EXISTS t4;
215 DROP TABLE t5;
216 DROP PROCEDURE p1;
217 include/rpl_end.inc