Debian Codegraph @

mysql-test/suite/rpl/r/rpl_packet.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 I/O for channel '': Got a packet bigger than 'replica_max_allowed_packet' bytes, Error_code: MY-013125");
7 call mtr.add_suppression("Log entry on source is longer than replica_max_allowed_packet");
8 drop database if exists DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________;
9 create database DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________;
10 SET @@global.max_allowed_packet=10240;
11 SET @@global.net_buffer_length=1024;
12 include/sync_slave_sql_with_master.inc
13 call mtr.add_suppression(".*The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state.*");
14 include/stop_slave.inc
15 include/start_slave.inc
16 select @@net_buffer_length, @@max_allowed_packet;
17 @@net_buffer_length @@max_allowed_packet
18 1024 10240
19 create table `t1` (`f1` LONGTEXT);
20 INSERT INTO `t1`(`f1`) VALUES ('aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa2048');
21 include/sync_slave_sql_with_master.inc
22 select count(*) from `DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________`.`t1` /* must be 1 */;
23 count(*)
24 1
25 select ras.SERVICE_STATE as Slave_SQL_Running, rcs.SERVICE_STATE as Slave_IO_Running
26 from performance_schema.replication_applier_status ras,
27 performance_schema.replication_connection_status rcs;
28 Slave_SQL_Running Slave_IO_Running
29 ON ON
30 drop database DB_NAME_OF_MAX_LENGTH_AKA_NAME_LEN_64_BYTES_____________________;
31 include/sync_slave_sql_with_master.inc
32 SET @@global.max_allowed_packet=4096 + (floor(64 * 3 * 254 / 1024) + 1) * 1024;
33 SET @@global.net_buffer_length=@@global.max_allowed_packet;
34 include/stop_slave.inc
35 include/start_slave.inc
36 CREATE TABLE `t1` (`f1` LONGTEXT);
37 include/sync_slave_sql_with_master.inc
38 include/stop_slave_sql.inc
39 INSERT INTO t1 VALUES (REPEAT('a', @@global.max_allowed_packet));
40 include/wait_for_slave_io_error.inc [errno=13125]
41 Last_IO_Error = 'Got a packet bigger than 'replica_max_allowed_packet' bytes'
42 include/rpl_reset.inc
43 DROP TABLE t1;
44 include/sync_slave_sql_with_master.inc
45 CREATE TABLE t1 (f1 int PRIMARY KEY, f2 LONGTEXT, f3 LONGTEXT) ENGINE=MyISAM;
46 include/sync_slave_sql_with_master.inc
47 INSERT INTO t1(f1, f2, f3) VALUES(1, REPEAT('a', @@global.max_allowed_packet), REPEAT('b', @@global.max_allowed_packet));
48 include/wait_for_slave_io_error.inc [errno=13125]
49 Last_IO_Error = 'Got a packet bigger than 'replica_max_allowed_packet' bytes'
50 STOP SLAVE;
51 Warnings:
52 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
53 RESET SLAVE;
54 Warnings:
55 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
56 RESET MASTER;
57 RESET MASTER;
58 SET @max_allowed_packet_0= @@session.max_allowed_packet;
59 SHOW BINLOG EVENTS;
60 SET @max_allowed_packet_1= @@session.max_allowed_packet;
61 SHOW BINLOG EVENTS;
62 SET @max_allowed_packet_2= @@session.max_allowed_packet;
63 START SLAVE;
64 Warnings:
65 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
66 include/wait_for_slave_to_start.inc
67 DROP TABLE t1;
68 select @@global.max_allowed_packet;
69 @@global.max_allowed_packet
70 53248
71 select @@global.net_buffer_length;
72 @@global.net_buffer_length
73 53248
74 include/sync_slave_sql_with_master.inc
75 select @@global.max_allowed_packet;
76 @@global.max_allowed_packet
77 2048
78 select @@global.net_buffer_length;
79 @@global.net_buffer_length
80 1024
81 CREATE TABLE t1 (a TEXT) ENGINE=MyISAM;
82 include/sync_slave_sql_with_master.inc
83 INSERT INTO t1 VALUES (REPEAT('a', @@global.max_allowed_packet));
84 # 13125 = ER_SERVER_NET_PACKET_TOO_LARGE
85 include/wait_for_slave_io_error.inc [errno=13125]
86 Last_IO_Error = 'Got a packet bigger than 'replica_max_allowed_packet' bytes'
87 # Record Read_Master_Log_Pos for the Table_map_log_event
88 SET @@global.max_allowed_packet=1048576;
89 WARNING: The range of printed events ends with a row event or a table map event that does not have the STMT_END_F flag set. This might be because the last statement was not fully written to the log, or because you are using a --stop-position or --stop-datetime that refers to an event in the middle of a statement. The event(s) from the partial statement have not been written to output.
90 WARNING: The range of printed events ends with a row event or a table map event that does not have the STMT_END_F flag set. This might be because the last statement was not fully written to the log, or because you are using a --stop-position or --stop-datetime that refers to an event in the middle of a statement. The event(s) from the partial statement have not been written to output.
91 ==== clean up ====
92 DROP TABLE t1;
93 SET @@global.max_allowed_packet= 4096;
94 Warnings:
95 Warning 1708 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
96 SET @@global.net_buffer_length= 1024;
97 SET @@global.replica_max_allowed_packet= 4096;
98 SET @@global.max_allowed_packet= 2048;
99 DROP TABLE t1;
100 STOP REPLICA;
101 RESET SLAVE;
102 Warnings:
103 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
104 include/rpl_end.inc