Why can't TiDB suddenly create or delete tables?

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

Original topic: tidb突然不能创建和删除表是什么原因?

| username: 奋斗的大象

Cannot create and delete tables.

| username: h5n1 | Original post link

Is it an error or cannot be executed? Check if there are any stuck DDL jobs with admin show ddl jobs.

| username: 随缘天空 | Original post link

It is possible that the thread is deadlocked. Execute the following SQL statement to see if you can retrieve any data, and then use the kill command to terminate the process and re-execute the create or delete statement:

SELECT * from information_schema.INNODB_TRX;
| username: 春风十里 | Original post link

How is the cluster status? Can you check with tiup cluster display <your tidb name>? Are there any errors in the tidb.log?

| username: Jellybean | Original post link

Please provide the executed statements, error messages, logs indicating potential cluster anomalies, and monitoring graphs.

| username: Fly-bird | Original post link

How about taking a screenshot, or maybe your user doesn’t have the necessary permissions?

| username: 像风一样的男子 | Original post link

Starting with one sentence, the rest is all guesswork.

| username: 小龙虾爱大龙虾 | Original post link

First, check admin show ddl jobs so that everyone can help you solve the issue.

| username: dba远航 | Original post link

You need to post the error message so that everyone can make a judgment.

| username: forever | Original post link

According to this statement :sweat_smile:

| username: zhanggame1 | Original post link

Please describe the phenomenon and the steps in detail. Is there an error during execution, does it get stuck, or does the modification fail after execution?

| username: TiDBer_小阿飞 | Original post link

Your question leaves a lot to the imagination!

| username: Kongdom | Original post link

Are there any error messages when performing create and delete table operations? Based on what criteria is it determined that this operation cannot be performed?

| username: andone | Original post link

Please post the error log first.