Unable to Delete TiDB Table ERROR 1051

Translated
1

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

Original topic: Tidb 表无法删除 ERROR 1051

| username: Jarry_zhu

Tidb V4.0.16
See the image below, the table service_sequence cannot be deleted

image
image1432×124 4.11 KB

image
image1380×798 63.1 KB

There is no data in the table

image
image1356×452 4.96 KB

This table was created by JPA,

I tried deleting the entire database.

【TiDB Usage Environment】Production, Testing, Research
【TiDB Version】
【Encountered Problem】
【Reproduction Path】What operations were performed to encounter the problem
【Problem Phenomenon and Impact】

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: Kongdom | Original post link

Have you done anything before?

3
| username: alfred | Original post link

Are writing and querying functioning normally?

4
| username: Jarry_zhu | Original post link

There are no special operations,
this is the log of the deletion error

image
image1380×332 477 KB

5
| username: Jarry_zhu | Original post link

Other tables or databases can be written to and queried normally, but this table can’t do anything. The description is still empty.

6
| username: Lucien-卢西恩 | Original post link

Hello, please use tidb ctl to query the status information of the table and provide it for analysis of the issue. TiDB Control 使用说明 | PingCAP 文档中心