Details
-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
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/
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Queries with "converting HEAP to Aria" status do not respond to KILL QUERY
Fix committed into 5.1
Launchpad bug id: 695006
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.