Queries with "converting HEAP to Aria" status do not respond to KILL QUERY

Bug #695006 reported by Philip Stoev on 2010-12-28
6
This bug affects 1 person
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://bazaar.launchpad.net/~randgen/randgen/rqg2/files/head:/conf/dbt3/

Philip Stoev (philip-stoev) wrote :

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.

Changed in maria:
milestone: none → 5.2
assignee: nobody → Michael Widenius (monty)
Michael Widenius (monty) wrote :

Fix committed into 5.1

Changed in maria:
status: New → Fix Committed
Michael Widenius (monty) on 2011-05-10
Changed in maria:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers