Bug #120974 Client connection kill command doesn't kill process

Submitted: 21 Jul 18:54 Modified: 22 Jul 8:43
Reporter: Valerie Rentz Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Information schema Severity:S2 (Serious)
Version:8.0.34-26 OS:Any
Assigned to: CPU Architecture:Any

[21 Jul 18:54] Valerie Rentz
Description:
When running an information_schema query, cannot kill the query.

How to repeat:
Connect directly to the MySQL instance using localhost root privileges.  Run the following:

SELECT TABLE_ID, NAME
FROM INFORMATION_SCHEMA.INNODB_TABLES
WHERE TABLE_ID = 12345678;

The query runs a long time.  

Attempt to kill the process using any kill command, normal, etcetera.  The status says killed.
Connect again using the privileged user.
Now have original process and another duplicated process running.

| 1704  executing  SELECT TABLE_ID, NAME FROM INFORMATION_SCHEMA.INNODB_TABLES
WHERE TABLE_ID = 12345678 | 1662990 |         0 |             0 |
| 1849  executing  SELECT TABLE_ID, NAME FROM INFORMATION_SCHEMA.INNODB_TABLES
WHERE TABLE_ID = 12345678 |  320291 

This appears to affect these types of queries.  

Suggested fix:
The kill command using a privileged user should be able to do just that.
[22 Jul 7:36] Shane Bester
Percona versions and 8.0.x are not supported.
Let us know if this is reproducible on 8.4.10 from dev.mysql.com

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.048 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.