Abnormality in Creating Index in TiDB 7.1, Prompt Indicates No Path

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

Original topic: TiDB7.1创建索引异常,提示没有路径

| username: caorui

[TiDB Environment] Test environment
[TiDB Version] v7.1.0
[Reproduction Path] Connect to TiDB, execute the create index statement, and receive the error “no such file or directory”
[Encountered Problem: Symptoms and Impact] Unable to create index
[Attachment: Screenshot/Log/Monitoring]

| username: tidb菜鸟一只 | Original post link

Did you upgrade it? Manually create the path and assign permissions.

| username: xfworld | Original post link

How much space is reserved for the /tmp directory? Can you check it?

| username: caorui | Original post link

Under what circumstances would this path be used? My table currently has no data, so there’s no situation where the data volume is too large. This cluster is one that I set up directly. I found that the same SQL can be executed on version v4.0.3. Should I grant permissions for this path to the tidb user?

| username: caorui | Original post link

The /tmp directory is not on a separate partition; it is under the root path. Currently, there is still 4.4G of disk space available under the root path. However, there is no data in this table at the moment.

| username: ShawnYan | Original post link

The same issue, just manually create it.

mkdir -p /tmp/tidb/tidb_ddl-4000
| username: tidb菜鸟一只 | Original post link

Well, after creating it, you still need to assign permissions. This is a bug in version 7.1.

| username: caorui | Original post link

Okay, thank you.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.