After connecting to TiDB with the DataGrip client and running an SQL query, the query continues to run even after cancellation and cannot be killed

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

Original topic: DataGrip客户端连接tidb后跑一个sql,取消后实际sql仍在运行且无法kill

| username: zhihui

【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】