Debian Codegraph @

mysql-test/suite/innodb/r/innodb_read_only-1.result

raw
1 SET GLOBAL innodb_file_per_table = 1;
2 SELECT @@innodb_file_per_table;
3 @@innodb_file_per_table
4 1
5 CREATE DATABASE testdb_wl6445;
6 case # 1
7 USE testdb_wl6445;
8 CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
9 INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
10 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
11 i LEFT(j,20)
12 1 aaaaaaaaaaaaaaaaaaaa
13 2 bbbbbbbbbbbbbbbbbbbb
14 3 cccccccccccccccccccc
15 CREATE USER 'test1'@'localhost' IDENTIFIED BY '123';
16 GRANT ALL ON testdb_wl6445.* TO 'test1'@'localhost';
17 CREATE USER 'test2'@'localhost' IDENTIFIED BY '123';
18 GRANT ALL ON *.* TO 'test2'@'localhost';
19 CREATE TABLE otherlocation (id int PRIMARY KEY)
20 ENGINE=InnoDB , DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
21 INSERT INTO otherlocation VALUES (1),(2),(3);
22 SELECT * FROM otherlocation ORDER BY id;
23 id
24 1
25 2
26 3
27 SET GLOBAL innodb_fast_shutdown = 0;
28 # restart: --innodb-read-only
29 SET GLOBAL innodb_file_per_table = 1;
30 USE testdb_wl6445;
31 SELECT i FROM t1 ORDER BY i;
32 i
33 1
34 2
35 3
36 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
37 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
38 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
39 i LEFT(j,20)
40 1 aaaaaaaaaaaaaaaaaaaa
41 2 bbbbbbbbbbbbbbbbbbbb
42 3 cccccccccccccccccccc
43 CREATE USER 'test3'@'localhost' IDENTIFIED BY '123';
44 ERROR HY000: The ACL operation failed due to the following error from SE: errcode 165 - Table is read only
45 # connection con_test1_user try to modify
46 SELECT user();
47 user()
48 test1@localhost
49 USE testdb_wl6445;
50 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
51 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
52 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
53 i LEFT(j,20)
54 1 aaaaaaaaaaaaaaaaaaaa
55 2 bbbbbbbbbbbbbbbbbbbb
56 3 cccccccccccccccccccc
57 CREATE TABLE t2 ( i int ,j blob) ENGINE = Innodb;
58 ERROR HY000: Running in read-only mode
59 UPDATE t1 SET i = i+1;
60 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
61 # disconnect con_test1_user
62 # connection con_test2_user
63 SELECT user();
64 user()
65 test2@localhost
66 USE testdb_wl6445;
67 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
68 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
69 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
70 i LEFT(j,20)
71 1 aaaaaaaaaaaaaaaaaaaa
72 2 bbbbbbbbbbbbbbbbbbbb
73 3 cccccccccccccccccccc
74 CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
75 ERROR HY000: Running in read-only mode
76 UPDATE t1 SET i = i+1;
77 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
78 FLUSH STATUS;
79 FLUSH LOGS;
80 FLUSH TABLES t1;
81 FLUSH TABLES WITH READ LOCK;
82 UNLOCK TABLES;
83 # disconnect con_test2_user
84 # connection default
85 USE testdb_wl6445;
86 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
87 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
88 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
89 i LEFT(j,20)
90 1 aaaaaaaaaaaaaaaaaaaa
91 2 bbbbbbbbbbbbbbbbbbbb
92 3 cccccccccccccccccccc
93 CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
94 ERROR HY000: Running in read-only mode
95 UPDATE t1 SET i = i+1;
96 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
97 INSERT INTO otherlocation VALUES (1),(2),(3);
98 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
99 SELECT * FROM otherlocation ORDER BY id;
100 id
101 1
102 2
103 3
104 FLUSH STATUS;
105 FLUSH LOGS;
106 FLUSH TABLES t1;
107 FLUSH TABLES WITH READ LOCK;
108 UNLOCK TABLES;
109 # restart
110 DROP USER 'test1'@'localhost';
111 DROP USER 'test2'@'localhost';
112 DROP DATABASE testdb_wl6445;
113 case # 2
114 CREATE DATABASE testdb_wl6445;
115 SET GLOBAL innodb_file_per_table = 1;
116 USE testdb_wl6445;
117 CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
118 INSERT INTO t1 VALUES (1,repeat('a',4000)),(2,repeat('b',4000)),(3,repeat('c',4000));
119 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
120 i LEFT(j,20)
121 1 aaaaaaaaaaaaaaaaaaaa
122 2 bbbbbbbbbbbbbbbbbbbb
123 3 cccccccccccccccccccc
124 START TRANSACTION;
125 SAVEPOINT A;
126 SAVEPOINT B;
127 ROLLBACK TO A;
128 "---commit first 50 records "
129 COMMIT;
130 SELECT COUNT(*) FROM testdb_wl6445.t1;
131 COUNT(*)
132 50
133 SET GLOBAL innodb_fast_shutdown = 0;
134 # restart: --innodb-read-only
135 USE testdb_wl6445;
136 INSERT INTO t1 VALUES (211,repeat('a',200)),(212,repeat('b',200)),(213,repeat('c',200));
137 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
138 SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i;
139 i LEFT(j,20)
140 10 a10a10a10a10a10a10a1
141 20 a20a20a20a20a20a20a2
142 30 a30a30a30a30a30a30a3
143 40 a40a40a40a40a40a40a4
144 50 a50a50a50a50a50a50a5
145 CREATE TABLE t2 ( i int , j blob) ENGINE = Innodb;
146 ERROR HY000: Running in read-only mode
147 UPDATE t1 SET i = i+1;
148 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
149 SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i;
150 i LEFT(j,20)
151 10 a10a10a10a10a10a10a1
152 20 a20a20a20a20a20a20a2
153 30 a30a30a30a30a30a30a3
154 40 a40a40a40a40a40a40a4
155 50 a50a50a50a50a50a50a5
156 START TRANSACTION;
157 SET GLOBAL innodb_flush_log_at_trx_commit = 0;
158 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
159 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
160 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
161 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
162 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
163 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
164 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
165 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
166 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
167 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
168 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
169 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
170 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
171 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
172 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
173 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
174 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
175 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
176 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
177 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
178 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
179 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
180 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
181 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
182 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
183 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
184 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
185 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
186 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
187 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
188 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
189 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
190 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
191 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
192 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
193 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
194 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
195 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
196 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
197 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
198 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
199 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
200 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
201 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
202 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
203 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
204 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
205 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
206 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
207 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
208 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
209 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
210 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
211 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
212 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
213 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
214 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
215 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
216 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
217 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
218 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
219 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
220 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
221 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
222 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
223 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
224 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
225 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
226 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
227 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
228 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
229 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
230 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
231 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
232 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
233 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
234 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
235 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
236 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
237 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
238 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
239 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
240 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
241 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
242 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
243 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
244 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
245 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
246 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
247 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
248 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
249 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
250 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
251 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
252 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
253 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
254 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
255 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
256 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
257 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
258 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
259 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
260 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
261 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
262 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
263 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
264 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
265 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
266 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
267 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
268 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
269 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
270 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
271 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
272 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
273 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
274 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
275 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
276 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
277 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
278 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
279 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
280 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
281 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
282 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
283 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
284 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
285 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
286 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
287 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
288 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
289 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
290 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
291 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
292 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
293 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
294 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
295 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
296 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
297 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
298 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
299 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
300 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
301 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
302 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
303 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
304 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
305 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
306 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
307 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
308 SAVEPOINT A;
309 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
310 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
311 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
312 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
313 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
314 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
315 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
316 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
317 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
318 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
319 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
320 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
321 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
322 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
323 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
324 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
325 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
326 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
327 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
328 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
329 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
330 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
331 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
332 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
333 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
334 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
335 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
336 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
337 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
338 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
339 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
340 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
341 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
342 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
343 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
344 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
345 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
346 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
347 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
348 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
349 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
350 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
351 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
352 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
353 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
354 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
355 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
356 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
357 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
358 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
359 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
360 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
361 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
362 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
363 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
364 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
365 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
366 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
367 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
368 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
369 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
370 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
371 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
372 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
373 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
374 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
375 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
376 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
377 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
378 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
379 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
380 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
381 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
382 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
383 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
384 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
385 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
386 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
387 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
388 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
389 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
390 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
391 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
392 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
393 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
394 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
395 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
396 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
397 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
398 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
399 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
400 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
401 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
402 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
403 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
404 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
405 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
406 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
407 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
408 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
409 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
410 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
411 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
412 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
413 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
414 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
415 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
416 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
417 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
418 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
419 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
420 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
421 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
422 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
423 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
424 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
425 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
426 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
427 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
428 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
429 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
430 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
431 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
432 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
433 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
434 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
435 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
436 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
437 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
438 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
439 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
440 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
441 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
442 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
443 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
444 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
445 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
446 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
447 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
448 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
449 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
450 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
451 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
452 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
453 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
454 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
455 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
456 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
457 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
458 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
459 SAVEPOINT B;
460 ROLLBACK TO A;
461 "---commit first 50 records with innodb_flush_log_at_trx_commit = 0 --"
462 COMMIT;
463 SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i;
464 i LEFT(j,20)
465 10 a10a10a10a10a10a10a1
466 20 a20a20a20a20a20a20a2
467 30 a30a30a30a30a30a30a3
468 40 a40a40a40a40a40a40a4
469 50 a50a50a50a50a50a50a5
470 START TRANSACTION;
471 SET GLOBAL innodb_flush_log_at_trx_commit = 1;
472 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
473 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
474 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
475 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
476 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
477 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
478 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
479 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
480 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
481 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
482 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
483 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
484 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
485 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
486 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
487 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
488 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
489 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
490 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
491 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
492 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
493 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
494 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
495 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
496 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
497 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
498 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
499 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
500 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
501 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
502 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
503 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
504 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
505 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
506 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
507 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
508 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
509 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
510 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
511 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
512 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
513 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
514 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
515 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
516 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
517 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
518 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
519 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
520 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
521 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
522 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
523 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
524 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
525 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
526 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
527 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
528 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
529 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
530 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
531 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
532 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
533 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
534 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
535 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
536 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
537 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
538 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
539 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
540 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
541 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
542 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
543 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
544 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
545 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
546 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
547 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
548 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
549 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
550 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
551 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
552 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
553 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
554 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
555 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
556 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
557 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
558 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
559 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
560 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
561 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
562 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
563 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
564 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
565 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
566 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
567 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
568 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
569 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
570 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
571 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
572 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
573 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
574 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
575 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
576 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
577 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
578 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
579 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
580 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
581 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
582 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
583 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
584 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
585 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
586 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
587 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
588 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
589 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
590 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
591 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
592 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
593 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
594 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
595 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
596 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
597 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
598 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
599 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
600 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
601 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
602 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
603 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
604 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
605 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
606 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
607 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
608 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
609 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
610 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
611 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
612 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
613 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
614 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
615 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
616 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
617 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
618 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
619 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
620 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
621 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
622 SAVEPOINT A;
623 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
624 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
625 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
626 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
627 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
628 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
629 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
630 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
631 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
632 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
633 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
634 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
635 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
636 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
637 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
638 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
639 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
640 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
641 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
642 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
643 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
644 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
645 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
646 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
647 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
648 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
649 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
650 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
651 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
652 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
653 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
654 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
655 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
656 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
657 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
658 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
659 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
660 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
661 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
662 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
663 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
664 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
665 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
666 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
667 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
668 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
669 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
670 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
671 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
672 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
673 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
674 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
675 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
676 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
677 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
678 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
679 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
680 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
681 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
682 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
683 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
684 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
685 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
686 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
687 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
688 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
689 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
690 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
691 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
692 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
693 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
694 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
695 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
696 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
697 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
698 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
699 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
700 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
701 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
702 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
703 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
704 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
705 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
706 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
707 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
708 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
709 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
710 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
711 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
712 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
713 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
714 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
715 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
716 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
717 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
718 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
719 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
720 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
721 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
722 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
723 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
724 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
725 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
726 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
727 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
728 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
729 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
730 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
731 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
732 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
733 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
734 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
735 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
736 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
737 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
738 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
739 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
740 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
741 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
742 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
743 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
744 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
745 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
746 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
747 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
748 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
749 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
750 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
751 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
752 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
753 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
754 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
755 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
756 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
757 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
758 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
759 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
760 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
761 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
762 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
763 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
764 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
765 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
766 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
767 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
768 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
769 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
770 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
771 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
772 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
773 SAVEPOINT B;
774 ROLLBACK TO A;
775 "---commit first 50 records with innodb_flush_log_at_trx_commit = 1 --"
776 COMMIT;
777 SELECT i,LEFT(j,20) FROM t1 WHERE i%10=0 ORDER BY i;
778 i LEFT(j,20)
779 10 a10a10a10a10a10a10a1
780 20 a20a20a20a20a20a20a2
781 30 a30a30a30a30a30a30a3
782 40 a40a40a40a40a40a40a4
783 50 a50a50a50a50a50a50a5
784 START TRANSACTION;
785 SET GLOBAL innodb_flush_log_at_trx_commit = 2;
786 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
787 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
788 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
789 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
790 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
791 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
792 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
793 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
794 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
795 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
796 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
797 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
798 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
799 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
800 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
801 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
802 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
803 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
804 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
805 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
806 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
807 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
808 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
809 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
810 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
811 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
812 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
813 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
814 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
815 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
816 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
817 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
818 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
819 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
820 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
821 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
822 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
823 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
824 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
825 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
826 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
827 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
828 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
829 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
830 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
831 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
832 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
833 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
834 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
835 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
836 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
837 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
838 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
839 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
840 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
841 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
842 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
843 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
844 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
845 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
846 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
847 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
848 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
849 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
850 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
851 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
852 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
853 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
854 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
855 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
856 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
857 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
858 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
859 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
860 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
861 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
862 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
863 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
864 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
865 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
866 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
867 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
868 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
869 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
870 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
871 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
872 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
873 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
874 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
875 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
876 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
877 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
878 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
879 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
880 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
881 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
882 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
883 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
884 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
885 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
886 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
887 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
888 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
889 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
890 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
891 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
892 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
893 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
894 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
895 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
896 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
897 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
898 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
899 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
900 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
901 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
902 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
903 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
904 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
905 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
906 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
907 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
908 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
909 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
910 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
911 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
912 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
913 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
914 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
915 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
916 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
917 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
918 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
919 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
920 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
921 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
922 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
923 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
924 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
925 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
926 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
927 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
928 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
929 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
930 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
931 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
932 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
933 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
934 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
935 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
936 SAVEPOINT A;
937 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
938 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
939 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
940 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
941 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
942 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
943 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
944 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
945 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
946 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
947 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
948 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
949 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
950 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
951 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
952 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
953 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
954 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
955 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
956 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
957 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
958 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
959 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
960 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
961 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
962 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
963 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
964 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
965 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
966 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
967 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
968 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
969 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
970 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
971 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
972 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
973 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
974 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
975 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
976 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
977 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
978 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
979 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
980 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
981 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
982 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
983 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
984 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
985 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
986 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
987 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
988 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
989 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
990 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
991 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
992 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
993 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
994 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
995 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
996 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
997 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
998 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
999 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1000 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1001 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1002 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1003 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1004 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1005 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1006 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1007 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1008 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1009 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1010 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1011 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1012 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1013 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1014 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1015 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1016 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1017 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1018 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1019 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1020 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1021 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1022 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1023 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1024 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1025 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1026 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1027 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1028 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1029 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1030 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1031 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1032 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1033 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1034 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1035 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1036 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1037 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1038 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1039 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1040 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1041 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1042 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1043 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1044 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1045 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1046 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1047 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1048 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1049 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1050 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1051 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1052 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1053 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1054 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1055 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1056 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1057 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1058 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1059 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1060 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1061 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1062 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1063 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1064 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1065 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1066 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1067 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1068 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1069 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1070 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1071 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1072 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1073 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1074 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1075 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1076 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1077 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1078 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1079 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1080 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1081 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1082 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1083 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1084 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1085 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1086 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1087 SAVEPOINT B;
1088 ROLLBACK TO A;
1089 "---commit first 50 records with innodb_flush_log_at_trx_commit = 2 --"
1090 COMMIT;
1091 FLUSH STATUS;
1092 FLUSH LOGS;
1093 FLUSH TABLES t1;
1094 FLUSH TABLES WITH READ LOCK;
1095 UNLOCK TABLES;
1096 # restart
1097 DROP DATABASE testdb_wl6445;
1098 case # 3
1099 CREATE DATABASE testdb_wl6445;
1100 USE testdb_wl6445;
1101 CREATE TABLE t1 ( i int PRIMARY KEY , j blob) ENGINE = InnoDB;
1102 CREATE TABLE t2 ( t2_i int PRIMARY KEY , t2_j blob) ENGINE = InnoDB;
1103 CREATE TABLE t3 ( i int PRIMARY KEY , j VARCHAR(20)) ENGINE = InnoDB;
1104 CREATE TABLE t4 (val INT)
1105 PARTITION BY LIST(val)(
1106 PARTITION mypart_odd VALUES IN (1,3,5),
1107 PARTITION MyPart_even VALUES IN (2,4,6));
1108 INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6);
1109 SELECT * FROM testdb_wl6445.t4 ORDER BY val;
1110 val
1111 1
1112 2
1113 3
1114 4
1115 5
1116 6
1117 CREATE TRIGGER TRIGGER_1 BEFORE INSERT ON testdb_wl6445.t1 FOR EACH ROW BEGIN
1118 INSERT INTO testdb_wl6445.t2 SET t2_i = NEW.i , t2_j = NEW.j;
1119 END;//
1120 CREATE PROCEDURE proc1 (OUT param1 INT)
1121 BEGIN
1122 SELECT COUNT(*) INTO param1 FROM testdb_wl6445.t1;
1123 END;//
1124 CREATE PROCEDURE proc2 (IN param1 INT,IN param2 VARCHAR(20))
1125 BEGIN
1126 INSERT INTO testdb_wl6445.t3 VALUES (param1,param2);
1127 END;//
1128 INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
1129 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1130 i LEFT(j,20)
1131 1 aaaaaaaaaaaaaaaaaaaa
1132 2 bbbbbbbbbbbbbbbbbbbb
1133 3 cccccccccccccccccccc
1134 SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i;
1135 t2_i LEFT(t2_j,20)
1136 1 aaaaaaaaaaaaaaaaaaaa
1137 2 bbbbbbbbbbbbbbbbbbbb
1138 3 cccccccccccccccccccc
1139 CALL proc1(@a);
1140 SELECT @a;
1141 @a
1142 3
1143 CALL proc2(1,'test1');
1144 SELECT * FROM t3;
1145 i j
1146 1 test1
1147 SET GLOBAL innodb_fast_shutdown = 0;
1148 # restart: --innodb-read-only
1149 SET GLOBAL innodb_file_per_table = 1;
1150 USE testdb_wl6445;
1151 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
1152 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1153 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1154 i LEFT(j,20)
1155 1 aaaaaaaaaaaaaaaaaaaa
1156 2 bbbbbbbbbbbbbbbbbbbb
1157 3 cccccccccccccccccccc
1158 SELECT t2_i,LEFT(t2_j,20) FROM t2 ORDER BY t2_i;
1159 t2_i LEFT(t2_j,20)
1160 1 aaaaaaaaaaaaaaaaaaaa
1161 2 bbbbbbbbbbbbbbbbbbbb
1162 3 cccccccccccccccccccc
1163 CALL proc1(@a);
1164 SELECT @a;
1165 @a
1166 3
1167 CALL proc2(2,'test2');
1168 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1169 SELECT * FROM t3;
1170 i j
1171 1 test1
1172 CREATE TEMPORARY TABLE temp_1 ( i INT ) ENGINE = Innodb;
1173 ERROR HY000: InnoDB is in read only mode.
1174 INSERT INTO testdb_wl6445.t4 VALUES (1),(2),(3),(4),(5),(6);
1175 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1176 SELECT * FROM testdb_wl6445.t4 ORDER BY val;
1177 val
1178 1
1179 2
1180 3
1181 4
1182 5
1183 6
1184 FLUSH STATUS;
1185 FLUSH LOGS;
1186 FLUSH TABLES t1,t2,t3;
1187 FLUSH TABLES WITH READ LOCK;
1188 UNLOCK TABLES;
1189 # restart
1190 DROP DATABASE testdb_wl6445;
1191 case # 4
1192 CREATE DATABASE testdb_wl6445;
1193 USE testdb_wl6445;
1194 CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB;
1195 CREATE INDEX idx1 ON testdb_wl6445.t1(i);
1196 INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
1197 INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine');
1198 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1199 i LEFT(j,20)
1200 1 aaaaaaaaaaaaaaaaaaaa
1201 2 bbbbbbbbbbbbbbbbbbbb
1202 3 cccccccccccccccccccc
1203 4 mysql database
1204 5 mysql database innod
1205 6 innodb engine
1206 SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
1207 i j
1208 4 mysql database
1209 5 mysql database innodb support
1210 SET GLOBAL innodb_fast_shutdown = 0;
1211 # restart: --innodb-read-only --innodb_purge_threads=5 --innodb_buffer_pool_size=16M
1212 SET GLOBAL innodb_max_purge_lag = 10;
1213 SET GLOBAL innodb_max_purge_lag_delay = 10;
1214 SET GLOBAL innodb_purge_batch_size = 600;
1215 SET GLOBAL relay_log_purge = 0;
1216 SET GLOBAL innodb_change_buffer_max_size = 30;
1217 SET GLOBAL innodb_change_buffering = 'changes';
1218 SET GLOBAL innodb_print_all_deadlocks = 'ON';
1219 USE testdb_wl6445;
1220 INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
1221 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1222 UPDATE t1 SET i = i + 1;
1223 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1224 DELETE FROM t1 ;
1225 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1226 SELECT @@innodb_max_purge_lag,@@innodb_max_purge_lag_delay,@@innodb_purge_batch_size,
1227 @@innodb_purge_threads,@@relay_log_purge,@@innodb_buffer_pool_size,
1228 @@innodb_change_buffer_max_size,@@innodb_change_buffering,@@innodb_print_all_deadlocks;
1229 @@innodb_max_purge_lag @@innodb_max_purge_lag_delay @@innodb_purge_batch_size @@innodb_purge_threads @@relay_log_purge @@innodb_buffer_pool_size @@innodb_change_buffer_max_size @@innodb_change_buffering @@innodb_print_all_deadlocks
1230 10 10 600 5 0 16777216 30 changes 1
1231 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1232 i LEFT(j,20)
1233 1 aaaaaaaaaaaaaaaaaaaa
1234 2 bbbbbbbbbbbbbbbbbbbb
1235 3 cccccccccccccccccccc
1236 4 mysql database
1237 5 mysql database innod
1238 6 innodb engine
1239 SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
1240 i j
1241 4 mysql database
1242 5 mysql database innodb support
1243 SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ;
1244 i j
1245 5 mysql database innodb support
1246 6 innodb engine
1247 # restart
1248 DROP DATABASE testdb_wl6445;
1249 case # 5
1250 CREATE DATABASE testdb_wl6445;
1251 USE testdb_wl6445;
1252 CREATE TABLE t1 ( i int PRIMARY KEY , j VARCHAR(300), FULLTEXT KEY (j)) ENGINE = InnoDB;
1253 CREATE INDEX idx1 ON testdb_wl6445.t1(i);
1254 INSERT INTO t1 VALUES (1,repeat('a',200)),(2,repeat('b',200)),(3,repeat('c',200));
1255 INSERT INTO t1 VALUES (4,'mysql database'),(5,'mysql database innodb support'),(6,'innodb engine');
1256 SELECT * FROM t1 WHERE MATCH (j) AGAINST ('mysql (+database -innodb)' IN BOOLEAN MODE) ;
1257 i j
1258 4 mysql database
1259 5 mysql database innodb support
1260 SELECT * FROM t1 WHERE MATCH (j) AGAINST ('innodb') ;
1261 i j
1262 5 mysql database innodb support
1263 6 innodb engine
1264 SET GLOBAL innodb_fast_shutdown = 0;
1265 # restart: --innodb-read-only --read-only
1266 USE testdb_wl6445;
1267 show tables;
1268 Tables_in_testdb_wl6445
1269 t1
1270 select * from t1 where i = 4;
1271 i j
1272 4 mysql database
1273 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
1274 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1275 UPDATE t1 SET i = i + 20;
1276 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1277 DELETE FROM t1;
1278 ERROR HY000: Can't lock file (errno: 165 - Table is read only)
1279 CREATE TABLE t2 ( i INT ) ENGINE = Innodb;
1280 ERROR HY000: Running in read-only mode
1281 CREATE USER 'test5'@'localhost' IDENTIFIED BY '123';
1282 ERROR HY000: The ACL operation failed due to the following error from SE: errcode 165 - Table is read only
1283 # restart: --read-only
1284 USE testdb_wl6445;
1285 INSERT INTO t1 VALUES (11,repeat('a',200)),(12,repeat('b',200)),(13,repeat('c',200));
1286 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1287 i LEFT(j,20)
1288 1 aaaaaaaaaaaaaaaaaaaa
1289 2 bbbbbbbbbbbbbbbbbbbb
1290 3 cccccccccccccccccccc
1291 4 mysql database
1292 5 mysql database innod
1293 6 innodb engine
1294 11 aaaaaaaaaaaaaaaaaaaa
1295 12 bbbbbbbbbbbbbbbbbbbb
1296 13 cccccccccccccccccccc
1297 UPDATE t1 SET i = i + 20;
1298 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1299 i LEFT(j,20)
1300 21 aaaaaaaaaaaaaaaaaaaa
1301 22 bbbbbbbbbbbbbbbbbbbb
1302 23 cccccccccccccccccccc
1303 24 mysql database
1304 25 mysql database innod
1305 26 innodb engine
1306 31 aaaaaaaaaaaaaaaaaaaa
1307 32 bbbbbbbbbbbbbbbbbbbb
1308 33 cccccccccccccccccccc
1309 DELETE FROM t1;
1310 SELECT i,LEFT(j,20) FROM t1 ORDER BY i;
1311 i LEFT(j,20)
1312 CREATE TABLE t2 ( i INT ) ENGINE = Innodb;
1313 CREATE USER 'test5_2'@'localhost' IDENTIFIED BY '123';
1314 GRANT ALL ON testdb_wl6445.* TO 'test5_2'@'localhost';
1315 # restart
1316 DROP USER 'test5_2'@'localhost';
1317 DROP DATABASE testdb_wl6445;
1318 case # 6
1319 CREATE DATABASE testdb_wl6445;
1320 USE testdb_wl6445;
1321 CREATE TABLE t1 ( i int PRIMARY KEY ) ENGINE = InnoDB;
1322 CREATE INDEX idx1 ON testdb_wl6445.t1(i);
1323 INSERT INTO t1 VALUES (1),(2),(3);
1324 SELECT i FROM t1 ORDER BY i;
1325 i
1326 1
1327 2
1328 3
1329 # Creating a temp sql file to be loaded.
1330 SET GLOBAL innodb_fast_shutdown = 0;
1331 # restart: --innodb-read-only
1332 USE testdb_wl6445;
1333 : 1036, Table 't1' is read only, when using table: t1
1334 SELECT i FROM t1 ORDER BY i;
1335 i
1336 1
1337 2
1338 3
1339 # restart
1340 DROP DATABASE testdb_wl6445;
1341 case # 7 (restart server in read-only mode and perform check table)
1342 use test;
1343 create table t1 (
1344 i int,
1345 f float,
1346 c char(100),
1347 b blob
1348 ) engine = innodb;
1349 CREATE PROCEDURE populate_t1()
1350 BEGIN
1351 DECLARE i INT DEFAULT 1;
1352 while (i <= 100) DO
1353 insert into t1 values (
1354 i, 2.323,
1355 'adfaqfafafafafsasfafsa',
1356 'badfadfsaeerer234234asdfdsafdasr2354234324234234');
1357 SET i = i + 1;
1358 END WHILE;
1359 END|
1360 begin;
1361 call populate_t1();
1362 commit;
1363 check table t1 extended;
1364 Table Op Msg_type Msg_text
1365 test.t1 check status OK
1366 SET GLOBAL innodb_fast_shutdown = 0;
1367 # restart: --innodb-read-only
1368 check table t1 extended;
1369 Table Op Msg_type Msg_text
1370 test.t1 check status OK
1371 # restart
1372 check table t1 extended;
1373 Table Op Msg_type Msg_text
1374 test.t1 check status OK
1375 drop table t1;
1376 drop procedure populate_t1;