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

        Issue Links

          Activity

            People

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