1
include/master-slave.inc
3
call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
4
SET GLOBAL max_binlog_cache_size = 4096;
5
SET GLOBAL binlog_cache_size = 4096;
6
SET GLOBAL max_binlog_stmt_cache_size = 4096;
7
SET GLOBAL binlog_stmt_cache_size = 4096;
8
CREATE TABLE t1(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb;
9
CREATE TABLE t2(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=MyIsam;
10
CREATE TABLE t3(a INT PRIMARY KEY, data VARCHAR(30000)) ENGINE=Innodb;
11
########################################################################################
12
# 1 - SINGLE STATEMENT
13
########################################################################################
14
*** Single statement on transactional table ***
15
Got one of the listed errors
16
*** Single statement on non-transactional table ***
17
Got one of the listed errors
18
include/wait_for_slave_sql_error_and_skip.inc [errno=1590]
19
*** Single statement on both transactional and non-transactional tables. ***
20
Got one of the listed errors
21
include/wait_for_slave_sql_error_and_skip.inc [errno=1590]
22
include/diff_tables.inc [master:t1,slave:t1]
23
########################################################################################
24
# 2 - BEGIN - IMPLICIT COMMIT by DDL
25
########################################################################################
30
Got one of the listed errors
31
Got one of the listed errors
32
Got one of the listed errors
34
Got one of the listed errors
35
Got one of the listed errors
37
Got one of the listed errors
38
Got one of the listed errors
39
include/diff_tables.inc [master:t1,slave:t1]
40
########################################################################################
42
########################################################################################
47
Got one of the listed errors
48
Got one of the listed errors
49
Got one of the listed errors
51
include/diff_tables.inc [master:t1,slave:t1]
52
########################################################################################
53
# 4 - BEGIN - ROLLBACK
54
########################################################################################
59
Got one of the listed errors
60
Got one of the listed errors
61
Got one of the listed errors
64
Warning 1196 Some non-transactional changed tables couldn't be rolled back
65
include/diff_tables.inc [master:t1,slave:t1]
66
########################################################################################
68
########################################################################################
72
CREATE PROCEDURE p1(pd VARCHAR(30000))
74
INSERT INTO t1 (a, data) VALUES (1, pd);
75
INSERT INTO t1 (a, data) VALUES (2, pd);
76
INSERT INTO t1 (a, data) VALUES (3, pd);
77
INSERT INTO t1 (a, data) VALUES (4, pd);
78
INSERT INTO t1 (a, data) VALUES (5, 's');
83
Got one of the listed errors
87
Got one of the listed errors
89
include/diff_tables.inc [master:t1,slave:t1]
90
########################################################################################
92
########################################################################################
97
Got one of the listed errors
98
Got one of the listed errors
99
Got one of the listed errors
102
Warning 1196 Some non-transactional changed tables couldn't be rolled back
104
include/diff_tables.inc [master:t1,slave:t1]
105
########################################################################################
106
# 7 - NON-TRANS TABLE
107
########################################################################################
112
Got one of the listed errors
113
Got one of the listed errors
114
Got one of the listed errors
117
Got one of the listed errors
119
include/diff_tables.inc [master:t1,slave:t1]
120
########################################################################
121
# 8 - Bug#55375(Regression Bug) Transaction bigger than
122
# max_binlog_cache_size crashes slave
123
########################################################################
125
SET GLOBAL max_binlog_cache_size = 4096;
126
SET GLOBAL binlog_cache_size = 4096;
127
SET GLOBAL max_binlog_stmt_cache_size = 4096;
128
SET GLOBAL binlog_stmt_cache_size = 4096;
129
include/stop_slave.inc
130
include/start_slave.inc
131
CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage.*");
132
CALL mtr.add_suppression("Multi-statement transaction required more than 'max_binlog_stmt_cache_size' bytes of storage.*");
133
CALL mtr.add_suppression("Writing one row to the row-based binary log failed.*");
134
CALL mtr.add_suppression("Slave SQL.*The incident LOST_EVENTS occured on the master. Message: error writing to the binary log");
136
SET GLOBAL max_binlog_cache_size= ORIGINAL_VALUE;
137
SET GLOBAL binlog_cache_size= ORIGINAL_VALUE;
138
SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
139
SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;
141
Repeat statement 'INSERT INTO t1 VALUES($n, repeat("a", 32))' 128 times
143
include/wait_for_slave_sql_error.inc [errno=1197]
144
SELECT count(*) FROM t1;
147
show binlog events in 'slave-bin.000001' from <binlog_start>;
148
Log_name Pos Event_type Server_id End_log_pos Info
149
SET GLOBAL max_binlog_cache_size= ORIGINAL_VALUE;
150
SET GLOBAL binlog_cache_size= ORIGINAL_VALUE;
151
SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
152
SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;
153
include/stop_slave.inc
154
include/start_slave.inc
155
SELECT count(*) FROM t1;
158
########################################################################################
160
########################################################################################
164
DROP TABLE IF EXISTS t4;