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

SHOW PROCESSLIST returns empty result set after KILL QUERY

    XMLWordPrintable

Details

    Description

      --enable_connect_log
       
      --connect (con1,localhost,root,,)
      --let $con_id = `SELECT CONNECTION_ID()`
       
      --echo #
      --echo # This one returns the expected result
      --echo #
      SHOW PROCESSLIST;
       
      --connection default
      eval KILL QUERY $con_id;
       
      --connection con1
      --echo #
      --echo # The one after KILL QUERY returns an empty result set (WRONG)
      --echo #
      SHOW PROCESSLIST;
      --echo #
      --echo # ... and the next one returns the expected result again
      --echo #
      SHOW PROCESSLIST;

      While it is also reproducible on MySQL 5.1-5.6, I'm not filing it upstream, because it's apparently fixed in 5.7 (and hence it has little to no chance to be also fixed in 5.6).

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            1 Vote for this issue
            Watchers:
            2 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.