When creating an index for a table, it keeps showing "processing". There is a tmp_ddl-4000 directory, and the permissions are also set to tibd

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

Original topic: 给表创建索引的时候一直显示正在处理,是有tmp_ddl-4000这个目录的,并且权限也是tibd

| username: TiDBer_dznKmIie

When creating an index for the table, it keeps showing “processing.” There is a tmp_ddl-4000 directory, and the permissions are also set to tibd.

| username: redgame | Original post link

Yes, that’s right.

| username: 胡杨树旁 | Original post link

Run admin show ddl jobs to check if the number of rows backfilled is normal. Also, is it possible that the table is relatively large, which might cause the index creation to take longer?

| username: TiDBer_dznKmIie | Original post link

This table doesn’t have much data, just over 60,000 rows. It has been in the executing state all the time, with no response at all.

| username: 胡杨树旁 | Original post link

Is it possible that there are too many DDL operations being executed and they are queued up? After canceling all of them, try executing just one to see if it works?

| username: TiDBer_dznKmIie | Original post link

It’s working now. There was a table with 100 million records queued up in front, and it was resolved after canceling it. Thank you.

| username: cy6301567 | Original post link

There are quite a few tasks, let’s queue them up one by one.

| username: system | Original post link

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