Debian Codegraph @

mysql-test/suite/innodb/r/checkpoint_too_soon.result

raw
1 CREATE TABLE t (
2 id INT PRIMARY KEY,
3 val INT NOT NULL DEFAULT 0,
4 pad1 CHAR(250) NOT NULL DEFAULT "a",
5 pad2 CHAR(250) NOT NULL DEFAULT "a",
6 pad3 CHAR(250) NOT NULL DEFAULT "a",
7 pad4 CHAR(250) NOT NULL DEFAULT "a"
8 );
9 INSERT INTO t (id) VALUES (1);
10 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
11 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
12 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
13 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
14 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
15 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
16 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
17 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
18 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
19 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
20 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
21 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
22 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
23 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
24 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
25 INSERT INTO t (id) SELECT id + (SELECT MAX(id) FROM t) FROM t;
26 SELECT COUNT(*) FROM t;
27 COUNT(*)
28 65536
29 SELECT (SUM(IF(type='t',cnt,0))/SUM(cnt)) BETWEEN 0.25 AND 0.75 AS is_ratio_ok
30 FROM (
31 SELECT
32 IF(SPACE=(SELECT SPACE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='test/t'),'t','other') AS type,
33 COUNT(*) as cnt
34 FROM INFORMATION_SCHEMA.INNODB_BUFFER_PAGE
35 GROUP BY 1
36 ORDER BY 2 DESC
37 ) AS aux;
38 is_ratio_ok
39 1
40 CREATE PROCEDURE log_spammer(f INT,t INT)
41 BEGIN
42 WHILE 1 DO
43 START TRANSACTION;
44 UPDATE t SET val = val + 1 WHERE id BETWEEN f AND t-1;
45 COMMIT;
46 END WHILE;
47 END|
48 CALL log_spammer(0*1310,(0+1)*1310);
49 CALL log_spammer(1*1310,(1+1)*1310);
50 CALL log_spammer(2*1310,(2+1)*1310);
51 CALL log_spammer(3*1310,(3+1)*1310);
52 CALL log_spammer(4*1310,(4+1)*1310);
53 CALL log_spammer(5*1310,(5+1)*1310);
54 CALL log_spammer(6*1310,(6+1)*1310);
55 CALL log_spammer(7*1310,(7+1)*1310);
56 CALL log_spammer(8*1310,(8+1)*1310);
57 CALL log_spammer(9*1310,(9+1)*1310);
58 CALL log_spammer(10*1310,(10+1)*1310);
59 CALL log_spammer(11*1310,(11+1)*1310);
60 CALL log_spammer(12*1310,(12+1)*1310);
61 CALL log_spammer(13*1310,(13+1)*1310);
62 CALL log_spammer(14*1310,(14+1)*1310);
63 CALL log_spammer(15*1310,(15+1)*1310);
64 CALL log_spammer(16*1310,(16+1)*1310);
65 CALL log_spammer(17*1310,(17+1)*1310);
66 CALL log_spammer(18*1310,(18+1)*1310);
67 CALL log_spammer(19*1310,(19+1)*1310);
68 CALL log_spammer(20*1310,(20+1)*1310);
69 CALL log_spammer(21*1310,(21+1)*1310);
70 CALL log_spammer(22*1310,(22+1)*1310);
71 CALL log_spammer(23*1310,(23+1)*1310);
72 CALL log_spammer(24*1310,(24+1)*1310);
73 CALL log_spammer(25*1310,(25+1)*1310);
74 CALL log_spammer(26*1310,(26+1)*1310);
75 CALL log_spammer(27*1310,(27+1)*1310);
76 CALL log_spammer(28*1310,(28+1)*1310);
77 CALL log_spammer(29*1310,(29+1)*1310);
78 CALL log_spammer(30*1310,(30+1)*1310);
79 CALL log_spammer(31*1310,(31+1)*1310);
80 CALL log_spammer(32*1310,(32+1)*1310);
81 CALL log_spammer(33*1310,(33+1)*1310);
82 CALL log_spammer(34*1310,(34+1)*1310);
83 CALL log_spammer(35*1310,(35+1)*1310);
84 CALL log_spammer(36*1310,(36+1)*1310);
85 CALL log_spammer(37*1310,(37+1)*1310);
86 CALL log_spammer(38*1310,(38+1)*1310);
87 CALL log_spammer(39*1310,(39+1)*1310);
88 CALL log_spammer(40*1310,(40+1)*1310);
89 CALL log_spammer(41*1310,(41+1)*1310);
90 CALL log_spammer(42*1310,(42+1)*1310);
91 CALL log_spammer(43*1310,(43+1)*1310);
92 CALL log_spammer(44*1310,(44+1)*1310);
93 CALL log_spammer(45*1310,(45+1)*1310);
94 CALL log_spammer(46*1310,(46+1)*1310);
95 CALL log_spammer(47*1310,(47+1)*1310);
96 CALL log_spammer(48*1310,(48+1)*1310);
97 CALL log_spammer(49*1310,(49+1)*1310);
98 Waiting for checkpoint age to be big enough to force a checkpoint even during recovery
99 SET GLOBAL innodb_checkpoint_disabled = 1;
100 # Kill the server
101 Killed the server while it had large checkpoint age
102 Starting server making it crash as soon as it creates a checkpoint
103 Starting the usual way
104 # restart
105 SELECT COUNT(*) FROM t;
106 COUNT(*)
107 65536
108 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 0*1310 AND (0+1)*1310-1;;
109 COUNT(DISTINCT(val))
110 1
111 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 1*1310 AND (1+1)*1310-1;;
112 COUNT(DISTINCT(val))
113 1
114 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 2*1310 AND (2+1)*1310-1;;
115 COUNT(DISTINCT(val))
116 1
117 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 3*1310 AND (3+1)*1310-1;;
118 COUNT(DISTINCT(val))
119 1
120 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 4*1310 AND (4+1)*1310-1;;
121 COUNT(DISTINCT(val))
122 1
123 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 5*1310 AND (5+1)*1310-1;;
124 COUNT(DISTINCT(val))
125 1
126 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 6*1310 AND (6+1)*1310-1;;
127 COUNT(DISTINCT(val))
128 1
129 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 7*1310 AND (7+1)*1310-1;;
130 COUNT(DISTINCT(val))
131 1
132 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 8*1310 AND (8+1)*1310-1;;
133 COUNT(DISTINCT(val))
134 1
135 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 9*1310 AND (9+1)*1310-1;;
136 COUNT(DISTINCT(val))
137 1
138 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 10*1310 AND (10+1)*1310-1;;
139 COUNT(DISTINCT(val))
140 1
141 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 11*1310 AND (11+1)*1310-1;;
142 COUNT(DISTINCT(val))
143 1
144 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 12*1310 AND (12+1)*1310-1;;
145 COUNT(DISTINCT(val))
146 1
147 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 13*1310 AND (13+1)*1310-1;;
148 COUNT(DISTINCT(val))
149 1
150 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 14*1310 AND (14+1)*1310-1;;
151 COUNT(DISTINCT(val))
152 1
153 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 15*1310 AND (15+1)*1310-1;;
154 COUNT(DISTINCT(val))
155 1
156 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 16*1310 AND (16+1)*1310-1;;
157 COUNT(DISTINCT(val))
158 1
159 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 17*1310 AND (17+1)*1310-1;;
160 COUNT(DISTINCT(val))
161 1
162 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 18*1310 AND (18+1)*1310-1;;
163 COUNT(DISTINCT(val))
164 1
165 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 19*1310 AND (19+1)*1310-1;;
166 COUNT(DISTINCT(val))
167 1
168 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 20*1310 AND (20+1)*1310-1;;
169 COUNT(DISTINCT(val))
170 1
171 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 21*1310 AND (21+1)*1310-1;;
172 COUNT(DISTINCT(val))
173 1
174 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 22*1310 AND (22+1)*1310-1;;
175 COUNT(DISTINCT(val))
176 1
177 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 23*1310 AND (23+1)*1310-1;;
178 COUNT(DISTINCT(val))
179 1
180 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 24*1310 AND (24+1)*1310-1;;
181 COUNT(DISTINCT(val))
182 1
183 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 25*1310 AND (25+1)*1310-1;;
184 COUNT(DISTINCT(val))
185 1
186 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 26*1310 AND (26+1)*1310-1;;
187 COUNT(DISTINCT(val))
188 1
189 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 27*1310 AND (27+1)*1310-1;;
190 COUNT(DISTINCT(val))
191 1
192 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 28*1310 AND (28+1)*1310-1;;
193 COUNT(DISTINCT(val))
194 1
195 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 29*1310 AND (29+1)*1310-1;;
196 COUNT(DISTINCT(val))
197 1
198 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 30*1310 AND (30+1)*1310-1;;
199 COUNT(DISTINCT(val))
200 1
201 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 31*1310 AND (31+1)*1310-1;;
202 COUNT(DISTINCT(val))
203 1
204 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 32*1310 AND (32+1)*1310-1;;
205 COUNT(DISTINCT(val))
206 1
207 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 33*1310 AND (33+1)*1310-1;;
208 COUNT(DISTINCT(val))
209 1
210 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 34*1310 AND (34+1)*1310-1;;
211 COUNT(DISTINCT(val))
212 1
213 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 35*1310 AND (35+1)*1310-1;;
214 COUNT(DISTINCT(val))
215 1
216 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 36*1310 AND (36+1)*1310-1;;
217 COUNT(DISTINCT(val))
218 1
219 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 37*1310 AND (37+1)*1310-1;;
220 COUNT(DISTINCT(val))
221 1
222 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 38*1310 AND (38+1)*1310-1;;
223 COUNT(DISTINCT(val))
224 1
225 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 39*1310 AND (39+1)*1310-1;;
226 COUNT(DISTINCT(val))
227 1
228 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 40*1310 AND (40+1)*1310-1;;
229 COUNT(DISTINCT(val))
230 1
231 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 41*1310 AND (41+1)*1310-1;;
232 COUNT(DISTINCT(val))
233 1
234 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 42*1310 AND (42+1)*1310-1;;
235 COUNT(DISTINCT(val))
236 1
237 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 43*1310 AND (43+1)*1310-1;;
238 COUNT(DISTINCT(val))
239 1
240 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 44*1310 AND (44+1)*1310-1;;
241 COUNT(DISTINCT(val))
242 1
243 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 45*1310 AND (45+1)*1310-1;;
244 COUNT(DISTINCT(val))
245 1
246 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 46*1310 AND (46+1)*1310-1;;
247 COUNT(DISTINCT(val))
248 1
249 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 47*1310 AND (47+1)*1310-1;;
250 COUNT(DISTINCT(val))
251 1
252 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 48*1310 AND (48+1)*1310-1;;
253 COUNT(DISTINCT(val))
254 1
255 SELECT COUNT(DISTINCT(val)) FROM t WHERE id BETWEEN 49*1310 AND (49+1)*1310-1;;
256 COUNT(DISTINCT(val))
257 1
258 CHECK TABLE t;
259 Table Op Msg_type Msg_text
260 test.t check status OK
261 DROP PROCEDURE log_spammer;
262 DROP TABLE t;