[MDEV-6728] KILL QUERY executed on an idle connection can interrupt the next query Created: 2014-09-10  Updated: 2015-02-02  Resolved: 2015-01-19

Status: Closed
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5.39, 10.0.13, 10.1.0
Fix Version/s: 10.0.16

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: upstream-fixed


 Description    

--connect (con1,localhost,root,,)
 
 
 
--let $con_id = `SELECT CONNECTION_ID()`
 
 
 
--connection default
 
 
 
eval KILL QUERY $con_id;
 
 
 
--connection con1
 
 
 
--error ER_QUERY_INTERRUPTED
 
SELECT * FROM mysql.user;
 
 
 
--disconnect con1

Result:

SELECT * FROM mysql.user;
 
ERROR 70100: Query execution was interrupted

Also reproducible on MySQL 5.1-5.6, but seems to have been fixed in 5.7, so there is no point at filing the bug report upstream.



 Comments   
Comment by Elena Stepanova [ 2014-11-16 ]

Moving to upstream-fixed because it's not reproducible on 5.7, hence no upstream bug report, hence no reason to wait for an upstream fix.

Generated at Thu Feb 08 07:14:08 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.