pingcap / pingcap/tidb

error message is not clear when interrupted by max_execution_time

Open
#37,574 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
```
mysql> analyze table github_events;
ERROR 1317 (70100): Query execution was interrupted
mysql> show global variables like "%max_execution_time%";
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_execution_time | 1000000 |
+--------------------+---------+
1 row in set (0.03 sec)
```
```
2022-09-02 14:33:43 (GMT+8)TiDB [172.16.4.36:4000](http://172.16.4.36:4000/)[expensivequery.go:75] ["execution timeout, kill it"] [costTime=16m40.094954259s] [maxExecutionTime=16m40s] [processInfo="{id:6532231565966115387, user:haisheng, host:[10.9.110.146:53176](http://10.9.110.146:53176/), db:gharchive_dev, command:Query, time:1000, state:autocommit, info:analyze table github_events}"]
```

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.