TiDB failed to delete database table, many running jobs remain in canceling state after cancellation, unable to proceed. Delete command not executed, table has 0 rows

translator_bot · June 21, 2024, 8:00pm

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

Original topic: TiDB 删除数据库表, 数据库失败, 很多运行的jobs, 取消之后变成都在canceling的状态,无法该处 .删除命令没有执行表是0行数据

| username: 济南小老虎

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

translator_bot · June 21, 2024, 8:00pm

| username: 大飞哥online | Original post link

It looks like we need to resort to the reboot method.

translator_bot · June 21, 2024, 8:00pm

| username: ajin0514 | Original post link

Have you tried restarting?

translator_bot · June 21, 2024, 8:00pm

| username: 济南小老虎 | Original post link

Restarted, didn’t work.

translator_bot · June 21, 2024, 8:00pm

| username: 济南小老虎 | Original post link

Restarted, but it didn’t work.

Start instance 192.168.254.72:9093 success
Starting component node_exporter
        Starting instance 192.168.254.72
        Start 192.168.254.72 success
Starting component blackbox_exporter
        Starting instance 192.168.254.72
        Start 192.168.254.72 success
Restarted cluster `erptidb` successfully
[root@tidb01 ~]# /deploy/mysql
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 621
Server version: 5.7.25-TiDB-v6.5.3 TiDB Server (Apache License 2.0) Community Edition, MySQL 5.7 compatible

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> drop database xxxx
    -> ;

It’s been more than an hour, still no response.