Debian Codegraph @

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

raw
1 #
2 # MDEV-36017 Alter table aborts when temporary
3 # directory is full
4 #
5 SET SESSION DEFAULT_STORAGE_ENGINE=InnoDB;
6 CREATE TABLE t1(f1 CHAR(100) NOT NULL, f2 CHAR(100) NOT NULL,
7 f3 CHAR(100) NOT NULL, f4 CHAR(100) NOT NULL,
8 f5 CHAR(100) NOT NULL)ENGINE=InnoDB;
9 INSERT INTO t1 SELECT 'a', 'b', 'c', 'd', 'e' FROM seq_1_to_65536;
10 SET STATEMENT DEBUG_DBUG="+d,write_to_tmp_file_fail" FOR
11 CREATE TABLE t2 as SELECT * FROM t1;
12 ERROR HY000: Got error 59 'Temp file write failure' from InnoDB
13 DROP TABLE t1;
14 CREATE TABLE t1(f1 INT NOT NULL, f2 CHAR(100),
15 f3 CHAR(100))ENGINE=InnoDB;
16 INSERT INTO t1 SELECT seq, 'a', 'b' FROM seq_1_to_1024;
17 SET STATEMENT DEBUG_DBUG="+d,write_to_tmp_file_fail" FOR
18 ALTER TABLE t1 FORCE, ALGORITHM=COPY;
19 ERROR HY000: Got error 59 'Temp file write failure' from InnoDB
20 DROP TABLE t1;
21 CREATE TABLE t1(f1 INT NOT NULL, f2 CHAR(100),
22 f3 CHAR(100))ENGINE=InnoDB;
23 INSERT INTO t1 SELECT seq, 'a', 'b' FROM seq_1_to_4096;
24 SET DEBUG_SYNC="inplace_after_index_build SIGNAL dml_start WAIT_FOR dml_commit";
25 ALTER TABLE t1 ADD KEY(f1), ADD INDEX(f3(10));
26 connect con1,localhost,root,,,;
27 SET DEBUG_SYNC="now WAIT_FOR dml_start";
28 BEGIN;
29 INSERT INTO t1 SELECT * FROM t1;
30 SET STATEMENT DEBUG_DBUG="+d,os_file_write_fail" FOR COMMIT;
31 SET DEBUG_SYNC="now SIGNAL dml_commit";
32 connection default;
33 ERROR HY000: Temporary file write failure
34 disconnect con1;
35 CHECK TABLE t1;
36 Table Op Msg_type Msg_text
37 test.t1 check status OK
38 DROP TABLE t1;
39 SET STATEMENT DEBUG_DBUG="+d,ddl_log_write_fail" FOR
40 CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB;
41 DROP TABLE t1;
42 CREATE TABLE t1(f1 TEXT, index(f1(2)))ENGINE=InnoDB;
43 INSERT INTO t1 VALUES('a');
44 set statement DEBUG_DBUG="+d,btr_page_alloc_fail" for
45 UPDATE t1 set f1= REPEAT('b', 12000);
46 ERROR HY000: The table 't1' is full
47 DROP TABLE t1;