Debian Codegraph @

mysql-test/suite/binlog/r/binlog_incident_concurrent.result

raw
1 call mtr.add_suppression("Non-transactional changes were not written to the binlog. An incident event has been written to the binary log which will stop the replicas.");
2 SET GLOBAL max_binlog_stmt_cache_size = 4096;
3 Warnings:
4 Warning 1745 Option binlog_stmt_cache_size (32768) is greater than max_binlog_stmt_cache_size (4096); setting binlog_stmt_cache_size equal to max_binlog_stmt_cache_size.
5 SET GLOBAL binlog_stmt_cache_size = 4096;
6 CREATE TABLE t1(c1 INT PRIMARY KEY, data TEXT(30000)) ENGINE=MyIsam;
7 CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(400)) engine=InnoDB;
8 CREATE PROCEDURE dmlload (seconds int)
9 begin
10 set @x=time_to_sec(current_time()) + seconds;
11 repeat
12 start transaction;
13 insert into t2 values (2, repeat('I', 400));
14 commit;
15 start transaction;
16 update t2 set b=repeat('Z', 400) where a=2;
17 commit;
18 start transaction;
19 delete from t2 where a=2;
20 commit;
21 until @x <= time_to_sec(current_time())
22 end repeat;
23 end%
24 RESET MASTER;
25 # Start running background load for 5 seconds
26 call dmlload(5);
27 # i: 1
28 Got one of the listed errors
29 # i: 2
30 Got one of the listed errors
31 # i: 3
32 Got one of the listed errors
33 # i: 4
34 Got one of the listed errors
35 # i: 5
36 Got one of the listed errors
37 # i: 6
38 Got one of the listed errors
39 # i: 7
40 Got one of the listed errors
41 # i: 8
42 Got one of the listed errors
43 # i: 9
44 Got one of the listed errors
45 # i: 10
46 Got one of the listed errors
47 # i: 11
48 Got one of the listed errors
49 # i: 12
50 Got one of the listed errors
51 # i: 13
52 Got one of the listed errors
53 # i: 14
54 Got one of the listed errors
55 # i: 15
56 Got one of the listed errors
57 # i: 16
58 Got one of the listed errors
59 # i: 17
60 Got one of the listed errors
61 # i: 18
62 Got one of the listed errors
63 # i: 19
64 Got one of the listed errors
65 # i: 20
66 Got one of the listed errors
67 # i: 21
68 Got one of the listed errors
69 # i: 22
70 Got one of the listed errors
71 # i: 23
72 Got one of the listed errors
73 # i: 24
74 Got one of the listed errors
75 # i: 25
76 Got one of the listed errors
77 # i: 26
78 Got one of the listed errors
79 # i: 27
80 Got one of the listed errors
81 # i: 28
82 Got one of the listed errors
83 # i: 29
84 Got one of the listed errors
85 # i: 30
86 Got one of the listed errors
87 # i: 31
88 Got one of the listed errors
89 # i: 32
90 Got one of the listed errors
91 # i: 33
92 Got one of the listed errors
93 # i: 34
94 Got one of the listed errors
95 # i: 35
96 Got one of the listed errors
97 # i: 36
98 Got one of the listed errors
99 # i: 37
100 Got one of the listed errors
101 # i: 38
102 Got one of the listed errors
103 # i: 39
104 Got one of the listed errors
105 # i: 40
106 Got one of the listed errors
107 # i: 41
108 Got one of the listed errors
109 # i: 42
110 Got one of the listed errors
111 # i: 43
112 Got one of the listed errors
113 # i: 44
114 Got one of the listed errors
115 # i: 45
116 Got one of the listed errors
117 # i: 46
118 Got one of the listed errors
119 # i: 47
120 Got one of the listed errors
121 # i: 48
122 Got one of the listed errors
123 # i: 49
124 Got one of the listed errors
125 # i: 50
126 Got one of the listed errors
127 # There should now be 50 incidents in the binlog
128 # Collect background load result
129 # Check that binlogs contain Gtid + Incident
130 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
131 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
132 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
133 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
134 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
135 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
136 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
137 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
138 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
139 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
140 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
141 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
142 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
143 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
144 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
145 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
146 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
147 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
148 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
149 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
150 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
151 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
152 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
153 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
154 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
155 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
156 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
157 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
158 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
159 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
160 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
161 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
162 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
163 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
164 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
165 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
166 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
167 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
168 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
169 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
170 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
171 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
172 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
173 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
174 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
175 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
176 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
177 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
178 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
179 include/assert_binlog_events.inc [!Gtid_or_anon # Incident]
180 DROP TABLE t1;
181 DROP TABLE t2;
182 DROP PROCEDURE dmlload;
183 SET GLOBAL max_binlog_stmt_cache_size= ORIGINAL_VALUE;
184 SET GLOBAL binlog_stmt_cache_size= ORIGINAL_VALUE;