Why does creating an index or adding a primary key report "no enough space in /tmp/tidb/tmp_ddl-4000"?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 创建索引或者增加主键报no enough space in /tmp/tidb/tmp_ddl-4000是怎么回事啊

| username: N1ckelth

[Test Environment for TiDB]
[TiDB Version] 8.0.0
[Reproduction Path] Operations performed that led to the issue
CREATE TABLE t0(c0 BOOL);
CREATE INDEX i0 ON t0(c0);
ALTER TABLE t0 ADD PRIMARY KEY(c0);
[Encountered Issue: Issue Phenomenon and Impact]
Both of the following statements result in an error:
ERROR 8256 (HY000): Check ingest environment failed: no enough space in /tmp/tidb/tmp_ddl-4000
[Resource Configuration] Using 1 PD and 3 TiKV

2
| username: N1ckelth | Original post link

TiDB is running in a Docker container. I checked the /tmp/tidb/tmp_ddl-4000 folder, and it is only 4.0KB.

3
| username: zhanggame1 | Original post link

The default parameters for building an index may use the disk.

4
| username: Jellybean | Original post link

This issue is caused by fast online DDL using disk temporarily to speed up the execution of some DDLs, and the default space is insufficient. You can set it to a directory with more space.

5
| username: yytest | Original post link

Try changing the directory.

6
| username: shigp_TIDBER | Original post link

Ensure there is enough space in the temporary directory.

7
| username: 友利奈绪 | Original post link

It may be due to insufficient permissions for non-root users.

8
| username: TiDBer_QYr0vohO | Original post link

The space in the directory /tmp/tidb/tmp_ddl-4000 is not enough.

9
| username: yytest | Original post link

Check if the disk space is insufficient.

10
| username: zhaokede | Original post link

Insufficient temporary folder capacity