Rollingback jobs stuck

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

Original topic: rollingback jobs 卡住

| username: Hacker_jb3C3Hq9

[TiDB Usage Environment] Production Environment
[TiDB Version] v6.5.1
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Issue Phenomenon and Impact]


rollingback ddl jobs blocking
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

| username: h5n1 | Original post link

  1. Check if there are any blocking sessions in mysq.tidb_mdl_view and kill the blocking sessions.
  2. If that doesn’t work, restart all TiDB servers.
| username: Hacker_jb3C3Hq9 | Original post link

I have already restarted all TiDB servers, but it doesn’t work.

| username: h5n1 | Original post link

Similar to this situation: TIDB DDL执行两天了,无法删除 - TiDB 的问答社区

| username: Billmay表妹 | Original post link

Take a look at the content here:

| username: Hacker_jb3C3Hq9 | Original post link

Resolved
Action: First, shut down the TiDB server, leaving only one TiDB server running. Restart this server and check the DDL jobs.

| username: seiya-annie | Original post link

You can check the TiDB logs.

| username: Hacker_jb3C3Hq9 | Original post link

Resolved

| username: system | Original post link

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