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

            Assignee:
            serg Sergei Golubchik
            Reporter:
            elenst Elena Stepanova
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: