Debian Codegraph @

mysql-test/suite/innodb/t/lob_no_space.test

raw
1 --source include/have_debug.inc
2 --source include/have_innodb_16k.inc
3
4 --echo #
5 --echo # Bug #27852003 LOG::ALLOC_LOB_PAGE MAY FAIL AND RETURN NULLPTR
6 --echo # BUT IT IS NOT HANDLED
7 --echo #
8
9 --disable_query_log
10 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The table 't1' is full");
11 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The table 't2' is full");
12 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The table 't3' is full");
13 --enable_query_log
14
15 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 LONGBLOB);
16 SET DEBUG = '+d,innodb_alloc_lob_page_failed';
17 --error ER_RECORD_FILE_FULL
18 INSERT INTO t1 VALUES (1, REPEAT('x', 81920));
19 SET DEBUG = '-d,innodb_alloc_lob_page_failed';
20 CHECK TABLE t1;
21
22 CREATE TABLE t2 (f1 INT PRIMARY KEY, f2 LONGBLOB);
23 SET DEBUG = '+d,innodb_lob_data_page_alloc_failed';
24 --error ER_RECORD_FILE_FULL
25 INSERT INTO t2 VALUES (1, REPEAT('x', 81920));
26 SET DEBUG = '-d,innodb_lob_data_page_alloc_failed';
27 CHECK TABLE t2;
28
29 CREATE TABLE t3 (f1 INT PRIMARY KEY, f2 LONGBLOB);
30 SET DEBUG = '+d,innodb_lob_alloc_node_page_failed';
31 --error ER_RECORD_FILE_FULL
32 INSERT INTO t3 VALUES (1, REPEAT('x', 163840));
33 SET DEBUG = '-d,innodb_lob_alloc_node_page_failed';
34 CHECK TABLE t3;
35
36 FLUSH TABLES t1 FOR EXPORT;
37 UNLOCK TABLES;
38 FLUSH TABLES t2 FOR EXPORT;
39 UNLOCK TABLES;
40 FLUSH TABLES t3 FOR EXPORT;
41 UNLOCK TABLES;
42
43 DROP TABLE t1;
44 DROP TABLE t2;
45 DROP TABLE t3;