pingcap / pingcap/tidb

When binding SQL statements in Query Watch, SQL statements with quotation marks at the end do not take effect

Open
#60,871 0 comments 0 reactions 0 assignees View on GitHub
component/pd type/bug
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

Query watch hopes to be compatible with the writing of "SQL TEXT EXACT TO 'select sleep(2);'"

### 1. Minimal reproduce step (Required)

mysql> select * from information_schema.runaway_watches;
Empty set (0.01 sec)

mysql> select * from information_schema.resource_groups;
+---------+------------+----------+-----------+-------------+------------+
| NAME | RU_PER_SEC | PRIORITY | BURSTABLE | QUERY_LIMIT | BACKGROUND |
+---------+------------+----------+-----------+-------------+------------+
| default | UNLIMITED | MEDIUM | YES | NULL | NULL |
+---------+------------+----------+-----------+-------------+------------+
1 row in set (0.00 sec)

mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)

mysql> select sleep(2);
+----------+
| sleep(2) |
+----------+
| 0 |
+----------+
1 row in set (2.01 sec)

mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2)' ;
+----------+
| WATCH_ID |
+----------+
| 10 |
+----------+
1 row in set (0.00 sec)

mysql> select sleep(2);
ERROR 8254 (HY000): Quarantined and interrupted because of being in runaway watch list
mysql>
### 2. What did you expect to see? (Required)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)
mysql> select sleep(2);
ERROR 8254 (HY000): Quarantined and interrupted because of being in runaway watch list
### 3. What did you see instead (Required)
mysql> QUERY WATCH ADD RESOURCE GROUP default ACTION KILL SQL TEXT EXACT TO 'select sleep(2);' ;
+----------+
| WATCH_ID |
+----------+
| 9 |
+----------+
1 row in set (0.01 sec)
mysql> select sleep(2);
+----------+
| sleep(2) |
+----------+
| 0 |
+----------+
1 row in set (2.01 sec)

### 4. What is your TiDB version? (Required)

v8.5.1

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.