Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3659

LP:695006 - Queries with "converting HEAP to Aria" status do not respond to KILL QUERY

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    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/

      Attachments

        Activity

          People

            monty Michael Widenius
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.