Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: 给表创建索引的时候一直显示正在处理,是有tmp_ddl-4000这个目录的,并且权限也是tibd
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.
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?
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.
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?
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.
There are quite a few tasks, let’s queue them up one by one.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.