Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: DataGrip客户端连接tidb后跑一个sql,取消后实际sql仍在运行且无法kill
【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】After connecting to TiDB with the DataGrip client and running a SQL query, canceling the query still results in the actual SQL running and it cannot be killed.
Impact: Slow SQL alert triggered
The SQL was noticed at 12 PM and intervention began. Executing kill 5675698813792416261; was ineffective, and according to the alert information, it continued running until 2:30 PM.
【Resource Configuration】Navigate to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
【Attachments: Screenshots/Logs/Monitoring】