[MDEV-3659] LP:695006 - Queries with "converting HEAP to Aria" status do not respond to KILL QUERY Created: 2010-12-28  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Philip Stoev (Inactive) Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug695006.xml    

 Description   

Queries for which the SHOW PROCESSLIST shows "converting HEAP to Aria" can not be killed using KILL QUERY. The connection status does not even change to "Killed"

Id: 8
User: root
Host: localhost:52982
db: test
Command: Query
Time: 45
State: converting HEAP to Aria
Info: SELECT * FROM lineitem AS p_l , orders AS p_o WHERE p_l.l_orderkey = p_o.o_orderkey AND p_o.o_orderkey IN ( SELECT c_l.l_orderkey FROM lineitem AS c_l , orders AS c_o WHERE c_l.l_orderkey = c_o.o_orderkey AND c_o.o_orderkey < 70 AND c_o.o_orderkey > 180 ) OR p_o.o_orderkey IN ( SELECT p_l.l_orderkey FROM lineitem AS c_l , orders AS c_o WHERE c_l.l_orderkey = c_o.o_orderkey AND c_l.l_orderkey = 238 ) LIMIT 1

To reproduce, run the query above against the dbt3-s0.001.dump dataset that can be found here:

http://bazaar.launchpad.net/~randgen/randgen/rqg2/files/head:/conf/dbt3/



 Comments   
Comment by Philip Stoev (Inactive) [ 2010-12-28 ]

Re: Queries with "converting HEAP to Aria" status do not respond to KILL QUERY
This code first appeared in maria-5.2 and was added by Monty, that is why I am assigning this bug to him.

The same query in mysql-5.5 is perfectly killable, so it is a regression in terms of the "drop in replacement" principle.

Comment by Michael Widenius [ 2011-01-05 ]

Re: Queries with "converting HEAP to Aria" status do not respond to KILL QUERY
Fix committed into 5.1

Comment by Rasmus Johansson (Inactive) [ 2011-05-10 ]

Launchpad bug id: 695006

Generated at Thu Feb 08 06:50:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.