Debian Codegraph @

mysql-test/suite/rpl/r/rpl_checksum_cache.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(".* since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica. Statement: insert into t2 set data=repeat.*'a', @act_size.*");
7 call mtr.add_suppression(".* since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the replica. Statement: insert into t1 values.* NAME_CONST.*'n',.*, @data .*");
8 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
9 set @save_binlog_cache_size = @@global.binlog_cache_size;
10 set @save_binlog_checksum = @@global.binlog_checksum;
11 set @save_source_verify_checksum = @@global.source_verify_checksum;
12 set @@global.binlog_cache_size = 4096;
13 set @@global.binlog_checksum = CRC32;
14 set @@global.source_verify_checksum = 1;
15 include/sync_slave_sql_with_master.inc
16 include/stop_slave.inc
17 include/start_slave.inc
18 flush status;
19 show status like "binlog_cache_use";
20 Variable_name Value
21 Binlog_cache_use 0
22 show status like "binlog_cache_disk_use";
23 Variable_name Value
24 Binlog_cache_disk_use 0
25 create table t1 (a int PRIMARY KEY, b CHAR(32)) engine=innodb;
26 create procedure test.p_init (n int, size int)
27 begin
28 while n > 0 do
29 select round(RAND() * size) into @act_size;
30 set @data = repeat('a', @act_size);
31 insert into t1 values(n, @data );
32 set n= n-1;
33 end while;
34 end|
35 begin;
36 call test.p_init(4000, 32);
37 commit;
38 show status like "binlog_cache_use";
39 Variable_name Value
40 Binlog_cache_use 3
41 *** binlog_cache_disk_use must be non-zero ***
42 show status like "binlog_cache_disk_use";
43 Variable_name Value
44 Binlog_cache_disk_use 1
45 include/sync_slave_sql_with_master.inc
46 include/diff_tables.inc [master:t1, slave:t1]
47 begin;
48 delete from t1;
49 commit;
50 include/sync_slave_sql_with_master.inc
51 flush status;
52 create table t2(a int auto_increment primary key, data VARCHAR(12288)) ENGINE=Innodb;
53 show status like "binlog_cache_use";
54 Variable_name Value
55 Binlog_cache_use 2
56 *** binlog_cache_disk_use must be non-zero ***
57 show status like "binlog_cache_disk_use";
58 Variable_name Value
59 Binlog_cache_disk_use 1
60 include/sync_slave_sql_with_master.inc
61 include/diff_tables.inc [master:t2, slave:t2]
62 begin;
63 delete from t2;
64 commit;
65 include/sync_slave_sql_with_master.inc
66 flush status;
67 create table t3(a int auto_increment primary key, data VARCHAR(8192)) engine=innodb;
68 show status like "binlog_cache_use";
69 Variable_name Value
70 Binlog_cache_use 2
71 *** binlog_cache_disk_use must be non-zero ***
72 show status like "binlog_cache_disk_use";
73 Variable_name Value
74 Binlog_cache_disk_use 1
75 include/sync_slave_sql_with_master.inc
76 include/diff_tables.inc [master:t3, slave:t3]
77 begin;
78 delete from t3;
79 commit;
80 include/sync_slave_sql_with_master.inc
81 flush status;
82 create procedure test.p1 (n int)
83 begin
84 while n > 0 do
85 case (select (round(rand()*100) % 3) + 1)
86 when 1 then
87 select round(RAND() * 32) into @act_size;
88 set @data = repeat('a', @act_size);
89 insert into t1 values(n, @data);
90 when 2 then
91 begin
92 select round(8192 + RAND() * 4096) into @act_size;
93 insert into t2 set data=repeat('a', @act_size);
94 end;
95 when 3 then
96 begin
97 select round(3686.4000 + RAND() * 819.2000) into @act_size;
98 insert into t3 set data= repeat('a', @act_size);
99 end;
100 end case;
101 set n= n-1;
102 end while;
103 end|
104 set autocommit= 0;
105 begin;
106 call test.p1(1000);
107 commit;
108 show status like "binlog_cache_use";
109 Variable_name Value
110 Binlog_cache_use 2
111 *** binlog_cache_disk_use must be non-zero ***
112 show status like "binlog_cache_disk_use";
113 Variable_name Value
114 Binlog_cache_disk_use 1
115 include/sync_slave_sql_with_master.inc
116 include/diff_tables.inc [master:t1, slave:t1]
117 include/diff_tables.inc [master:t2, slave:t2]
118 include/diff_tables.inc [master:t3, slave:t3]
119 begin;
120 delete from t1;
121 delete from t2;
122 delete from t3;
123 commit;
124 drop table t1, t2, t3;
125 set @@global.binlog_cache_size = @save_binlog_cache_size;
126 set @@global.binlog_checksum = @save_binlog_checksum;
127 set @@global.source_verify_checksum = @save_source_verify_checksum;
128 drop procedure test.p_init;
129 drop procedure test.p1;
130 include/rpl_end.inc