Debian Codegraph @

mysql-test/suite/rpl/t/rpl_packet.test

raw
1 #
2 # This include file is used by more than one test suite
3 # (currently rpl and binlog_encryption).
4 # Please check all dependent tests after modifying it
5 #
6
7 # ==== Purpose ====
8 #
9 # Check replication protocol packet size handling
10 #
11 # ==== Related bugs ====
12 # Bug#19402 SQL close to the size of the max_allowed_packet fails on slave
13 # BUG#23755: Replicated event larger that max_allowed_packet infinitely re-transmits
14 # BUG#42914: No LAST_IO_ERROR for max_allowed_packet errors
15 # BUG#55322: SHOW BINLOG EVENTS increases @@SESSION.MAX_ALLOWED_PACKET
16
17 # max-out size db name
18 source include/have_binlog_format_row.inc;
19 source include/master-slave.inc;
20
21 call mtr.add_suppression("Slave I/O: Got a packet bigger than 'slave_max_allowed_packet' bytes, .*error.* 1153");
22 call mtr.add_suppression("Log entry on master is longer than slave_max_allowed_packet");
23 call mtr.add_suppression("Could not write packet:");
24 call mtr.add_suppression("Got a packet bigger than 'max_allowed_packet' bytes");
25
26 let $db= DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________;
27 disable_warnings;
28 eval drop database if exists $db;
29 enable_warnings;
30 eval create database $db;
31
32 connection master;
33 let $old_max_allowed_packet= `SELECT @@global.max_allowed_packet`;
34 let $old_net_buffer_length= `SELECT @@global.net_buffer_length`;
35 let $old_slave_max_allowed_packet= `SELECT @@global.slave_max_allowed_packet`;
36 SET @@global.max_allowed_packet=1024;
37 SET @@global.net_buffer_length=1024;
38
39 sync_slave_with_master;
40 # Restart slave for setting to take effect
41 source include/stop_slave.inc;
42 source include/start_slave.inc;
43
44 # Reconnect to master for new setting to take effect
45 disconnect master;
46
47 # alas, can't use eval here; if db name changed apply the change here
48 connect (master,localhost,root,,DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________);
49
50 connection master;
51 select @@net_buffer_length, @@max_allowed_packet;
52
53 create table `t1` (`f1` LONGTEXT) ENGINE=MyISAM;
54
55 INSERT INTO `t1`(`f1`) VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa1023');
56 sync_slave_with_master;
57
58 eval select count(*) from `$db`.`t1` /* must be 1 */;
59
60 SHOW STATUS LIKE 'Slave_running';
61 select * from information_schema.session_status where variable_name= 'SLAVE_RUNNING';
62 connection master;
63 eval drop database $db;
64 sync_slave_with_master;
65
66 #
67 # Bug #23755: Replicated event larger that max_allowed_packet infinitely re-transmits
68 #
69 # Check that a situation when the size of event on the master is greater than
70 # max_allowed_packet on the slave does not lead to infinite re-transmits.
71
72 connection master;
73
74 # Change the max packet size on master
75
76 SET @@global.max_allowed_packet=4096;
77 SET @@global.net_buffer_length=4096;
78
79 # Restart slave for new setting to take effect
80 connection slave;
81 source include/stop_slave.inc;
82 source include/start_slave.inc;
83
84 # Reconnect to master for new setting to take effect
85 disconnect master;
86 connect (master, localhost, root);
87 connection master;
88
89 CREATE TABLE `t1` (`f1` LONGTEXT) ENGINE=MyISAM;
90
91 sync_slave_with_master;
92
93 connection master;
94
95 INSERT INTO `t1`(`f1`) VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa2048');
96
97
98 #
99 # Bug#42914: The slave I/O thread must stop after trying to read the above
100 # event, However there is no Last_IO_Error report.
101 #
102
103 # The slave I/O thread must stop after trying to read the above event
104 connection slave;
105 # 1153 = ER_NET_PACKET_TOO_LARGE
106 --let $slave_io_errno= 1153
107 --let $show_slave_io_error= 1
108 --source include/wait_for_slave_io_error.inc
109
110 # TODO: this is needed because of BUG#55790. Remove once that is fixed.
111 --source include/stop_slave_sql.inc
112
113 #
114 # Bug#42914: On the master, if a binary log event is larger than
115 # max_allowed_packet, the error message ER_MASTER_FATAL_ERROR_READING_BINLOG
116 # is sent to a slave when it requests a dump from the master, thus leading the
117 # I/O thread to stop. However, there is no Last_IO_Error reported.
118 #
119
120 --let $rpl_only_running_threads= 1
121 --source include/rpl_reset.inc
122 --connection master
123 DROP TABLE t1;
124 --sync_slave_with_master
125
126
127 connection master;
128 CREATE TABLE t1 (f1 int PRIMARY KEY, f2 LONGTEXT, f3 LONGTEXT) ENGINE=MyISAM;
129 sync_slave_with_master;
130
131 connection master;
132 INSERT INTO t1(f1, f2, f3) VALUES(1, REPEAT('a', @@global.max_allowed_packet), REPEAT('b', @@global.max_allowed_packet));
133
134 connection slave;
135 # The slave I/O thread must stop after receiving
136 # 1153 = ER_NET_PACKET_TOO_LARGE
137 --let $slave_io_errno= 1153
138 --let $show_slave_io_error= 1
139 --source include/wait_for_slave_io_error.inc
140
141 # Remove the bad binlog and clear error status on slave.
142 STOP SLAVE;
143 RESET SLAVE;
144 --connection master
145 RESET MASTER;
146
147
148 #
149 # BUG#55322: SHOW BINLOG EVENTS increases @@SESSION.MAX_ALLOWED_PACKET
150 #
151 # In BUG#55322, @@session.max_allowed_packet increased each time SHOW
152 # BINLOG EVENTS was issued. To verify that this bug is fixed, we
153 # execute SHOW BINLOG EVENTS twice and check that max_allowed_packet
154 # never changes. We turn off the result log because we don't care
155 # about the contents of the binlog.
156
157 --disable_result_log
158 SET @max_allowed_packet_0= @@session.max_allowed_packet;
159 SHOW BINLOG EVENTS;
160 SET @max_allowed_packet_1= @@session.max_allowed_packet;
161 SHOW BINLOG EVENTS;
162 SET @max_allowed_packet_2= @@session.max_allowed_packet;
163 --enable_result_log
164 if (`SELECT NOT(@max_allowed_packet_0 = @max_allowed_packet_1 AND @max_allowed_packet_1 = @max_allowed_packet_2)`)
165 {
166 --echo ERROR: max_allowed_packet changed after executing SHOW BINLOG EVENTS
167 --source include/show_rpl_debug_info.inc
168 SELECT @max_allowed_packet_0, @max_allowed_packet_1, @max_allowed_packet_2;
169 --die @max_allowed_packet changed after executing SHOW BINLOG EVENTS
170 }
171
172
173 --echo ==== clean up ====
174 connection master;
175 DROP TABLE t1;
176 eval SET @@global.max_allowed_packet= $old_max_allowed_packet;
177 eval SET @@global.net_buffer_length= $old_net_buffer_length;
178 eval SET @@global.slave_max_allowed_packet= $old_slave_max_allowed_packet;
179 # slave is stopped
180 connection slave;
181 DROP TABLE t1;
182
183 # Clear Last_IO_Error
184 RESET SLAVE;
185
186 --source include/rpl_end.inc
187 # End of tests