Queries with "converting HEAP to Aria" status do not respond to KILL QUERY
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Michael Widenius |
Bug 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://
Changed in maria: | |
status: | Fix Committed → Fix Released |
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.