Error When Adding Index

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

Original topic: 添加索引报错问题

| username: 希希希望啊

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.1.3
[Reproduction Path] Adding Index
[Encountered Problem: Phenomenon and Impact] ALTER TABLE ddacare.row_info
ADD INDEX INDEX_ID(id);
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachment: Screenshot/Log/Monitoring]

| username: hey-hoho | Original post link

This is an old issue, refer to:

If you have any questions, you can search the forum first, most of the problems have already been encountered by others.

| username: kelvin | Original post link

Indeed, it’s an old issue.

| username: Kongdom | Original post link

It is recommended to search before asking :yum:

| username: 希希希望啊 | Original post link

The person above posted a link that perfectly solves the problem.

| username: Kongdom | Original post link

:handshake: :handshake: :handshake:

| username: TiDBer_QYr0vohO | Original post link

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

| username: DBAER | Original post link

It seems the issue is an error indicating insufficient disk space. :slight_smile:

| username: TiDBer_RjzUpGDL | Original post link

Not enough disk space

| username: TiDBer_HUfcQIJx | Original post link

Disk space issue

| username: dba远航 | Original post link

Insufficient disk space, I have also encountered index corruption before.

| username: yytest | Original post link

Take some time to study it as well.

| username: linnana | Original post link

Insufficient disk space

| username: 濱崎悟空 | Original post link

I encountered this locally, and it didn’t seem to be related to disk space. It was resolved after reinstalling.

| username: lemonade010 | Original post link

Disk space, directory permissions

| username: 鱼跃龙门 | Original post link

Take a look at this, space and directory permissions.

| username: TiDBer_H5NdJb5Q | Original post link

No directory or the current user does not have permission.