pingcap / pingcap/tidb

can't kill query for CHECK_CONSTRAINTS

Open
#58,080 1 comment 0 reactions 1 assignee Claimed by @lance6716 View on GitHub
affects-7.5 affects-8.1 affects-8.5 component/ddl severity/major type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Please answer these questions before submitting your issue. Thanks!

### 1. Minimal reproduce step (Required)

mysql> kill 1152615042;
Query OK, 0 rows affected (0.20 sec)

mysql> show processlist;
+------------+------+-------------------+--------------------+---------+------+------------+----------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------------+------+-------------------+--------------------+---------+------+------------+----------------------------------------+
| 1152615042 | root | 10.138.0.78:1042 | information_schema | Query | 289 | autocommit | select count(*) from CHECK_CONSTRAINTS |
| 1152615016 | root | 10.138.0.78:16990 | NULL | Query | 0 | autocommit | show processlist |
+------------+------+-------------------+--------------------+---------+------+------------+----------------------------------------+
2 rows in set (0.20 sec)

### 2. What did you expect to see? (Required)
The query is killed.

### 3. What did you see instead (Required)
The query is still running.
### 4. What is your TiDB version? (Required)
master

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.