# # MDEV-36017 Alter table aborts when temporary # directory is full # CREATE TABLE t1(f1 INT NOT NULL, f2 CHAR(100), f3 CHAR(100))ENGINE=InnoDB; INSERT INTO t1 SELECT seq, 'a', 'b' FROM seq_1_to_4096; SET DEBUG_SYNC="inplace_after_index_build SIGNAL dml_start WAIT_FOR dml_commit"; ALTER TABLE t1 ADD KEY(f1), ADD INDEX(f3(10)); connect con1,localhost,root,,,; SET DEBUG_SYNC="now WAIT_FOR dml_start"; BEGIN; INSERT INTO t1 SELECT * FROM t1; SET STATEMENT DEBUG_DBUG="+d,os_file_write_fail" FOR COMMIT; SET DEBUG_SYNC="now SIGNAL dml_commit"; connection default; ERROR HY000: Temporary file write failure disconnect con1; CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK DROP TABLE t1; SET STATEMENT DEBUG_DBUG="+d,ddl_log_write_fail" FOR CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB; DROP TABLE t1;